How to turn a PDF bank statement into an Excel spreadsheet
Banks love PDFs; budgets live in spreadsheets. Here is how to move the transactions across cleanly — and without handing your statement to a stranger.
Updated · 5 min read
A bank statement is one of the most sensitive files most people own. It shows where you live, what you earn, where you shop and who you pay. Yet the most common way to get its transactions into a spreadsheet is to upload it to a free online converter. This guide explains how the conversion actually works, how to get a clean result, and how to do it entirely on your own device.
Why a PDF is hard to turn into a spreadsheet
A PDF does not contain a table. It contains small pieces of text, each with an exact position on the page. What your eye reads as rows and columns is only alignment. A converter therefore has to rebuild the structure from geometry: it groups text sitting on the same horizontal line into rows, then looks for vertical boundaries that repeat across many rows to decide where one column ends and the next begins.
Amounts make this harder than it looks. Descriptions are usually left-aligned, so their starting positions line up. Amounts are right-aligned, so it is their ends that line up while their starts scatter. A converter that only looks at left edges will merge the amount into the description column on roughly half of real statements.
Step by step
- Download the statement from your bank’s website or app as a PDF. A file downloaded from the bank is better than a scan: it has a real text layer.
- Open a converter that runs in your browser, such as our PDF to Excel tool, and add the file. You can add several statements at once — one per month, for example.
- Choose XLSX if you will work in Excel or Google Sheets. Choose CSV only if another program needs it.
- If a single table continues across pages, choose “everything on one sheet” so the transactions stay in one continuous block.
- Check the preview before downloading: the date, description and amount should each be in their own column.
- Download the spreadsheet, or all of them in a single ZIP.
Cleaning up the result
Even a good extraction brings some debris along. Statements have headers with the bank’s name, account summaries, page numbers and legal footnotes. A few minutes of cleanup usually make the sheet ready to use:
- Delete summary rows such as opening and closing balance if you only want the transactions; keep them in a separate sheet if you reconcile balances.
- Check that amounts are numbers, not text. A quick test is to select the column and look at the sum in Excel’s status bar. If no sum appears, the values are text.
- Watch the decimal separator. Statements written as 1.240,55 (Brazil, most of Europe) and 1,240.55 (US, UK) mean the same amount. A good converter reads both and writes a real number.
- Separate debits and credits if your bank puts them in one column with a minus sign, or in two columns. A simple formula such as
=IF(C2<0,-C2,0)splits them. - Join wrapped descriptions. Long descriptions sometimes wrap onto a second line. Good converters attach that line to the row above; check a few long ones.
When it will not work: scanned statements
If you can’t select text in your PDF viewer, the statement is an image — usually a scan or a photo. There is no text to position, so nothing can be extracted without OCR (optical character recognition), which reads the letters from the pixels. OCR is a different process with different errors: a 7 read as a 1 in an amount column is worse than no data at all. If you only have a scan, ask the bank for a digital statement first; most banks provide one for any past month.
Why it matters where the conversion happens
Most online converters upload your file to their server, convert it there and send the result back. Even with good intentions, that means a copy of your statement exists on a computer you know nothing about, for a time you cannot verify. Our tools take the other route: the PDF is read by PDF.js, the open-source engine Firefox uses, inside your browser, and the spreadsheet is assembled in memory on your device.
You don’t have to take that on trust. Open your browser’s developer tools, go to the Network tab and run a conversion: no request carries your file. Or convert once while online, disconnect from the internet and convert again — it still works.
Convert PDF statements to Excel in your browser
Try it nowFrequently asked questions
Can I convert several months of statements at once?
Yes. Add all the PDFs together; each one becomes its own spreadsheet, and you can download them all in a single ZIP. If you want everything in one table, merge the resulting spreadsheets afterwards with a merge tool that matches columns by name.
Will it work with a password-protected statement?
Not directly. Open the PDF in your reader, type the password, and save or print a copy without protection. Use that copy for the conversion, and delete it when you are done.
Why did two columns come out merged?
Because the space between them was too narrow to be read as a boundary, or a long description crossed it. Splitting one column in Excel with Data → Text to Columns is much quicker than retyping the statement.
Is Excel or Google Sheets better for statements?
Either works with an .xlsx file. Google Sheets is convenient for sharing a household budget; Excel is stronger for pivot tables and long histories. What matters most is that amounts arrive as real numbers.