How to convert a bank statement PDF to Excel
Turn the PDF statement from your online banking into an Excel sheet with one row per transaction – without retyping and without uploading it anywhere.
Banks send statements as PDF files, but accounting, tax returns and budgets need the transactions in a spreadsheet. Copying from a PDF breaks the columns, and retyping is slow and error-prone.
Step by step
- In your online banking, download the statement as PDF (not a scan or a photo: the PDF must contain real text – you can select words in it).
- Open KontoXL and drop the PDF on the page, or click Choose bank statements.
- Look at the summary: KontoXL shows the opening and closing balance, money in and out, and whether opening balance + transactions = closing balance.
- Click Download Excel. Dates and amounts are real Excel values, so sums, filters and pivot tables work immediately.
Why the balance check matters
PDF statements are made for printing, not for computers: a converter has to guess where each column is. KontoXL compares the sum of the transactions with the balances printed on the statement. If they match to the cent, no line is missing and every sign is right.
Tips
- If your bank also offers camt.053 or MT940 files, use them: they are exact by design. See camt.053 to Excel and MT940 to Excel.
- Password-protected PDF? Open it, print it to a new PDF and convert that one.
- Many months or accounts? With Pro you drop them all at once and get one Excel file with a summary sheet.
Frequently asked questions
Is my PDF uploaded to a server?
No. KontoXL reads the PDF in your browser with the open-source pdf.js library; the statement never leaves your computer.
Does it work with scanned statements?
Not yet: a scan is an image without text. Download the PDF from online banking instead.