1. Export the file from your bank
- In your online banking or banking software look for the intraday report, account report or camt.052 download.
- Download the .xml file. If it comes as a .zip, unzip it and upload one .xml at a time.
- Upload the .xml file here exactly as downloaded.
Why a raw camt.052 export fails in Excel, Google Sheets or LibreOffice
Opened in Excel, a camt.052 file is a deep XML tree, often with several reports that repeat the same bookings. Amounts, credit or debit marks, statuses and names sit in different nested elements.
Excel and Google Sheets open a CSV directly, but only if it is a simple table. A bank statement file has to be turned into one first.
What is unusual about the camt.052 file
- Versions camt.052.001.02 to .001.08 are read.
- Only booked entries (status BOOK) are converted. Pending (PDNG) and information (INFO) entries are left out, counted and named in a warning.
- A report is balance-checked only when it carries a booked opening balance (OPBD, PRCD or an earlier ITBD) and a booked closing balance (CLBD or a later ITBD) and has no pending entries. Otherwise the result says it was not checked.
- A booking identical in every field, with a real bank reference (AcctSvcrRef), to one in an earlier report of the same file is left out as a repeat, with a warning listing its date and amount. Without a real reference (AcctSvcrRef empty, NONREF or NOTPROVIDED; NtryRef does not count) both are kept, with a warning. A booking with the same reference, date and amount but other fields different is kept, with a warning.
- The same bookings come again in the end-of-day camt.053 statement. Do not import both.
- Only the spreadsheet CSV is offered.
What Excel, Google Sheets or LibreOffice requires
- One row per transaction: Date, Value date, Amount, Currency, Debit/Credit, Counterparty, Counterparty account, Description, Reference, Balance.
- Comma style: commas between columns and 1234.56 amounts. Semicolon style: semicolons and 1234,56 amounts.
- Dates are written as YYYY-MM-DD unless you choose another format.
- Text that starts with = + - or @ gets an apostrophe in front so a spreadsheet does not run it as a formula.
2. Before and after
Before: the camt.052 account report as downloaded
<?xml version="1.0" encoding="UTF-8"?>
<!-- CONSTRUCTED fixture (BooksReady, 2026-11-09): invented account, names and amounts.
Layout: ISO 20022 camt.052.001.08 element names as used in the SIX Implementation
Guidelines for Cash Management v2.0.2 (Rpt, Bal OPBD + ITBD, Ntry Sts/Cd BOOK and PDNG).
Report 1 adds up (OPBD 1000.00 + 250.00 - 80.40 = ITBD 1169.60).
Report 2 is a "full" report: it repeats report 1's two bookings, adds one booked entry
(-19.90) and one pending entry (-500.00), so it is not balance-checked. -->
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.052.001.08">
<BkToCstmrAcctRpt>After: what Excel, Google Sheets or LibreOffice receives
| Date | Value date | Amount | Currency | Debit/Credit | Counterparty | Counterparty account | Description | Reference | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2026-03-10 | 2026-03-10 | 250.00 | CHF | Credit | Muster Bakery GmbH | CH9300762011623852957 | Invoice 2026-031 | INV-2026-031 | |
| 2026-03-10 | 2026-03-10 | -80.40 | CHF | Debit | Office Paper AG | Order 5521 | CH-20260310-0002 | ||
| 2026-03-10 | 2026-03-10 | -19.90 | CHF | Debit | Account fee March | CH-20260310-0003 |
Synthetic sample data that follows the real export layout, not a real account. The "after" output was produced from it by the same converter this page runs.
3. Import the converted file into Excel, Google Sheets or LibreOffice
- Open the downloaded file in Excel, Google Sheets or LibreOffice.
- If every value lands in one column, use the semicolon style (for European Excel) or import it with Data > From Text/CSV.
Questions
- Why are some entries missing from the result?
- Entries with status PDNG (pending) or INFO are not booked yet, so they are left out, and a booked entry whose amount or date cannot be read is left out too. A booking is also left out when it is identical in every field, with a real bank reference (AcctSvcrRef), to one in an earlier report of the same file. Each of these gets a warning above the result with the amounts, so you can check them. Bookings that only look like repeats are kept, with a warning.
- Why does everything land in one column in Excel?
- Excel uses the list separator of your computer's region. In much of Europe that is a semicolon and the decimal mark is a comma. Choose the semicolon style and download again, or open the file through Data > From Text/CSV and pick the separator there.
- Can I import this into QuickBooks or Xero?
- Not from this page. The bookings in a camt.052 report come again in the end-of-day camt.053 statement, so importing both would count them twice, and pending entries can still change. Only the spreadsheet CSV is offered. Convert the camt.053 statement for your books.
- Are accents and umlauts kept?
- Yes. The file is UTF-8 and starts with the marker Excel looks for, so names such as Müller or Société open correctly.