CAMT.053 to Excel — Convert an ISO 20022 File

What a CAMT.053 file is

CAMT.053 is part of the ISO 20022 family — the "Bank to Customer Statement" message. It's XML, so it's structured into nested elements: a statement holds entries, each entry holds amount, credit/debit indicator, booking date, and transaction details inside further elements. Banks generate it for end-of-day reporting, and treasury and ERP systems consume it. Because it's well-formed XML, it converts cleanly — the challenge is the depth of nesting, not ambiguity.

Why convert CAMT.053 to Excel

• You can't read XML by eye — the nesting hides the actual transactions.
• Analysis and reconciliation belong in a spreadsheet with flat columns.
• A downstream system wants Excel or CSV rather than ISO 20022 XML.
• You're reviewing or auditing and need the entries sortable and filterable.

How to convert a CAMT.053 file to Excel

1. Use Excel Power Query's From XML import. Because CAMT.053 is valid XML, Data → Get Data → From XML can load it; you then drill into the entry elements and expand them into a transaction table.
2. Use a dedicated CAMT-to-Excel/CSV converter. Purpose-built tools know the ISO 20022 schema and flatten entries, amounts, and dates into columns without manual drilling.
3. Apply an XSLT transform. Technical teams can transform the XML to CSV with a stylesheet, then open it in Excel — precise but more setup.
4. Import into treasury/ERP software, then export. Systems that read CAMT.053 can usually re-export booked entries as CSV or Excel.
5. If you also have a PDF statement, convert that. Export Bank Statement turns the PDF into a reconciliation-verified Excel file, no XML drilling required.

Where Export Bank Statement fits — honestly

Export Bank Statement does not ingest CAMT.053 or any XML — its input is PDF. CAMT.053 is structured enough that the methods above handle it well; the format Export Bank Statement exists for is the PDF statement, where the data has to be read off the page and verified. If your bank issues both CAMT.053 and a PDF, the PDF route here gives you a checked spreadsheet quickly.

The accuracy angle

CAMT.053 includes opening and closing balances, so a faithful conversion can be checked against them. Export Bank Statement brings the same discipline to PDFs: each extracted line is tied to the running balance and any statement that doesn't reconcile is flagged before export. See how to convert PDF bank statements to CSV for the workflow.