Converter · PDF to Excel
PDF bank statement to Excel, without copying and pasting
Copying rows out of a PDF statement and pasting them into Excel almost never works cleanly. Here’s why, and how to get a spreadsheet you can trust.
or drop it here
Read in this browser. Your file is never uploaded.
Rows wrong or missing?
Send us the shape of this statement, not its contents. The report below is made in this browser. It keeps where text sits, dates and column headings. Every name, amount, reference and account number is replaced with x and 1, as you can see. Nothing is sent until you send it.
Then email the report to support@statementtocsv.co.uk and say which bank it is from. We’ll add the layout and let you know.
| Date | Description | Paid in | Paid out | Balance |
|---|
Send us the shape of , not its contents. The report below is made in this browser. It keeps where text sits, dates and column headings. Every name, amount, reference and account number is replaced with x and 1, as you can see. Nothing is sent until you send it.
Then email the report to support@statementtocsv.co.uk and say which bank it is from. We’ll add the layout and let you know.
| Check | Result | What we found |
|---|
Statements
| Period | File | Opening | Closing | Rows | Used as |
|---|
| Date | Description | Paid in | Paid out | Balance | From |
|---|
Works with text PDFs that have Date, Description, Paid in / Paid out (or Amount) and Balance columns. Scanned or photographed statements are not supported yet. The samples are fictional test data.
Why copy and paste goes wrong
A PDF doesn’t store a table. It stores pieces of text and where each one sits on the page. When you select a statement and copy it, the PDF viewer guesses the reading order, and with bank statements it guesses badly:
- Columns collapse. Date, description and amount often paste into one cell, or the amount lands in the wrong column, so money in becomes money out.
- Wrapped descriptions split. A payment whose description runs onto a second line becomes two rows, one without an amount.
- Dates printed once per day disappear. Many banks print the date only on the first transaction of each day. Pasted rows lose their date.
- Page breaks get in the way. Headers, page numbers, “balance brought forward” and “carried forward” lines are pasted in the middle of your data.
- Rows go missing. This is the worst one, because nothing tells you.
Fixing this by hand is slow, and it is very easy to finish with a sheet that looks right but is out by one transaction.
Converting instead of copying
The converter above reads the position of every piece of text on the page, works out the columns from the statement’s own headings, joins wrapped descriptions back together, fills in dates printed once per day and skips the page furniture. Then it checks the result against the statement’s running balance, row by row.
That last step is the reason to convert rather than paste. If any row is missing or misread, the balance stops adding up at that exact point, and the converter shows you the row and the amount. When everything agrees, you get a difference of £0.00 against the printed closing balance: every extracted row adds up to the balances printed on the statement.
Steps
- Use the original PDFDownload it from online banking. A PDF made by “printing” a web page sometimes works but is less reliable.
- Convert it aboveChoose the file. Nothing is uploaded; the work happens in your browser.
- Check the resultLook for “Verified”. If a row is flagged, compare it with the PDF.
- Download the CSV for ExcelOpen it in Excel and save it as a workbook.
What about Excel’s own PDF import?
Recent versions of Excel for Microsoft 365 can import tables from a PDF (Data, Get Data, From File, From PDF). It is worth a try for simple documents, but bank statements often come through as several separate tables per page, with wrapped lines and headers mixed in, and you still have no check that every row arrived. You would need to rebuild the running balance yourself to be sure.
Questions people ask
Why does my pasted bank statement end up in one column?
The PDF stores text positions, not table cells, so copied text loses its column structure. A converter rebuilds the columns from where each piece of text sits.
How do I know no transactions were lost?
Check the running balance. The converter recalculates it for every row and compares it with the printed balance, so a missing row shows up as a difference at that point.
Can I convert a statement that I printed to PDF from my browser?
Often, yes, as long as the PDF contains text you can select. The bank’s own downloadable PDF statement is more reliable, because its layout doesn’t depend on browser settings.
Does this work for statements with more than one page?
Yes. Page headers and brought-forward lines are skipped, and the balance check runs across the page breaks.