How to Convert a Bank Statement PDF to Excel — and Check That Every Row Is Right

Why copying from the PDF goes wrong

Inside a PDF there are no rows and no cells. There are pieces of text, each with a position on the page; the table you see is an impression made by how they line up. Copy a page and you get those pieces in whatever order the file stores them. Typical results:

• Columns run together. The date, description and amounts arrive as one line of text per row, or each on a line of its own.
• Long descriptions break apart. "NEFT SALARY CREDIT ACME LTD UTR N3456…" set over three lines becomes three rows, two of them without a date or an amount.
• Every page brings its header along. The bank's name, the account number, the column headings and "Page 2 of 3" turn up in the middle of the transactions.
• The direction of money can disappear. On a statement with separate Withdrawals and Deposits columns, an amount pasted without its column is just a number.

What a statement needs that a table does not

Reading the table is half the job; a general PDF-to-Excel tool, ours included, does it and stops there. We converted the same statements both ways — once as plain tables with PDF to Excel, once as statements:

The rows with no amount are headers, footers and the second and third lines of descriptions. Turning tables into a statement means deciding which column is which from the headings the statement prints, joining a description's lines back together — including layouts that put its first line above the date — dropping what repeats on every page, giving each amount its direction, and settling dates like 03/04 and statements that cross a new year.

Check the result with one formula

A statement prints the balance after every transaction, and that is a sum you can do yourself: the previous balance plus this row's amount must equal this row's balance. In a sheet with amounts in column E (money out negative) and balances in column F, put this in H3 and fill it down:

=ROUND(F2+E3-F3,2)

Every row should show 0. A row that does not was misread, merged with its neighbour or dropped, and the figure says how far out it is. We tried it in Excel on a converted statement — 59 rows, all 0 — and on the same statement with one balance changed by $10: two rows showed -10 and 10, the changed row and the one after it, which starts from the wrong balance. As a second check, the total of the Amount column should equal the closing balance minus the opening balance.

Bank statement to Excel runs that check for you: it reports how many rows add up next to the download, and its Balance check column says OK, or the balance the row should have had, on every row.

How to convert a bank statement PDF

1. Download the statement from online banking as a PDF — a downloaded statement is a text PDF, which is what this needs
2. Open Bank statement to Excel, or Bank statement to CSV for budgeting apps and accounting imports
3. Drop the PDF in
4. Read the line under the result — "running balance adds up on 60 of 60 rows" — and download

The file is read inside the page. A statement holds your account number, your balance and every payee you paid; there is no reason for a copy of it to end up on someone else's server, and here none does.

Measured on twelve statements

Nine statements were generated with a known answer for every field, in the layouts that cause trouble: US checking and credit card, a card statement in sections, UK, German and Chinese statements, wrapped descriptions, newest-first order and 1,500 transactions. Three more came from the test samples of an open-source statement parser, in Indian layouts with three-line descriptions.

Converting took under half a second for an ordinary statement and under a second for 1,500 transactions, timed from choosing the file to the download being ready, in Chrome on an ordinary laptop. Measured on 26 October 2026.

What it does not do

• Scanned statements. A scan has no text to read. Running OCR first gives it some, but recognition reads lines, not cells, so check the result row by row.
• Password-protected PDFs. Open the statement in your PDF reader and save a copy without the password first.
• Statements without a table. One that writes transactions as running text, with no column headings, is reported as such rather than guessed at.
• Categories. The output is what the statement says; sorting transactions into groceries and rent is a job for the spreadsheet or the budgeting app.