How to convert a bank statement to Excel (any bank, any format)

You want your bank statement in Excel — one clean sheet, one row per transaction, dates and amounts you can actually sort and total. The catch: banks give you a PDF built for reading, not a spreadsheet built for working. Here's how to get from one to the other, whatever your bank hands you.

First, check if your bank offers a direct export

The cleanest Excel file is the one your bank makes itself. In most banking apps or online banking it's under Statements → Export → CSV or Excel. A CSV opens straight into Excel and is copied exactly, so the numbers always add up. If that option exists, use it — see the per-bank export guides for where your bank hides it.

If you only have a PDF (the usual case)

Copy-pasting a PDF into Excel almost never works: columns collapse into one, multi-line descriptions split across rows, and negative signs go missing. Generic OCR is better but still guesses at where columns start and end. What you want is a converter that understands statement layoutspecifically:

1. Upload the PDF (or a photo of a paper statement).
2. It reads each row — date, description, amount, running balance — and re-checks the totals against the statement's own opening and closing balances, so nothing is dropped or double-counted.
3. Export to Excel (.xlsx) or CSV — columns aligned, dates normalised, ready to sort and pivot.

That's exactly what PDF → Excel does, for 5,000+ banks.

The step most converters skip

A row of numbers isn't much use if you can't tell what half of them are. Descriptors like SQ *, TST* or PAYPAL * name the payment processor, not the shop. A good conversion also identifies the real merchant on every line, and flags subscriptions and recurring charges and bank fees — so your Excel file is something you can read, not just scroll.

Quick checklist for a clean Excel export

• One row per transaction — no split or merged lines.
• Real dates in a single column (not text like "MAR 12").
• Signed amounts — money out negative, money in positive.
• Totals reconcile to the statement's printed balances.
• Merchants named, so you can categorise in minutes.

Want to understand the statement while you're at it — spend by merchant, subscriptions, fees — not just export it? That's the difference between a bank statement converter that also reads the statement and a plain PDF-to-Excel tool.