CAMT.053 to Excel Converter

CAMT.053 is the ISO 20022 BankToCustomerStatement message — the XML format that replaced SWIFT MT940 across SEPA and most of Europe. Opened directly, Excel either refuses the file or, via Data → From XML, flattens it into one row per leaf element instead of one row per transaction, because the data you want is nested three or four levels deep across Ntry, NtryDtls/TxDtls, RmtInf and Refs.

The sign convention is the other trap: CAMT.053 never stores a negative amount. Every Amt is positive, and direction lives separately in CdtDbtInd (CRDT or DBIT). This converter applies the indicator and writes debits as negative numbers — not text — so a SUM formula on the Amount column works immediately after opening the file.

The .xls download is SpreadsheetML with each cell explicitly typed (ss:Type="Number" for amounts), so Excel never mis-guesses a column as text the way it sometimes does with CSV — which matters most for CAMT.053, where dates come from ISO 8601 (BookgDt/ValDt) and need to land as real Excel dates, not strings, for sorting and pivot tables to work correctly.

• Booking date (BookgDt) and value date (ValDt) as separate columns
• Amount with CdtDbtInd applied, and currency from the Amt@Ccy attribute
• Account — IBAN, or the proprietary identifier when no IBAN is present
• Bank transaction code (BkTxCd, domain or proprietary) and entry status
• References — AcctSvcrRef as bank reference, EndToEndId or InstrId as customer reference
• Description — unstructured remittance information (RmtInf/Ustrd), falling back to AddtlNtryInf
• Balances — opening (OPBD) and closing (CLBD) rows kept alongside the entries