PDF bank statements and Excel
How to Get a PDF Bank Statement into Excel
Reviewed 12 September 2026
Short answer
Short answer
There are three sensible ways to move a PDF bank statement into Excel. Copy and paste can work for a short, simple table. Power Query can detect tables inside some PDFs. A bank-specific converter is usually quicker when descriptions wrap across lines, headers repeat, debit and credit formats vary, or several statements need to be combined.
Excel is good at working with transaction data. The difficult part is turning a document made for reading into one clean row per transaction.
Choose the method that matches the statement
Try the free route first if the job is small. Copy one table into a blank sheet or use Data, Get Data, From File, From PDF where your Excel version supports the PDF connector. Microsoft says the Navigator will show the tables it can detect, which you can load directly or transform in Power Query.
A bank statement is not always one tidy table. Repeated page furniture, wrapped descriptions, separate balance columns and missing years can turn a quick import into a cleanup job. AussieBankStatements handles those details with a separate parser for each supported Australian bank and returns CSV, which Excel opens directly.
Step by step
- 01
Try the bank export
If the bank offers CSV or OFX for the period, use that structured file before touching the PDF.
- 02
Test Excel's PDF connector
In a supported Excel version, open Data, Get Data, From File, From PDF and inspect the detected tables.
- 03
Check the first and last rows
Look for lost descriptions, repeated headers, reversed amounts and dates without a year.
- 04
Use a specialist if cleanup grows
For supported Australian banks, convert the original PDF into a checked CSV rather than rebuilding every row by hand.
- 05
Open the CSV in Excel
Keep the source PDF beside the spreadsheet and verify the date range and balances before analysis.
Checks before you rely on the spreadsheet
- Every transaction occupies one row.
- Date cells are real Excel dates.
- Debit and credit direction agrees with the statement.
- No page header has become a transaction.
Excel documentation used in this guide
Microsoft documentation checked 12 September 2026.
Questions people ask
Can Excel import a PDF bank statement directly?
Some versions of Excel include a Power Query PDF connector. It detects tables in the PDF, but the result still depends on how the bank constructed the statement.
Why does my PDF paste into one Excel column?
PDFs store positioned text rather than spreadsheet cells. Copy and paste can lose the visual column boundaries, particularly when descriptions wrap.
Does AussieBankStatements create an XLSX file?
It creates CSV, which opens directly in Excel. CSV keeps the transaction rows portable and avoids workbook-specific formatting.