camt.053 / camt.054 → CSV / JSON
Upload or paste your ISO 20022 account statement (camt.053) or notification (camt.054) XML; convert it into rows with date, amount, direction and counterparty, then download as CSV or JSON.
Updated:
Privacy: The calculation runs in your browser; the full IBAN, account number, amount and reference you enter are not sent to a server, logged or passed to analytics. Some tools may pass only a non-sensitive term (e.g. bank code, BIC, currency) to a lookup service for search/matching. Per-tool detail: Privacy.
How does this tool calculate?
High — matches current official data- Method/formula used
- Parsing camt.053/054 XML and converting it into transaction rows (date, direction, amount, counterparty, reference).
- Data used
- ISO 20022 camt.053 / camt.054 message structure
- Unsupported cases
- Some fields may stay empty due to version/bank differences
- The file is not sent to a server (processed in your browser)
How do I use this tool?
- Load the XML: Select the camt.053 (account statement) or camt.054 (debit/credit notification) file you downloaded from your bank with "Upload XML", or paste its contents.
- Convert: The tool reads each entry (Ntry) and splits it into columns: booking/value date, direction (credit/debit), amount, currency, counterparty, description and reference.
- Download: Save the result with "Download CSV" (for Excel) or "Download JSON".
Difference between camt.053 and camt.054
- camt.053: Periodic account statement (balance + all entries).
- camt.054: Individual debit/credit notification (specific entries).
Everything runs in your browser; your file is not sent to a server. Some fields may stay empty due to version/bank differences; this is a structural converter, not an accounting confirmation.
Sources
ISO 20022 message standards (pain / camt)
ISO 20022 Registration Authority
- Document date:
- 2025
- Last checked:
- 2026-07-16