You have three statements and no reason to start a monthly plan
Most people who need a bank statement in a spreadsheet need it once. A mortgage application, one tax year, a dispute with a supplier, a landlord asking for six months of history. The tools built for this market are built for bookkeepers running statements weekly, and their pricing shows it.
Why the pricing feels wrong for occasional use
Nearly every converter in this category is a monthly subscription starting around $19, because their intended customer processes statements continuously. For that customer the maths is obvious — the subscription costs less than the hours it saves.
For a one-off job the same maths inverts. You pay for a month, use it for twenty minutes, and then either remember to cancel or quietly pay for it again. The forgotten subscription is a real cost and it is worth designing around.
The free routes, and where each one stops
- Download it from the bank instead. Try this first. Most large banks let you export transactions directly as CSV or Excel from online banking, and a direct export beats any conversion because nothing has to be interpreted. It usually only covers recent months, so it fails exactly when you need old statements or a closed account.
- Excel's own Power Query. Data, then Get Data, then From File, then From PDF. Free and already installed. It handles cleanly-ruled tables reasonably and struggles with statements laid out by spacing alone, which is most of them.
- Copy and paste. Works for a single short page and falls apart on anything longer, because the columns collapse into one.
- Five a day here. PDF to Excel gives five conversions a day with no account and no card. Three statements fits comfortably inside that, at no cost.
A six-month job is six statements. Spread across two days that is free, and the only thing it costs you is doing it in two sittings instead of one.
What two steps looks like in practice
If your statements are ordinary digital PDFs — the kind you download from online banking — it is one step, and the whole job takes a few minutes.
If they are scans, or photographs of paper, it is two. A scan holds a picture of a table rather than a table, so nothing can be read out of it until there is a text layer. Run OCR first, then convert what comes out.
The paid tools collapse those two steps into one upload. That is a genuine convenience and it is a fair part of what they charge for. It is also, for three statements, about ninety seconds of extra clicking.
Doing it
- Check whether your bank offers a direct CSV export first. If it does and it covers your dates, stop here — nothing beats the original.
- If the statement is a scan, run OCR on it and keep the result.
- Open PDF to Excel and add the document.
- Choose Find tables, preview what was found, and untick anything irrelevant.
- Download as .xlsx or .csv.
- Select an amounts column and confirm the status bar shows a Sum, not just a Count.
What to check before you file it anywhere
Occasional jobs get less scrutiny than routine ones, which is exactly backwards — the one-off statement is usually the one going to a lender, an accountant or a court.
- Totals. If your statement prints a closing balance, check that the converted rows agree with it. This single check catches most extraction problems in one move.
- Negatives. Confirm that amounts in parentheses came through as negative figures rather than positive ones. A sign error inside a total does not look like an error.
- Dates. Left as text on purpose, because
03/04is April 3rd under one convention and March 4th under another and nothing in the file settles it. Convert them yourself knowing which your document uses. - The last page. Statements often end with a summary block that is not part of the transaction table. Check it did not get pulled in as a row.
When to just pay
If you are doing this every week, if most of what you receive is scanned, or if the destination is QuickBooks Desktop and you need a .QBO file, buy one of the subscription tools. The time saved will exceed the money quickly and there is no sense being stubborn about it.
The argument here is narrower: for a handful of statements, a monthly subscription is the wrong shape of purchase, and you should not need one.
Try it now
PDF to Excel gives you 5 free uses a day with no account, and your file is never stored.
FAQ
- How can I convert a bank statement to Excel for free?
- Try your bank's own CSV export first - a direct download beats any conversion. Failing that, Excel's Power Query handles ruled tables, and this tool converts five documents a day with no account and no card, which covers most one-off jobs.
- How many statements can I convert without paying?
- Five a day, with no account. A six-month job spread over two days costs nothing. Beyond that it is $4.99 a month with cancellation any time.
- Do I need to create an account?
- No. The first five conversions each day need no account and no card. An account is only needed if you want more than that.
- My statement is a scan - what changes?
- It becomes two steps instead of one. Run OCR first to create a real text layer, then convert the result. Check the figures more carefully afterwards, because isolated numbers are the least reliable thing OCR produces.
- Is it better to download the CSV from my bank?
- Yes, whenever it is available and covers the dates you need. A direct export involves no interpretation at all. Converters exist for old statements, closed accounts, and banks that do not offer an export.
- Why are the dates still text after converting?
- Deliberately. 03/04 is the 3rd of April under one convention and the 4th of March under another, and a PDF carries nothing that says which. Guessing would be silently wrong some of the time, so the original text is preserved.
- What should I check before sending the spreadsheet to a lender or accountant?
- Confirm the converted rows agree with the statement's own closing balance, that parenthesised amounts came through negative, and that any end-of-statement summary block was not pulled in as a transaction row.
- What happens to my statement?
- It is processed and discarded the instant your download is ready - never stored, never queued, and never read by a person.