Home › Invoices, banking and VAT › CAMT.053 to Excel converter (XML or the bank's ZIP)
CAMT.053 to Excel converter (XML or the bank's ZIP)
Turn CAMT.053 bank statement XML files, or the whole ZIP from your bank, into one Excel list with a balance check.
FREE3 files a day, instant, no sign-up
No CAMT.053 file at hand? or download the sample.
- Press Select file and choose the ZIP from your online bank, or the
.xmlfiles. camt.052 works too. - Leave Convert on to Excel.
- Press Convert statements. Check the balance check on screen, then download one Excel file with every transaction.
💡 Simple guide · no technical skills needed
When do I need this?
Your bank now sends CAMT.053 XML statements (often a ZIP with one file per day) and you want to see them as a normal table in Excel.
Good to know
- One row per transaction from all files, sorted as in the statements, with the balance after each row.
- German banks stopped MT940 in November 2025; most now give CAMT.053 as a ZIP. You do not need to unzip it.
- Columns: booking date, value date, amount, debit/credit, counterparty, IBAN, purpose text, references.
- A PDF statement is a different job: use /instant/bank-statement-pdf-to-excel.
Words explained
- camt.053
- The new file format banks use for account statements.
- Excel
- A spreadsheet program (tables with rows and columns). Google Sheets and LibreOffice open the same files.
- XML
- A data file used by banks and programs. Not meant to be read by people; our tools read it for you.
- ZIP
- A box that holds several files in one. Double-click (or tap) it to see the files inside.
- MT940
- The older file format banks use for account statements.
- IBAN
- Your bank account number in the international format, e.g. DE89 3704 0044 0532 0130 00.
- A document file that looks the same on every computer and phone.
Stuck? Press Help in the bottom corner and write your question in any language. You get an answer in seconds, or a real person answers you.
More free tools
Bank statement PDF to ExcelEvery transaction from a PDF or scan into Excel, balance checked
Bulk VAT number checkValid or not, with company name and address, from EU VIES
MT940 to CAMT.053Turn SWIFT MT940 bank statements into ISO 20022 CAMT.053 XML, or CAMT.053 back to MT940, with a balance check
Excel to SEPA XMLTurn a payment list into a SEPA XML file your bank accepts: transfers (pain.001) or direct debits (pain.008)
SEPA XML checkerFind why a bank rejects your SEPA file: schema, IBAN, total and structured address problems with the fix. Old v03 files upgraded to v09
CAMT.053 to MT940Turn ISO 20022 CAMT.053 (or camt.052) XML statements into MT940 for systems that cannot read CAMT yet