Bank statement to Excel
Choose the PDF you download from online banking and take the transactions to Excel, Google Sheets or Numbers. No retyping, and no sending your statement to anyone.
Check the table. If a column is wrong, change its type in the header: the spreadsheet is made from what you see.
Your statement never leaves your device
How to do it
- Download your statement as a PDF from online banking.
- Choose the file here. You will see the transactions found and whether the balances add up.
- If a column is wrong, change its type in the table header.
- Click "Download Excel" or "Download CSV".
Tips
- In the Excel file dates are real dates and amounts are numbers: sum, filter and build pivot tables without any clean-up.
- Money out is negative and money in is positive, in a single Amount column, and the Direction column says Debit or Credit. On a credit card statement purchases are money out too, even if the card prints them as positive.
- If the balances do not add up, look at the marked rows: usually a transaction is missing or a column has the wrong type.
- Several months? Convert each statement and paste the rows one below the other.
Questions
Which banks does it work with?
With digital statements from most banks: the PDFs you download from online banking, where each transaction is a row that starts with its date. It recognises columns such as Date, Description, Amount, Paid out, Paid in, Debit, Credit and Balance. If something comes out wrong, you can change the type of each column before downloading.
Is my statement uploaded to a server?
No. Your browser reads the PDF and builds the spreadsheet on your device. The statement is not sent anywhere: you can go offline after this page has loaded and it keeps working.
Does it work with scanned statements or photos?
Not yet. Only digital statements downloaded from online banking work, because they have the text inside. A scan or a photo is just a picture, and reading it would need text recognition (OCR), which we do not offer for now.
How do I open the file in Excel, Google Sheets or Numbers?
The XLSX file opens with a double click in Excel and Numbers. In Google Sheets, go to File › Import › Upload and choose the file. The CSV uses commas, a dot for decimals and dates as 2024-01-31, which every spreadsheet reads.
Day/month or month/day?
When every date in the statement could be read both ways, such as 03/04, the tool picks the reading that keeps the dates in order and highlights the Dates setting. Check a few rows and switch it if needed.
What if the balances do not add up?
Look at the rows marked in red. If amounts have the wrong sign, change the column type, for example from Paid out to Paid in. If a transaction is missing, it may not be on a dated row in the PDF; add it by hand in the spreadsheet.
My statement has a password. What can I do?
Open it in your PDF reader, enter the password and use Print › Save as PDF. That saves a copy without the password that keeps the text; choose that copy here.