How to convert a bank statement PDF to Excel
Four ways to get bank statement PDFs into Excel — copy-paste, Excel's PDF import, bank CSV downloads and statement converters — and how to check the result.
Key takeaways
- Copy-paste and Excel's built-in PDF import work for one clean statement but break on multi-page tables and wrapped descriptions.
- Your bank's CSV download is the cleanest source, but it usually only covers recent activity.
- Whatever method you use, check that the opening balance plus every transaction equals the closing balance.
Banks send statements as PDFs because PDFs are good for reading and printing. They're bad for analysis: you can't sort, filter or total a PDF. Getting the transactions into Excel is the first step to answering any real question about your spending.
Option 1: Copy and paste
Select the transaction table in your PDF reader, copy it and paste it into Excel. On a simple one-page statement this can work. On most real statements it doesn't: columns collapse into one cell, long descriptions wrap onto a second line, and page headers land in the middle of your data.
Option 2: Excel's PDF import
Recent versions of Excel for Microsoft 365 can import tables from a PDF through Get Data. It detects tables page by page, so a statement that runs across five pages arrives as five tables you need to append and clean up. It also can't tell a transaction row from a subtotal or a 'continued on next page' line.
Option 3: Download CSV from your bank
Most online banking sites let you export recent activity as CSV, which opens straight in Excel. This is the cleanest source when it's available. The catch is history: many banks only offer downloads for a limited window, and older months often exist only as PDF statements. Card accounts you've closed may not offer it at all.
Option 4: Use a statement converter
A converter reads the PDF and returns a table of transactions. The good ones handle multi-page tables and wrapped descriptions, and work across banks without a template for each layout. PaperSpend does this and goes a step further: it checks the result against the statement's own balances, categorizes each transaction, and exports to CSV or Excel.
Always check the result
Whatever method you use, do one check before trusting the spreadsheet: opening balance plus the sum of all transactions must equal the closing balance, to the cent. If it doesn't, a row is missing, duplicated or has a misread amount. Our guide to reading a bank statement shows where to find those numbers.
- Sum the amounts column, with debits negative and credits positive.
- Add the opening balance.
- Compare with the closing balance. Any difference means the data is incomplete.
Which method should you use?
For a single recent month from one bank, a CSV download is hard to beat. For a year of statements, several banks, or accounts you've closed, a converter that reconciles each statement saves hours and catches mistakes you wouldn't spot by eye. You can see how PaperSpend works or compare plans.
Frequently asked questions
Can Excel open a PDF bank statement directly?
Excel for Microsoft 365 can import tables from a PDF using Get Data, but multi-page statements usually arrive as several tables that need combining and cleaning.
Why does copy-pasting a bank statement into Excel put everything in one column?
PDFs store text by position on the page, not as table cells, so the column structure is often lost when you paste.
How do I check a converted bank statement is complete?
Add every transaction to the opening balance. The result must equal the statement's closing balance exactly; any difference means a row is missing or wrong.
Can I convert old bank statements to Excel?
Yes. Banks often limit CSV downloads to recent activity, but a PDF statement converter can read statements of any age.
