How to convert a PDF bank statement to Excel (without retyping)

Updated 2026-10-10

Banks love PDFs; spreadsheets do not. If you need last year's transactions in Excel for a budget, a tax return, a loan application or a bookkeeping catch-up, you have three realistic options.

Option 1: Download a CSV or Excel file from online banking

Before converting anything, check whether your bank offers an export. Look for Download, Export or Statements & documents in online banking. Many banks let you export CSV for recent months only — older history is often available just as PDF statements, which is why converters exist.

Option 2: Copy and paste from the PDF

Works for a page or two. In practice you will usually hit these problems:

Columns collapse into one cell, or every word lands in its own cell.
Descriptions that wrap onto a second line become separate rows.
Debits and credits sit in separate columns, so you have to build a signed amount yourself.
Dates without a year (01/05) or in day-first format are misread by Excel.
Page headers and footers ("Page 2 of 6", "continued") end up in the middle of your data.

Option 3: Use a statement converter

A converter reads the layout of the page — where the date, description, amount and balance columns are — and rebuilds proper rows. What to look for:

Where your file goes. Most online converters upload the statement to their server. LocalLedger processes it inside your browser instead, so the file never leaves your computer.
Signed amounts. You want one Amount column where money out is negative, plus optional Money In / Money Out columns.
A totals check. If opening balance + transactions ≠ closing balance, a row was missed or misread.
Editing before export. No converter is perfect on every layout; being able to fix a row beats re-doing the file.

Step by step with LocalLedger

Open the converter and drop one or more PDF statements on it.
Check the file summary: it shows how many transactions were found and whether they reconcile with the statement balances.
Review the table. Rows highlighted in yellow had no sign in the statement — confirm them or use the ± button.
Choose Excel (.xlsx) and press Download. Dates are real Excel dates and amounts are numbers, so you can sort, filter and build pivot tables immediately.

Scanned statements

If you cannot select text in the PDF, it is an image (a scan or a photo). Text-based converters, including LocalLedger, cannot read it; you would need OCR software first. Statements downloaded from online banking are almost always text-based.

Try it with your own statement. LocalLedger reads the PDF or CSV in your browser, shows every transaction for review and checks the totals against the statement balances.

Convert your statement now — free preview, nothing uploaded