Guide · bank statements

Convert a bank statement PDF to Excel

Statements are the hardest thing to retype and the most sensitive thing to upload. Here is how to get the transactions into a spreadsheet without doing either.

Most banks will hand you a PDF and nothing else, especially for closed accounts, older periods, or business accounts on a legacy platform. If you are reconciling, preparing a tax return, or building a cash-flow model, that PDF has to become rows.

Open the converter

Check the bank first. Before converting anything, log into online banking and look for a CSV, QIF or OFX download. If it exists, use it — it will be cleaner than any extraction. Conversion is for when that option is not there.

Doing it without uploading the statement

The usual objection to online converters is a fair one: a statement carries your name, your account number, your address and every place you spent money for a month. Sending it to an unknown server is a genuine risk, and in a firm it may breach the data policy you signed.

This converter reads the PDF with JavaScript running inside your own browser tab. The bytes go from your disk into the page and no further. You can prove it: load the page, disconnect from the internet, then convert the file. It still works, because there was never a server involved.

Step by step

Download the statement from online banking as a PDF. Statements generated by a bank are text-based, which is what the converter needs.
Open the converter and drop the file in.
Leave Combine pages into one table switched on. A statement is one continuous transaction list, so you want a single sheet rather than one per page.
Leave Skip page headers and footers on as well. It removes the repeated branch address, page numbers and marketing lines that otherwise appear between every page's transactions.
Set the page range to skip the cover page and the terms at the back — typically something like 2-6.
Adjust Column spacing until date, description, debit, credit and balance sit in separate columns.
Download the XLSX.

The four problems specific to statements

Debit, credit and balance collapse into one column

Money columns are right-aligned and often sit within a few millimetres of each other. Lower the column spacing until they separate. If they will not separate cleanly, export anyway and split the column in Excel with Data → Text to Columns → Delimited → Space.

Long descriptions wrap onto a second row

A merchant name plus a reference can run past the column width, producing a row with only the description filled in. The header and footer filter removes most of these. For the rest, join them in the sheet with =B2&" "&B3 and delete the spare row.

Dates only appear on the first transaction of a day

Many statements omit the repeated date. Fill it down after export: select the date column, press F5, choose Special → Blanks, type = then the up arrow, and confirm with Ctrl+Enter.

Amounts import as text

Currency symbols and bracketed negatives stop Excel recognising a number. Strip the symbol with find-and-replace, convert (120.00) to -120.00, then select the column and run Text to Columns → Finish to force a re-parse. Sum the column and compare it with the closing balance on the statement — if they match, nothing was lost.

Combining a year of statements

Convert each month separately, then stack them. Keep the column order identical across all twelve so the rows line up, and add a column for the source month before you paste them together. Sort by date at the end. If a description column has been split differently in one month, fix that month before stacking rather than after.

Questions

Is it safe to convert a bank statement online?

With most online converters the statement is uploaded to someone else's server. This converter parses the PDF in your own browser, so the file is never transmitted and there is no copy on a third-party system.

Can I convert several months of statements at once?

Convert each PDF separately, then paste the resulting sheets under one another in Excel. Keep the column order identical so the stacked rows line up.

Why is the balance column merging with the amount column?

Right-aligned money columns often sit close together. Lower the column spacing setting until the two separate, or split the merged column after export using Text to Columns.

Will this work with a scanned statement?

No. A scan contains an image of the page rather than text. Statements downloaded from online banking are almost always text-based and will work; a photograph or a fax will not.

For tables that are not statements — invoices, reports, published data — start with the general PDF to Excel guide.