How to Convert a Bank Statement PDF to Excel: 4 Methods

Every way to turn a bank statement PDF into a usable Excel file — copy-paste, Excel's importer, OCR and dedicated converters — and when each one works.

There are four ways to get a bank statement out of a PDF and into Excel. Three of them work some of the time. This guide covers all four honestly, including where each one falls apart, so you can pick the right one for the file in front of you.

Method 1: Copy and paste

Select the text in your PDF reader, copy, paste into Excel. It is free and takes ten seconds.

It also almost never produces columns. PDFs have no concept of a table — a PDF stores characters at coordinates on a page. When you copy, you get a stream of text with the spatial relationships thrown away. Everything lands in column A.

Worth trying when: you have a handful of rows and don't mind cleaning them up by hand. Don't bother when: the statement is more than a page.

Method 2: Excel's built-in PDF import

Excel has had Data → Get Data → From File → From PDF since 2019. It uses Power Query to detect tables in the PDF.

On a well-formed PDF with full grid lines, this works. On bank statements it usually doesn't, because most banks don't draw complete grids. Power Query looks for a closed rectangular structure; with only vertical rules — HDFC's layout, for example — it finds nothing and returns the page as one text blob.

It also has no idea what a bank statement is. Section subtotals, daily balance summaries and account headers all come through as data rows. There's a fuller breakdown in why Excel's PDF import fails on bank statements.

Method 3: OCR tools

OCR reads text out of images. If your statement is a scan or a photo, this is the only option — there is no text layer to extract.

But if your PDF does have a text layer, OCR is a downgrade. You are throwing away perfect digital text and replacing it with a machine's best guess from pixels. OCR reliably confuses 8 with 3, 5 with 6, and 1 with 7 — and in a financial document those are expensive mistakes that no amount of eyeballing will reliably catch.

Method 4: A dedicated bank statement converter

Purpose-built converters know what a bank statement is. They know that a row without a date is probably a continuation line, that a 12-digit number is a reference and not an amount, that "Total withdrawals" is a summary and not a transaction, and that the balance column can be used to check the work.

That last point is the one that matters most, and it's the reason we built this tool. Every other method gives you a spreadsheet with no indication of whether it's right.

The step that actually matters: verification

Whichever method you use, do this before you trust the output:

Check the row count Compare against the transaction count printed on the statement, if there is one.
Sum the debits Compare with the total debits/withdrawals printed on the statement.
Sum the credits Compare with the printed total deposits.
Walk the balance chain Opening balance, minus debits, plus credits, should equal the printed closing balance.

Step 4 alone is not enough. If a converter drops a whole page, the remaining rows still chain correctly against each other — the file looks internally consistent while being materially incomplete. Only comparing against the bank's own printed totals catches that. This is covered in detail in balance-chain reconciliation.

Which method should you use?

Situation	Best method
One page, a few rows, native PDF	Copy-paste and tidy manually
Native PDF with full table borders	Excel's Get Data From PDF
Scanned or photographed statement	OCR — accept lower accuracy and check carefully
Native PDF, no full borders (most banks)	A dedicated converter
Many statements, or numbers you'll rely on	A dedicated converter with verification

Frequently asked questions

Is it safe to upload a bank statement to an online converter?

It depends entirely on the service. Look for encryption in transit, a clear deletion policy, and no third-party sharing. We cover what to check in is it safe to upload bank statements online.

Can I convert a bank statement to Excel for free?

Yes — our free tier covers 3 pages a day with no signup, or 5 pages a day if you create a free account, resetting every day at 00:00 UTC. Every page of the PDF counts, so a short statement costs nothing, and a longer one converts its first pages and holds the rest back.

What if my bank isn't recognised?

There is no list of recognised banks to be missing from. The reader works from the table on the page, so an unfamiliar layout is read the same way as a familiar one, and a layout it has read before is remembered.

Will the dates come through as real dates?

Not in the Excel or CSV: every date is kept exactly as your bank printed it, as text, so nothing can have been turned the wrong way round. Excel's Text to Columns makes them dates when you need them. The QBO, QFX, OFX and QIF downloads do carry real dates, because those formats require one on every transaction.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.