Convert an ISO 20022 CAMT.053 statement (camt.053.001.02 through .08) into CSV or Excel. Free, no signup, no size limit.
camt.053 version
CAMT.053 is the ISO 20022 BankToCustomerStatement message — the XML
format that replaced SWIFT MT940 across SEPA and most European banks. It is precise and complete,
which is exactly why it is painful to read: a single day's statement can be several thousand lines of
nested XML, and the information you actually want is spread across
Ntry, NtryDtls/TxDtls, RmtInf and Refs nodes.
The trap for anyone building their own import is the sign. CAMT.053 does not store negative amounts.
Every Amt is positive and the direction lives in a separate
CdtDbtInd element containing CRDT or DBIT. Miss it and your
reconciliation is wrong in both directions at once. This converter applies the indicator and writes
debits as negative numbers so the column totals.
BookgDt) and value date (ValDt) as separate columnsCdtDbtInd applied, and currency from the Amt@Ccy attributeBkTxCd, domain or proprietary) and entry statusAcctSvcrRef as bank reference, EndToEndId or InstrId as customer referenceRmtInf/Ustrd), falling back to AddtlNtryInfOPBD) and closing (CLBD) rows kept alongside the entriesBanks issue different CAMT.053 versions, and each version uses a different XML namespace
(urn:iso:std:iso:20022:tech:xsd:camt.053.001.02 through .08). Tools that
hard-code one namespace silently return zero rows for the others. This converter matches on element
local names instead, so every version parses without configuration — and multi-statement files
(several Stmt blocks in one document) are all read.
No. Parsing runs in your browser through the built-in XML parser. There is no server and no upload endpoint — check your browser's network tab during a conversion and you will see no requests. The page also works fully offline once loaded.
All of camt.053.001.02 to camt.053.001.08, since matching is
done on local element names rather than a fixed namespace. CAMT.052 (intraday report) and CAMT.054
(debit/credit notification) share the same entry structure and will also produce rows, though they
are different message types.
Because CAMT.053 keeps every amount positive and stores direction separately in
CdtDbtInd. Writing debits as negative is what lets you sum the Amount column and get a
meaningful net movement in Excel.
Yes — use the Excel download button. It produces a SpreadsheetML file that Excel, LibreOffice and Google Sheets open directly, with amounts typed as numbers rather than text.