Convert a PDF bank statement to Excel
Drop the PDF below and get an .xlsx file back: one row per transaction, with dates in date cells and amounts in number cells, so you can sort, filter and total the column without cleaning anything up first.
Before you export, StatementSnap adds up what it read and checks it against the opening and closing balances printed on your own statement. That is the difference between a file you can trust and a file you have to check by hand.
Drag a PDF bank statement here, or tap to choose a file
PDF only · up to 25 MB · up to 60 pages
Why a PDF statement is harder than it looks
A PDF does not contain a table. It contains characters, each with a position on the page. What you see as a Description column is really a few hundred pieces of text that happen to start at roughly the same horizontal offset, and what you see as a row is text that happens to share a vertical one.
That is why a copy-and-paste into Excel produces a single mangled column, and why generic PDF-to-Excel converters do well on invoices and badly on statements. Statements wrap long descriptions onto a second line, put debits and credits in separate columns that are mostly empty, repeat headers on every page, and interleave summary blocks between the transactions.
Reading the layout is the part a model is good at. Knowing whether it got it right is arithmetic, and that runs in our code.
What the Excel file contains
One sheet, one row per transaction, with the columns below. Everything is editable in the table before you export — fix a description, correct an amount, delete a row that is not a transaction, and the balance badge updates as you type.
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-04-03 | CARD PURCHASE HARDWARE STORE | -120.45 | 879.55 |
| 2026-04-15 | DIRECT DEPOSIT EMPLOYER PAYROLL | 2500.00 | 3379.55 |
| 2026-04-22 | MONTHLY SERVICE FEE | -35.55 | 3344.00 |
Amounts are numeric cells with a currency format, and dates are real dates. Nothing arrives as text you have to convert.
Converting a statement, step by step
- Download the statement as a PDF from your bank’s website — the desktop site, not the app, which usually only shows statements rather than letting you save them.
- Drop the file on the box above. No account needed to start.
- Wait for the table. A few seconds for a text statement, longer for a scanned one.
- Check the badge. Green means the transactions add up to the closing balance. If it is not green, the rows that need attention are flagged.
- Export to Excel.
Your bank not obvious? Download instructions for 150 institutions.
Questions
- Can't Excel open a PDF by itself?
- Excel has a Get Data → From PDF option built on Power Query, and on a simple document it works. Statements are not simple documents: Power Query looks for ruled tables, and most statements draw their columns with whitespace rather than borders, so it either finds no table or finds one table per page and splits the transaction list across them. It also has no idea what the numbers mean, so it cannot tell you whether anything was missed.
- Why do amounts sometimes come through as text in other converters?
- Because a PDF stores "1,234.56" as characters, and anything that writes those characters straight into a cell produces text that happens to look like a number. Excel then refuses to sum the column, and the fix is a manual find-and-replace on every row. Our export writes numeric cells with a currency format applied, so SUM works on the file as downloaded.
- What about dates?
- Same problem, worse consequences. A statement might print 03/04 with no year, or 3 APR, or 2026-04-03. We resolve the year from the statement period and write real date cells, so sorting by date sorts chronologically rather than alphabetically.
- How many pages can I convert at once?
- Up to 60 pages and 25 MB in a single upload. If your statement is longer, split the PDF and convert each part — page credits are counted per page, so nothing is wasted either way.
- Does it work on a scanned statement?
- Yes. If a page has no text layer we render it and read it as an image instead. It is slower and the reconciliation check matters more, because that is what tells you whether anything was misread.
Other formats
- Bank statement to CSVUTF-8, quoted properly, opens the same everywhere.
- Bank statement to QuickBooksA QBO file for when bank feeds cannot reach the data.
- Credit card statement to ExcelHandles the sign convention that catches most converters out.
Looking for your bank specifically? 150 institutions have their own download instructions — see the list.