How to convert a bank statement PDF to Excel

A bank statement PDF looks like a table, but inside the file it is just text placed at coordinates. Here are the four realistic ways to get it into Excel, what each one costs you in time and privacy, and how to check the result.

By Muhammad Sharif · October 2026 · 9 min read

If you have ever selected a transaction table in a bank statement PDF, pasted it into Excel and watched every row collapse into a single column, you already know the problem. A PDF is a print format. It remembers where each piece of text sits on the page, not that a group of those pieces forms a row, or that a column of numbers is a column at all. Every conversion method is really a different way of guessing the table structure back from positions on the page.

This guide walks through the four methods people actually use, in the order most people should try them, and then covers how to verify the output so a quiet extraction mistake does not end up in a client's books or your own tax records.

First: is your PDF text-based or scanned?

Everything below depends on one distinction. A text-based PDF is what online banking generates: the characters are real text, you can click and drag to select them, and search (Ctrl+F) finds a merchant name. A scanned PDF is a photograph of a paper page wrapped in a PDF container. You cannot select words in it, and search finds nothing.

Open your statement and try to highlight a single transaction description with your mouse. If the text highlights, you have a text-based file and methods 1 to 3 will work. If a whole page highlights as one block, or nothing highlights, it is a scan and you need method 4. Our separate guide on scanned versus text-based statements explains this in more detail, including a trick for getting a text-based copy from your bank instead of scanning.

Method 1: copy and paste

The simplest approach is to select the transaction table in your PDF reader, copy it, and paste it into a blank worksheet. It costs nothing and takes ten seconds to try.

When it works: statements with a clean, single-line-per-transaction layout and a small number of rows. Some PDF readers keep column gaps as tabs, and Excel then splits the paste into columns on its own.

Where it breaks:

• Everything lands in column A as long strings, so you need Data → Text to Columns, and the delimiter you pick has to cope with descriptions that contain spaces.
• Descriptions that wrap onto a second line become separate, half-empty rows that you must merge by hand.
• Page headers, footers and "continued" lines are copied in with the data and have to be deleted, one page at a time on a long statement.
• Dates may be reinterpreted. Excel can turn 03/04/2026 into 4 March or 3 April depending on your computer's regional settings, with no warning.

For a one-off, two-page statement that is acceptable. For twelve months of statements, you will spend longer cleaning than converting.

Method 2: Excel's built-in PDF import

Recent versions of Microsoft Excel for Windows and Microsoft 365 include a PDF connector under Data → Get Data → From File → From PDF. It opens a Navigator window that lists the tables and pages Excel detected, and lets you load one into Power Query for cleaning.

When it works: statements where the transaction list is ruled like a proper table, with visible gridlines or very consistent column alignment. Power Query then gives you a repeatable recipe, so you can point the same query at next month's file.

Where it breaks: bank statements are often laid out with whitespace rather than lines, and Excel's table detection can split one transaction list into several fragments across pages, merge the running balance into the description, or drop the first row of each page. You may also find that the feature is missing from older Excel versions or from some editions, so check your own installation before planning around it.

Power Query is worth learning if you convert statements for a living, because every cleaning step you apply is recorded and replayed. But expect to build a different query for each bank, and to adjust it when the bank redesigns its statement.

Method 3: a browser-based converter

Dedicated converters read the PDF, rebuild lines by grouping text fragments at the same height, recognise transactions by pattern (a date, some description text, one or more money values) and give you a CSV or Excel file. They differ in one important respect: where the PDF goes while this happens.

Many online converters upload your file to their servers, process it there and send a result back. That is fine for a utility bill and a poor idea for documents that show your address, employer, account number and every merchant you pay. Others, including the converter on this site, run the whole process inside your browser using a PDF library written in JavaScript, so the file is read from your disk straight into the page's memory and never transmitted. Our guide on whether it is safe to upload bank statements online covers how to tell the difference and how to test any converter's claim yourself.

When it works: any text-based statement with a recognisable transaction pattern, which covers the large majority of downloads from online banking, including multi-page statements and wrapped descriptions.

Where it breaks: unusual layouts (very dense multi-column pages, landscape statements, summaries that mimic transaction rows), password-protected files, and scans. The sensible habit is to treat the output as a draft that you verify, which is the subject of the checking section below.

Method 4: OCR for scanned statements

Optical character recognition turns an image of text into real text. If your only copy of a statement is a scan or a phone photo, OCR is the only route to a spreadsheet. Adobe Acrobat, many scanner apps and several cloud tools include it.

Be realistic about accuracy. OCR confuses 5 and 6, 1 and 7, 0 and O, and commas and full stops, which is exactly the kind of error that moves a decimal point. Every OCR'd number must be checked against the original, and the totals test described below is not optional. Where possible, avoid OCR altogether: log in to your bank and download the statement again as a PDF, or ask the bank for a text-based copy. Banks almost always generate their own statements as text-based files.

StatementHarbor does not run OCR yet, and says so plainly on how it works. If your file is a scan, convert it to searchable text first with OCR software and then run the result through a converter.

How to check the result

A converted statement that looks right can still be wrong. The cheapest and strongest check uses numbers the statement already contains:

1. Row count. Count transactions on the statement, or compare the statement's stated number of deposits and withdrawals if it prints one, with the rows in your sheet.
2. Opening balance plus the sum of all amounts equals the closing balance. In Excel, put the opening balance in a cell and add =SUM(C2:C200) over the amount column. If the result equals the printed closing balance to the cent, every amount was captured with the right sign.
3. Spot-check the edges. Look at the first and last row of each page of the PDF, because that is where page breaks drop or duplicate rows.
4. Check signs on a few known items. Find a payroll deposit and a rent payment and confirm that one is positive and the other negative (or that your debit and credit columns match).

Our reconciliation guide goes through this check step by step, including what to do when the totals are off by an exact transaction amount, which almost always means one row was missed or duplicated.

Which method should you choose?

Frequently asked questions

Related guides

Written by Muhammad Sharif
Founder, StatementHarbor · Last updated October 2026