How to convert a Wells Fargo statement PDF to Excel or CSV
If you have a Wells Fargo account and need your transactions in a spreadsheet, you can convert the statement PDF on your own computer with StatementLocal. The file is read inside your browser and is never uploaded.
Step 1: download the statement PDF
- Sign in to Wells Fargo's website on a computer. Banking apps often show a statement without an easy way to save the PDF.
- Open the statements or documents section for the account. Banks usually call it something like Statements, or Statements and documents. Menus change, so Wells Fargo's own help pages are the final word on where it is.
- Choose the statement period and download the PDF. Save it where you can find it.
- Use the PDF exactly as downloaded. A statement that was printed and scanned back in has no text layer, and this version of StatementLocal cannot read scans.
Step 2: convert it
- Open the StatementLocal converter.
- Drop the PDF on the page, or choose it.
- Read the verdict at the top of the result:
- Reconciled: the rows add up from the printed opening balance to the printed closing balance.
- Off by $X, check rows N to M: something does not add up. The likely rows are highlighted.
- Cannot check: the statement prints no balances to check against.
- If a row is wrong, fix it in the grid. The verdict updates when you leave the cell.
- Download CSV, Excel (.xlsx) or QuickBooks CSV. You can download 3 statements a day free.
Then combine several months into one sheet
StatementLocal converts one statement per file, so a year of statements gives you twelve downloads. To put them in one sheet:
- Convert every month and check that each one says Reconciled before you combine anything. A month that is off is easier to fix on its own.
- Open the first month's Excel file. Copy the rows, without the header row, from each of the other months and paste them below.
- Sort the whole table by Date, oldest first.
- Check the joins. The closing balance of one statement should equal the opening balance of the next. Where your statements print a running balance, the Balance column should run on from one month into the next without a jump.
Statement periods do not always follow calendar months. A statement dated the 15th covers part of two months, so a month-by-month total built from statements can differ from your own calendar view. That is expected, not an error.
What has and has not been tested
We tested StatementLocal on 200 synthetic (made-up) statements across 10 common US statement layouts, built by our own generator. Every statement it could not verify was flagged with Off by or Cannot check, never shown as Reconciled. We have not tested it on real Wells Fargo statements, and we do not claim it reads every one. That is why every conversion is checked against the statement's own printed balances: if an amount is missed or misread, the totals stop adding up and you see Off by instead of Reconciled.
More answers are in the FAQ, and the privacy page lists exactly what the page sends (nothing, unless you use Pro).
StatementLocal is not affiliated with, endorsed by or sponsored by Wells Fargo or its parent company. The name is used only to say whose statements this guide is about.
Need more than 3 statements a day? Buy the 30-day pass for $9 or Buy Lifetime for $39. One-time payments, taken by Stripe. Sold to US customers only.
Use Chrome? The same converter is also a Chrome extension: Add to Chrome from the Chrome Web Store.