SOYATOOLS / GUIDES
How to convert a bank statement PDF to Excel or CSV
A bank statement PDF looks like a table, but copying it into Excel usually gives you merged columns, broken descriptions and amounts stored as text. You can ask for a spreadsheet download, try Excel’s own PDF import, or use a converter that reads the statement layout and checks every balance before you save.
Why statement PDFs are hard to get into Excel
A PDF stores text positioned on a page, not rows and cells. Statements add their own problems: money in and money out may be separate columns or one signed column, some banks print CR/DR markers or put negative amounts in parentheses, descriptions wrap onto a second or third line, and some statements list the newest transaction first. When a converter gets one of these wrong, the table still looks plausible, so the mistake is easy to miss. That matters when the spreadsheet goes to an accountant, a tax return or a loan application.
Free options to try first
- Ask for a spreadsheet download. Check whether your online banking offers a CSV, Excel or other export of transactions for the same period. A file produced directly by the bank avoids PDF conversion altogether, so it is the most reliable source when it is available.
- Copy and paste. For a page or two, selecting text in a PDF viewer and pasting into Excel can work, but expect to split columns and fix numbers by hand. It does not work on scanned statements, which contain no selectable text.
- Excel’s own PDF import. In Excel for Windows, choose Data > Get Data > From File > From PDF, select the PDF and choose Open. The Navigator lists the tables Excel found; choose Load, or Transform Data to clean it up in Power Query first (Microsoft Support). Microsoft’s Excel team has said the PDF connector is part of Microsoft 365 for Excel on Windows and of Excel 2021, and that Excel 2019 does not have it (Excel blog). Microsoft also notes that rows spread over several lines are not always identified properly (Power Query PDF connector), which is common in statement descriptions.
Whichever route you take, Excel will not tell you whether a row was misread. A quick check is a helper column with =previous balance + money in − money out compared against the printed balance.
Convert it with Statement PDF to Excel
Statement PDF to Excel does that balance check for you. It converts the statement into an Excel (.xlsx) or CSV table on your PC and shows the table beside the PDF page.
- Install the app from Microsoft Store and open the bank statement PDF in it. Password-protected PDFs open with their password; the password is not saved.
- Compare the extracted table with the PDF. If the layout is unusual, assign the column roles yourself; the app remembers those choices for the same layout.
- Review the rows marked red. For each row the app checks that the printed balance equals the previous balance plus money in minus money out, and it also checks the opening and closing totals. A row that does not add up is shown with its expected balance.
- Check dates and descriptions too, correct any cell by hand, and run the check again.
- Save as Excel or CSV.
Layouts the app reads: separate money-in and money-out columns, a signed amount column, CR/DR markers, parentheses and trailing minus signs, different number formats, newest-first statements and descriptions over several lines.
Free and Pro
| Plan | Price | Included |
|---|---|---|
| Free | Free | 20 pages per calendar month on this PC. Text PDFs to Excel/CSV, balance checks and column roles. |
| Pro monthly | $6.99/month | Unlimited pages, scanned PDFs with Windows OCR (beta), QuickBooks Online CSV, Xero CSV, QIF, OFX, and several files at once. |
| Pro yearly | $49.99/year | The same Pro features. |
Pro includes a 1-week free trial. Subscriptions and trial availability are handled by Microsoft Store.
Limits to know before you rely on the result
- A successful balance check covers amounts and balances. It does not prove that dates or descriptions were read correctly.
- Scanned PDFs are a Pro beta feature. Blurry, tilted or low-resolution scans can be read incorrectly.
- Version 1 does not support credit card statements or several accounts in one PDF; the app warns when it detects them.
Reading, OCR, checking and conversion take place on your PC. There is no statement upload. See the Privacy Policy for local usage records and settings.
FAQ
Is my bank statement uploaded anywhere?
No. Statement PDF to Excel reads, checks and converts the PDF on your PC. Microsoft Store handles subscriptions and licenses.
What do I get without paying?
20 pages per calendar month on that PC: text PDFs to Excel or CSV, balance checks and column roles. Scanned PDFs, the accounting formats and several files at once need Pro.
Can it read a scanned or photographed statement?
With Pro, using Windows OCR. It is a beta feature, and blurry, tilted or low-resolution scans can be misread, so check the marked rows and the dates and descriptions.
Can I import the result into QuickBooks Online or Xero?
Pro can save QuickBooks Online CSV and Xero CSV, as well as QIF and OFX. SoyaTools is not affiliated with Intuit or Xero.
Does it work with credit card statements?
Not in version 1. Credit card statements and PDFs containing several accounts are not supported; the app warns when it detects them.