Guides

How to Convert CAMT.053 XML to CSV Online (ISO 20022 Guide)

To convert an ISO 20022 camt.053 XML bank statement into a clean Excel CSV spreadsheet without uploading financial files, parse the XML locally in your browser with the EasyExtract CAMT.053 to CSV Converter. It uses native DOMParser namespace-wildcard lookups to extract every <Ntry> booking date, credit/debit sign, currency, amount, and remittance text.

Across Europe, the United Kingdom, and SEPA payment corridors, banks have replaced flat SWIFT MT940 files with structured ISO 20022 XML messages known as camt.053 (Bank-to-Customer Statement). Opening a camt.053.001.04 or camt.053.001.08 XML file directly in Microsoft Excel either triggers schema warnings or repeats parent XML metadata across dozens of sparse columns.

What is inside a CAMT.053 XML bank statement?

An ISO 20022 CAMT.053 document wraps statement balances and transactions inside nested XML namespaces under <BkToCstmrStmt><Stmt>. Each transaction sits inside an <Ntry> node containing child elements for amount, direction, date, and payment narrative.

XML Tag ISO 20022 Purpose CSV Output Mapping
<Ntry> Single statement entry wrapper Produces one flat CSV transaction row.
<BookgDt><Dt> / <DtTm> Booking date or ISO timestamp Mapped to Booking Date (first 10 characters YYYY-MM-DD).
<CdtDbtInd> Credit (CRDT) or Debit (DBIT) flag Mapped to C/D; DBIT prepends - to Amount.
<Amt Ccy="EUR"> Transaction value and ISO currency attribute Split into signed Amount and Currency columns.
<Ustrd> / <AddtlNtryInf> Unstructured remittance or bank entry description Mapped to Remittance with CSV formula escaping.

Why namespace-agnostic XML parsing matters for CAMT.053

Different banks emit different ISO 20022 XML namespace URIs (such as urn:iso:std:iso:20022:tech:xsd:camt.053.001.02 or 001.08). Rigid parsers hardcode one namespace string and return zero rows on newer bank exports. EasyExtract queries elements with getElementsByTagNameNS('*', ...) so every CAMT.053 schema revision parses cleanly without configuration.

<Ntry>
  <Amt Ccy="EUR">1490.00</Amt>
  <CdtDbtInd>DBIT</CdtDbtInd>
  <BookgDt><Dt>2026-11-18</Dt></BookgDt>
  <NtryDtls><TxDtls><RmtInf><Ustrd>INV-2026-884 CLOUD HOSTING</Ustrd></RmtInf></TxDtls></NtryDtls>
</Ntry>

How to convert CAMT.053 XML to CSV in three steps

  1. Open the EasyExtract CAMT.053 to CSV Converter in any modern browser.
  2. Drag and drop your .xml statement into the upload box, or click to select a file from disk.
  3. Verify the parsed Booking Date, C/D flag, signed Amount, Currency, and Remittance preview table (up to 500 preview rows), then click Download CSV or Copy to clipboard.

Privacy advantage of client-side ISO 20022 parsing

SEPA and SWIFT XML statements list IBANs, supplier names, payroll disbursements, and closing account balances. Processing the XML inside local browser RAM with DOMParser keeps every financial byte on your machine and complies with internal data-handling policies.

Frequently asked questions

Which CAMT.053 schema versions work?

Because the parser uses namespace-wildcard element queries, camt.053.001.02, 001.04, 001.08, and bank-customized ISO 20022 variants parse identically.

Are DBIT transactions exported as negative numbers?

Yes. Whenever <CdtDbtInd> equals DBIT, the converter prepends a minus sign to the amount so SUM formulas in Excel and Xero balance automatically.

What if I need to extract custom nested XML tags outside Ntry?

Use the EasyExtract XML Field Extractor to pull arbitrary element paths or attributes from any XML tree into CSV.

Shah Abrar Ahmad - Founder & Lead Engineer
Lead Architect & Founder

Software architect and technical web engineer specializing in browser-based zero-knowledge file parsing, technical SEO, and data extraction security. Built EasyExtract to give users 100% private in-browser tools with zero cloud uploads.

Keep reading