Bank statement to Excel
Choose a file with your bank statement (výpis z účtu) and download a spreadsheet with real dates and amounts, which Excel can calculate with and sort.
Checked
Everything happens in your browser. Nothing is sent anywhere or saved.
Or drag it here. CSV, camt.053, ČSOB XML, MT940, GPC.
How it works
- In your internet banking, download the statement (výpis) or the list of transactions (přehled pohybů) in one of the formats below.
- Choose the file at the top of this page. We recognise the format ourselves.
- Check the table. If the CSV columns were not recognised, assign them by hand.
- Download XLSX or CSV.
Which files we read
| Format | What we read from it |
|---|---|
| CSV | We work out the delimiter, the encoding and the line with column names ourselves. Columns with unknown names can be assigned by hand. |
| camt.053 | Including ČBA XML and SBA XML. Booked transactions only, pending ones are left out. |
| ČSOB XML | The FINSTA file. |
| MT940 | Transactions from :61: fields, details from :86:. |
| GPC | Records 075. We convert the amount from hellers to crowns. |
The differences between the formats are explained in Statement formats.
The file stays with you
Your browser reads the file. The page does not send it anywhere and saves nothing: close it and the file is gone from here.
You can check this yourself: load the page, turn off the internet and choose the file. It all works offline.
What you get
- XLSX: the date is stored as a date and the amount as a number, so Excel can calculate with them and sort them.
- CSV: UTF-8 encoding, semicolon delimiter, decimal comma. It suits Excel with Czech settings.
- Text starting with
=,+,-or@gets an apostrophe at the start in the CSV. A payment message is written by the sender, and a spreadsheet could otherwise run it as a formula.
The same code reads statements in the Do koruny app: there the transactions become records of expenses and income.
Frequently asked questions
Is it free?
Yes, with no sign-up. There is one limit: the file can be 30 MB at most.
Why are some lines missing from the table?
We skip a line where the date or amount cannot be read and tell you its position in the file. Transactions with a zero amount are not carried over. From camt.053 we take booked transactions only. The page shows the first 200 lines, the downloaded file has them all.
Can I upload a statement in PDF?
No, we do not read transactions from PDF. In your internet banking, download the same statement in CSV, GPC, MT940 or camt.053. Steps for each bank are on the Banks page.
Sources
An informative calculation, not financial advice.
Do koruny on your phone
Expenses, budget and planned payments. No account, data only on your phone.
Coming soon to the App Store and Google Play.