CAMT.053 to CSV Converter (ISO 20022 Bank Statements)
🔒 Bank data never leaves your browser. Drop a CAMT.053, .052, or .054 XML file to get a signed-amount CSV with the correct counterparty on every row, plus an opening/closing balance check so you know nothing is missing.
Drop a CAMT.053, .052, or .054 XML file here, or click to upload
.xml, .camt, .053, .052, .054, .txtOr paste XML directly
How to Convert CAMT.053 to CSV
- Drop your bank's CAMT.053 (or .052 / .054) XML file onto the page, or try the built-in sample statement.
- Check the opening/closing balance card — a green checkmark confirms every booked entry is accounted for.
- Review the preview table, then click "Download CSV" to get a spreadsheet-ready file with a signed amount and running balance.
Features
- Supports camt.053 (versions 001.02 through 001.08+), plus camt.052 and camt.054, by reading elements by name rather than a fixed schema version
- Signed amount column — CAMT stores amounts unsigned and uses a separate direction code, which most naive converters get wrong
- Direction-aware counterparty: the debtor for money in, the creditor for money out, not always the same field
- Balance check per statement: opening balance plus booked entries compared against the closing balance in the file
- Batch entries (e.g. a payroll run) are labeled with their transaction count instead of producing one confusing merged row
- ISO 11649 creditor reference (RF number) checksum validation
- Danish and Spanish pages default to semicolon-delimited, comma-decimal CSV with a UTF-8 BOM, so it opens correctly in Excel
- Rejects any file containing a DOCTYPE declaration for safety, and never uploads your bank data anywhere
What CAMT.053 is
CAMT.053 ("BankToCustomerStatement") is the ISO 20022 XML message a bank sends for an end-of-day or period account statement — the modern replacement for the older SWIFT MT940 format, used throughout SEPA and increasingly worldwide. Its siblings, camt.052 (intraday report) and camt.054 (debit/credit notification), share the same entry structure and are supported here too.
Reading CdtDbtInd and reversals
Every entry's amount (Amt) is always positive; the direction comes from a separate CdtDbtInd field (CRDT or DBIT). A useful spreadsheet needs a signed amount, which is exactly what this converter adds. For reversed entries, the direction code already reflects the reversal itself.
Batch payments explained
A single entry — like a payroll run — can bundle many individual transactions (TxDtls) inside it. This converter keeps one row per bank entry and labels a batch with its transaction count, so a 200-person payroll run doesn't produce 200 confusing rows with the same reference.
Why the balance check matters
Because the opening balance plus every booked entry should equal the closing balance in the file, this converter runs that check automatically. A green checkmark means the statement is internally consistent; a mismatch usually means pending entries, a missing page, or a different reversal convention from your bank.
For other structured-data conversions, try CSV to SQL, CSV Query, or the XML Formatter.
