Convert a Bank Statement PDF to Excel
Drop in a statement PDF and get back a real Excel workbook, with a balance check that shows whether a row went missing.
No sign-up needed. A PDF is read on our server, never stored.
- PDF, CSV, Excel and the OFX family are all read, and which one you have is taken from what is inside the file rather than its name
- Only a PDF is read on our server, held in memory and dropped when the request ends. Every other format is read in this browser tab
- No account and no card, a handful of PDFs an hour, and no limit at all on the rest
A bank statement arrives as whatever your bank decided to hand over. For most people that is a PDF, a document built to be looked at. Paste one into a spreadsheet and it turns to mush. Columns run together, amounts land in the wrong place, and page numbers arrive as though they were transactions.
Opening a CSV export in Excel is not much better. Dates come through as text or get rewritten by your locale, amounts arrive as strings, and the first column you try to total returns zero. Both problems have the same shape: the file was never meant to become a spreadsheet, so it does not become one on its own.
This page takes all of it: a PDF, a CSV, an .xlsx workbook, or any of the OFX-family downloads (.ofx, .qfx and .qbo). Whichever arrived, it writes a real Excel workbook. Dates are date cells, amounts are numbers to two places, and every row carries In or Out beside the signed figure. Sorting, filtering and totalling work on arrival, not after an hour of cleaning up.
One of those inputs leaves your machine and the rest do not. Reading a PDF needs a parser too large to hand to a browser, and a scanned statement has to be looked at rather than parsed. So a PDF goes to our server, is held in memory while it is read, and is dropped when the request ends. It is never written to disk and never stored. A CSV, a workbook or an OFX file is read in this browser tab and goes nowhere at all. If your bank offers one of those alongside the PDF, it is the better file to bring.
Whichever came in, the same balance check runs before anything is downloaded. Where the statement prints a running balance, every step is reconciled against the transactions that were read. Where it does not, you type the opening and closing figures in from the page yourself. Reading a statement can drop a row, and that check turns a silent loss into a figure on screen.
A converter that tells you when it missed something.
Most tools hand you a file and let you find out in your ledger. Every conversion here is reconciled against the closing figure first. That figure is read from your statement’s balance column, or typed in from the page when there isn’t one.
When the totals don’t meet you get the exact size of the gap, every row that did read, and the converted file anyway.
Sample balance check
A transaction may be missing. Review the rows below, or re-upload including all pages.
A sample result. This is the same component the converter uses.
Your statement is read, not kept
Reading a PDF needs a server. Here is exactly what happens on it.
The PDF is held in memory while it is read, then dropped when the request ends. It is never written to disk and never stored. There is no copy to delete, lose or be compelled to produce.
Open your browser's network tab and convert. You will see one request, to this site, and nothing after it. The transactions come back as text. The file you download is written here, in this tab.
PDF is the only one that leaves. A CSV or a spreadsheet from the same bank is converted in your browser and never crosses the network. Take that instead when your bank offers both.
Questions people actually ask
Does my statement get uploaded?
Only if it is a PDF. Reading one needs a parser far too large to send to your browser. A scanned statement is a picture of a page, so it has to be looked at rather than parsed. It goes to our server, is held in memory while it is read, and is discarded when the request finishes. It is never written to disk and never stored, so there is no copy to delete afterwards. Every other format this page takes, CSV, Excel, .ofx, .qfx and .qbo, is converted inside this browser tab and never crosses the network. Open your browser's network tab while you convert one and you will see that for yourself.
What can I actually drop in?
A PDF, a CSV, an .xlsx spreadsheet, or an .ofx, .qfx or .qbo file. Which one you have is worked out from the contents rather than the extension. That matters because banks are careless about naming. A CSV arrives called .txt often enough, and the three OFX extensions are used interchangeably for the same document. If a layout cannot be read automatically, you are shown the file and asked to point at the date, amount and description columns yourself.
Are the dates real dates or just text?
Real date cells. Excel stores a date as a number of days and renders it to your locale. That is why a text date looks identical on screen and then refuses to sort. Every date here is written as the underlying number with a date format applied, so filters and chronological sorting work the moment the workbook opens.
Can I total the amount column?
Yes. Amounts are numeric cells with a two-decimal format, negative for money out and positive for money in. Summing the column gives the same net figure the balance check shows above your results, which is a quick way to confirm the two agree.
Does it read scanned or photographed statements?
Yes. A PDF either carries its own text or is an image of a page. Where there is text, only that text is read. Where there is not, as with a scan, a photograph or a fax, the pages are read as images instead. You are told which of the two happened. They are not equally exact, and you should know which one you are checking.
How do I know every transaction came through?
Check the balance panel above the results. If your statement prints a running balance, the opening and closing figures are taken from it and every step is reconciled against the transactions. A row that went missing breaks the chain and is reported as a figure rather than passed on quietly. Where a statement prints no running balance there is nothing to check against on its own. Type the opening and closing figures in from it and the same check runs.
Do I need an account?
No. There is no sign-up, no email capture and no card. PDFs are capped at a handful an hour, because reading one costs something to run. Every other format is converted in your browser and has no limit.
Try it on the statement that’s annoying you right now.
No account, no card, no limit. If the layout isn’t recognised you will know immediately, rather than after a support ticket.