Bite Apps › SafeCAMT › camt.053 to Excel
camt.053 to Excel — convert XML bank statements without uploading them
Open a camt.053 statement and get one row per transaction — counterparty, IBAN, references, purpose and bank transaction code — with the balances checked, ready for Excel. Everything happens in your browser.
SafeCAMT reads camt.052/053/054, MT940 and BAI2 — free to use, nothing is uploaded.
Open SafeCAMT — free, in your browserEnglish · Deutsch · Nederlands
Open SafeCAMT with an example fileOpen SafeCAMT and drop your own file
How to convert a camt.053 file to Excel
- Download the statement as camt.053 (XML) from your online banking. camt.052 intraday reports and camt.054 notifications work the same way.
- Open SafeCAMT and drop the XML file (or several). Every camt.052, camt.053 and camt.054 version is detected automatically.
- On Balances & reconciliation, check that opening balance + entries = closing balance. Batch entries (one booking with several transactions) are expanded into one row per transaction.
- Set the CSV option (“comma” or “semicolon + 1,23 (EU)”), download the transactions as CSV and open the file in Excel.
Free: every transaction on screen, the balance check, and a CSV download of the first 100 rows. Pro ($19 one-time, no subscription): all rows and Excel (.xlsx) with Transactions, Balances and Checks sheets.
Three rows from the built-in example statement, as SafeCAMT shows and exports them:
| Booking date | Amount | Counterparty | Counterparty IBAN | Remittance information | Bank transaction code |
|---|---|---|---|---|---|
| 2026-11-02 | 9,800.00 | Nordwind Logistics BV | NL91ABNA0417164300 | RF18539007547034 | PMNT-RCDT-ESCT |
| 2026-11-02 | 2,850.00 | Atelier Lumiere SARL | FR1420041010050500013M02606 | Facture 2026-1187 / commande 5541 | PMNT-RCDT-ESCT |
| 2026-11-02 | -20.40 | Account maintenance fee October | ACMT-MDOP-CHRG |
Columns in the export
| Column | What it contains |
|---|---|
Booking date / Value date | when the bank booked the entry and when it is valued |
Amount, Currency, Credit/Debit | signed amount (debits negative) plus currency and C/D |
Status | booked, pending or information only |
Counterparty, Counterparty IBAN/account, Counterparty BIC | the other party of the payment |
Remittance information, Structured reference | free-text purpose and RF creditor reference |
End-to-end ID, Bank reference, Entry/customer reference | the references you reconcile against |
Bank transaction code | ISO domain-family-sub-family, e.g. PMNT-RCDT-ESCT (or the MT940 GVC / BAI2 type code) |
Return reason, Additional information | reason code of returned payments, extra bank text |
File, Account, Statement | where the row comes from when several files or accounts are open |
Where the data sits in camt.053
A camt.053 file is nested XML: Stmt (one per account and day) → Bal (balances such as OPBD and CLBD) → Ntry (one booking) → NtryDtls/TxDtls (the transactions inside it, with parties in RltdPties, references in Refs and purpose in RmtInf). SafeCAMT flattens this to one row per transaction and keeps the ISO bank transaction code (BkTxCd) — see the list of bank transaction codes.
Why not an online converter?
A bank statement is confidential. SafeCAMT reads it in your browser — nothing is uploaded, no account is needed, and the page also works offline. To import the statement into accounting software instead, see camt.053 to QuickBooks, Xero and OFX.
FAQ
How do I open a camt.053 file in Excel?
Opening the XML in Excel gives an unusable nested table. Open it in SafeCAMT instead, check the balances and download the transactions as CSV with one column per field.
Which camt versions are supported?
camt.052, camt.053 and camt.054 in all versions are detected automatically.
Are batch bookings split?
Yes. An entry with several transactions (NtryDtls/TxDtls) becomes one row per transaction, each with its own counterparty and references.
Is the statement uploaded?
No. Everything runs in your browser; the file never leaves your computer.
Last updated 2026-11-14. Something wrong or missing? Email support@biteapps.cc.