CAMT.053 XML to Excel (XLSX) Converter

CAMT.053 to Excel Converter

A camt.053 file is accurate but not comfortable to work in. Each day’s bank activity is a block of nested XML, which suits a bank’s systems and gives a reviewer nothing to sort or filter. This camt.053 to Excel Converter reads the same <Ntry> entries and writes them to an .xlsx workbook, so the statement opens in a grid you already know how to use.

The workbook has one sheet named CAMT.053 with the columns Date, Description, Amount, Memo, Category, ID and Type. Amounts are stored as numbers, not text, so SUM, pivot tables and conditional formats work on them straight away. Column widths are sized to the content. Like every converter on this site, the work happens in your browser and the XML never leaves your computer.

Key features

• Writes a single sheet named CAMT.053 with a header row and one row per entry.
• Stores Amount as a number so totals, sorting and charts work immediately.
• Writes ISO dates for unambiguous sorting in any locale.
• Sizes columns to the content, up to a readable maximum width.
• Previews the rows before you download, and runs fully in the browser.

About the CAMT.053 XML to XLSX format

The Excel output follows the entries described in the camt.053 format. Each <Ntry> becomes one worksheet row. The amount comes from the entry-level <Amt>, signed by <CdtDbtInd> (DBIT is negative). The booking date comes from <BookgDt>, and the bank’s <AcctSvcrRef> is written in the ID column.

Dates are written as ISO text such as 2026-05-03 rather than as Excel date values. This keeps the column unambiguous in every locale, and it sorts correctly. If you want day-of-week or month formulas, convert the column with DATEVALUE or Text to Columns after you open the file.

How it works

The converter reads the entries with the same rules as the camt.053 to CSV converter, then passes the rows to a spreadsheet writer. Only the Amount column is converted to a number.

Amounts are normalised to two decimal places before the workbook is written, so 2400 appears as 2400.00 and a trailing minus sign on the source value becomes a leading one.

Common use cases

• An accountant receives a monthly camt.053 bundle and wants one workbook per bank account for the review file.
• A treasury analyst builds a pivot table of outgoing payments by counterparty from a week of camt.053 statements.
• A controller sends the workbook to an auditor who does not have access to the bank portal or any XML tool.

How to use this tool

1. Download the camt.053 file from your bank or from its file transfer folder.
2. Open the camt.053 to Excel converter and upload the .xml file or paste its text.
3. Check the preview for the row count and the first and last booking dates.
4. Download the .xlsx file and open it in Excel, Numbers or Google Sheets.

Example

<Ntry><Amt Ccy="EUR">2400.00</Amt><CdtDbtInd>CRDT</CdtDbtInd>
<BookgDt><Dt>2026-05-06</Dt></BookgDt><AcctSvcrRef>BK-1002</AcctSvcrRef>
<NtryDtls><TxDtls><RltdPties><Dbtr><Nm>Client Co</Nm></Dbtr></RltdPties></TxDtls></NtryDtls></Ntry>

Date       | Description | Amount  | Memo | Category | ID      | Type
2026-05-06 | Client Co   | 2400.00 |      |          | BK-1002 |

Tips for best results

• Freeze the header row and filter on Type or Memo before you start reconciling. Blank Type cells are normal for many banks.
• Use SUM or SUMIFS on the Amount column, filtered by Type or Memo, to check subtotals against the bank’s totals. The Date column is text, so filter it by its first characters rather than by date comparison.
• Keep the .xlsx and the original .xml together. Excel edits do not change the statement the bank issued.
• Rename the file with the account and the statement date, because the workbook has no account column when a file covers one account.

Common pitfalls

Opening the file as text. If Excel shows the dates as left-aligned text, that is the ISO string format. It still sorts correctly, but you can convert it with Data > Text to Columns if you need true date arithmetic.

Assuming one workbook covers every account. A camt.053 file can hold several <Stmt> blocks. The converter lists their entries in order, and there is no account column, so split the file before you reconcile.

Mixing currencies in one column. The Ccy attribute is not written to the workbook. If the statement contains more than one currency, check the source XML before you total the Amount column.

Expecting formulas or formatting from the bank. The workbook contains values only, with plain header styling and no totals row.

Frequently asked questions

For more background on data formats and conversion workflows, read our format guides.