How to convert bank statements to Excel
By the Banking Converter editorial team
Published
The reliable way to convert a PDF bank statement to Excel is a converter that reads the transaction table, writes real date and number cells, and checks that opening balance plus credits minus debits equals the closing balance. Copy and paste, Excel's own PDF import and manual typing all work for a page or two but break down on wrapped descriptions, scanned pages and long statements.
The four methods compared
| Method | Works for | Fails on | Checks balances? |
|---|---|---|---|
| Copy and paste from the PDF | Short text PDFs with a simple table | Wrapped descriptions, columns that collapse into one, scanned pages | No |
| Excel Data, Get Data, From PDF | Text PDFs where Excel detects the table | Multi-page tables split into pieces, merged cells, non-US number formats | No |
| Manual typing | A handful of rows | Anything longer; error-prone | Only if you add formulas |
| Statement converter with reconciliation | Text and scanned PDFs from any bank; password-protected PDFs on paid plans | Illegible scans (reported as an error rather than guessed) | Yes |
Converting with a reconciliation-checked converter
- Open the bank statement to Excel converter and drop the PDF in. The file is inspected and you see the page count and whether it is text or scanned.
- Choose Excel as the output. Pick the date format you want in the cells (ISO, US or UK/EU).
- Convert, then review. Flagged rows (merged descriptions, low OCR confidence, balance breaks) are listed with a reason; click one to see the source line on the PDF page.
- Download the workbook. The Transactions sheet has real date and number cells with a frozen header and filters; the Statement Information sheet has balances and totals; the Conversion Report sheet lists which checks passed.
Because the converter reconciles the statement before you download, you do not need to add checking formulas yourself, although you can: SUM of the Credit column minus SUM of the Debit column should equal closing minus opening balance.
Using Excel's built-in PDF import
Excel for Microsoft 365 can open a PDF through Data, Get Data, From File, From PDF. Power Query lists each table and page it detects. It is worth trying for a clean, single-page text statement. The typical problems are:
- Each page becomes a separate table with its own header, which you have to append by hand.
- Descriptions that wrap onto a second line arrive as separate rows with empty amount cells.
- Numbers formatted as 1.234,56 or with a trailing CR/DR are imported as text.
- Nothing checks that the rows are complete.
How to check the result
- Balance equation: opening balance + total credits − total debits = closing balance.
- Running balance: if the statement prints a balance per row, each balance must equal the previous balance plus that row's amount. A single misread digit shows up here immediately.
- Row count: compare the number of transactions to the count printed in the statement summary, if there is one.
- Dates: every date must fall inside the statement period, and the sequence should not jump backwards unless the bank orders by posting date.
The Conversion Report sheet performs these tests automatically and lists any failures with the rows involved.
If the statement is scanned
Copy and paste and Excel's importer only work on text. For a scanned or photographed statement you need OCR. See how to convert scanned bank statements for scan settings and how to review OCR output.
Frequently asked questions
Will the dates be real Excel dates?
With the converter, yes: they are date cells, so sorting and month grouping work. With copy and paste they are usually text and need Text to Columns or DATEVALUE.
Can I convert several months into one workbook?
Yes on paid plans: upload the statements as a batch and merge the conversions into one export. The Account and Page columns identify where each row came from.
Other bank statement converters
About the author
The Banking Converter editorial team is the engineering group that builds and tests the conversion engine: the parsers for regional date and number formats, the reconciliation checks and the CSV, Excel, JSON, OFX and QBO exporters. Guides describe what the software does and what the formats require; they are not financial, legal or tax advice.