CAMT.053 to Excel: convert ISO 20022 bank statements to a spreadsheet
Instead of reading nested XML, get a table with the payee, counterparty IBAN and remittance text. Batch entries are split into their individual payments when the amounts add up.
- 100% free
- No usage limits
- No sign-up
- Nothing uploaded: runs in your browser
No file at hand?
Statements
Columns of
Detected automatically. Change anything that looks wrong and the result updates.
Transactions
Output options
How to use it
- Drop your CAMT .xml files or a ZIP.
- Check that each statement shows “Balance OK”.
- Download Excel or CSV.
Which fields are used
Ntry/Amt and CdtDbtInd give the signed amount, BookgDt and ValDt the dates, RltdPties the other party, RmtInf the remittance text and Bal with code OPBD or CLBD the balances. Newer schema versions place the name inside Pty, and both layouts are read.
When it helps
- Reading SEPA statements without an ERP.
- Replacing an MT940 process as your bank moves to ISO 20022.
- Checking which payments make up a batch entry.
Private by design
A statement shows your income, your rent and who you pay, so it should not need uploading to convert it. Here the file is read by code running on your device, and nothing is sent to a server. You can check it in your browser’s network panel.
Known limitations
- PDF statements are not read. Convert them to Excel first with the PDF tools and check the result, because PDF extraction can misread rows.
- A .qbo file is read but not written: QuickBooks Desktop requires an Intuit bank ID that cannot be validated here. Use OFX, or the 3-column CSV for QuickBooks Online.
- OFX requires a closing balance. If your source has none, the file contains the sum of the transactions, which is not your real balance.
- Investment transactions in OFX and QIF are not read. Split lines in QIF are kept as one transaction with its total.
- File size is limited by your device memory, not by any quota. The work runs on the page, so very large files can pause it for a moment.
Frequently asked questions
Is this CAMT.053 converter really free?
Yes. It is 100% free, with no usage limits, no account and no sign-up. There is no paid plan and no feature is locked.
Are my bank statements uploaded to a server?
No. Your files never leave your device: they are read and converted inside your browser. The page only downloads its own code and open-source libraries from this site. If you accept analytics cookies, Google Analytics receives anonymous usage data such as page views, never the contents or names of your files.
What does “Balance OK” mean?
When the file has opening and closing balances, the tool checks that opening balance + transactions = closing balance, to the cent. In a CSV with a balance column it checks every row against the previous one, in either order. If it does not add up, you are told by how much, or on how many rows.
What is the difference between CAMT.052, .053 and .054?
CAMT.053 is the end-of-day statement, CAMT.052 an intraday report, and CAMT.054 a debit or credit notification. CAMT.052 and .054 do not always include balances, so the page may say there is no balance to check.
How are batch payments handled?
If an entry contains several transactions whose amounts add up to the entry total, each one gets its own row, and the balance still adds up. If they do not add up, the entry stays as a single row, so the totals stay correct.
My bank sends a ZIP with many XML files. Does that work?
Yes. Drop the ZIP and each statement inside is read. Files in it that are not statements are skipped.
Does it validate the XML against the schema?
No. It reads the fields it needs and does not check the file against the ISO 20022 schema, so it is not a compliance validator.
Analytics: only if you accept cookies, the page loads Google Analytics (through Google Tag Manager) to count visits and see which tools are used. It never receives the contents or names of your files. You can change your choice at any time with “Cookie settings” at the bottom of the page.