How to convert a bank statement PDF to Excel

Updated: 2026-10-14

Copying transactions out of a PDF by hand is slow and easy to get wrong. Here's how to turn a statement into a spreadsheet in a few seconds, and how to check the result.

Why copy and paste doesn't work

A PDF doesn't store a table. It stores words at positions on a page. When you copy a few rows, columns run together, descriptions that wrap onto a second line become separate rows, and amounts like 1.234,56 or (45.20) end up as text that Excel won't add up.

Convert it in your browser

Open Bank statement to Excel and drop your PDF statement on the page.
Choose Excel (.xlsx), or CSV if you're importing into accounting software.
Click Convert to Excel, check the preview, and download the file.

The converter finds the transaction table on every page and lines up the columns. It joins descriptions that wrap over several lines into one row, and stores amounts as real numbers. Minus signs, brackets, trailing minus signs and Dr markers all become negative numbers. A second sheet holds all the text of the statement, including account details and totals outside the table.

Bank statements are some of the most private documents you have. This converter runs on your device: the statement is never uploaded.

Scanned or photographed statements

If the statement is a scan, there's no text in the PDF, only a picture of it. The converter notices this and reads the page with OCR (text recognition) first. OCR is very good on clean scans but not perfect, so check the amounts afterwards. The tips below make that quick.

Check the result in two minutes

Count the rows. Compare the number of transactions with the statement. Most statements show a count, or you can count a page.
Check the balance. Opening balance + credits − debits should equal the closing balance. In Excel, =SUM() the amount column and compare.
Look at the edges. The first and last rows of each page are where problems usually appear.

Other tables work too

The same tool handles invoices, price lists and reports exported from accounting systems. For general tables, use PDF to Excel.