Skip to content

Convert an ABN AMRO bank statement to Excel

Beta This tool is in beta. It is tested on sample files, and details may still change. Review the result before relying on it.

Download your ABN AMRO transactions as CAMT.053, then convert the file to Excel or CSV for free. Klarbon checks the balances and shows a preview.

No file to hand? Try a sample statement

In short

Turn a bank statement file or a PDF statement into Excel, CSV, CAMT.053, MT940 or OFX. Klarbon reads a PDF statement into a draft; check the result before you use it. CSV and Excel free from bank files, otherwise 1 credit (€1.99).

To turn an ABN AMRO bank statement into Excel or CSV, download your transactions from ABN AMRO as a CAMT.053 file and drop it on Klarbon. Klarbon checks ABN AMRO's PRCD and CLBD balances against the entries and writes the spreadsheet for free. Reading CAMT.053 is in beta. The steps below are for a private account in ABN AMRO Internet Bankieren or the ABN AMRO app.

How do I download a CAMT.053 file from ABN AMRO?

ABN AMRO's help page names the menus in Dutch (checked on 10 November 2026, source). In Internet Bankieren:

  1. Log in and open "Bij- en afschrijvingen downloaden" (download transactions).
  2. Choose the account holder and the file format: pdf, txt, mt940, xls or camt.053. Choose camt.053.
  3. Choose a start date and an end date. Transactions go back up to 18 months.
  4. Click the download symbol to the left of the account you want, and save the file.

In the ABN AMRO app, go to "Profiel" > "Rekeningen en betalen" > "Afschriften en jaaroverzicht", choose the account holder, tap "Bij- en afschrijvingen" under "Soort overzicht", then choose the dates and the format camt.053.

The monthly statements (rekeningafschriften) come as PDF only; the camt.053 file comes from the transactions download.

What is in an ABN AMRO camt.053 file?

ABN AMRO publishes an addendum to the CAMT standard for its files, version 1.5 of July 2015, written for camt.053.001.02. What matters for your spreadsheet:

How do I convert it with Klarbon?

  1. Drop the camt.053 file on the box above.
  2. Check the period and the balance check in the preview, then the rows.
  3. Choose Excel or CSV and download it.

Klarbon is not affiliated with ABN AMRO. The menu names above are ABN AMRO's and can change; if they differ, follow ABN AMRO's own help page.

The other downloads, and a PDF

Klarbon does not read the xls or txt download. The mt940 download is read too, by the converter for MT940 to Excel. Klarbon reads a PDF rekeningafschrift into a draft, and a download from it costs one credit per started 10 pages; compare it with the original before you import it. From the camt.053 file, Excel and CSV are free; MT940 or OFX written from it cost one credit per started 500 transactions.

Frequently asked questions

Which file should I download from ABN AMRO?

camt.053. Of the five choices ABN AMRO offers (pdf, txt, mt940, xls and camt.053), it is the one that carries the booked opening and closing balance next to every transaction in its own field, so Klarbon can check the period before writing anything.

How far back can I go?

ABN AMRO says you can download your transactions up to 18 months back. Older months are only available as monthly statements (rekeningafschriften) in PDF.

Why is a SEPA batch one row in my sheet?

ABN AMRO's CAMT description does not list the single payments of a batch you sent, only the batch total. Klarbon cannot split what the file does not contain, so the batch is one row with its total. Your payment overview in Internet Bankieren shows the payments inside it.

The file opens as one long line in a text editor. Is it broken?

No. ABN AMRO writes the whole XML without line breaks, as its description allows. Klarbon reads it the same way as an indented file.

Sources

Updated 16 November 2026