Convert CAMT to CSV

Turn CAMT files into CSV. Every entry of the camt.053 statements, camt.052 reports and camt.054 notifications gives a row with the account's IBAN, the booking date, the signed amount, its currency, the other party's name, the remittance text, the end-to-end reference, the bank transaction code as the type and the bank's reference as the id.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop CAMT files on the dialor turn it to pick what to do

One row per entry from your bank statement.Each camt entry becomes a CSV row with the date, amount, payee and memo.

  1. What you get

    One CSV file. Every entry of a camt.053 statement, camt.052 report or camt.054 notification gives one row. An entry that books several payments at once stays one row, with the names of the other parties joined.

    The header reads account, date, amount, currency, payee, memo, reference, balance, type, category and id. The account column holds the IBAN. The payee is the other party's name, the memo is the remittance text, and the reference is the end-to-end reference.

  2. How values are written

    Dates are written as YYYY-MM-DD. Amounts are signed, negative for money out, and keep the digits the file wrote. The currency sits in its own column.

    The type column holds the bank transaction code, and the id column holds the bank's reference.

  3. Balances

    Each balance is counted from the opening balance, when the count meets the closing balance. A balance the file does not give stays empty.

    To combine several statements after converting them, you can use merge CSV. For other CSV outputs, see every CSV conversion.

CAMT and CSV.What each format is.

The formats

From · CAMT

ISO 20022 camt Statement

The XML bank statements of ISO 20022 that SEPA banks deliver: camt.053 statements, camt.052 intraday reports and camt.054 notifications.

Extensions
.camt
MIME type
application/x-camt+xml
Kind
Text and data
To · CSV

CSV

Rows of comma-separated values. The plainest way to move a table between programs.

Extensions
.csv
MIME type
text/csv
Kind
Text and data

In your code.The same CAMT to CSV conversion through the API, for your app or your agent.

terminal
$ cv convert report.camt report.csv
$ cv convert report.camt report.csv

Questions.What people ask about CAMT to CSV.

01OF 04

Yes. Statements, intraday reports and notifications all give one row for each entry.

By the sign in the amount column. Negative amounts are money out.

It stays one row. The names of the other parties are joined in that row.

The file does not give that balance. A balance the file does not give stays empty.

More conversions.Other ways in and out of CAMT and CSV.