Convert CAMT to ODS

Turn CAMT files into ODS. 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, in a single ODS sheet.Each camt entry becomes a row with its IBAN, date, amount and references.

  1. What you get

    One ODS file with one sheet, named after the file. The rows sit under a bold header. The columns are the same as in the csv conversion.

    Every entry of camt.053 statements, camt.052 reports and camt.054 notifications gives one row. A row holds the account's IBAN, the booking date, the signed amount, its currency, the other party's name, the remittance text and the end-to-end reference. It also holds the bank transaction code as the type and the bank's reference as the id.

    An entry that books several payments at once stays one row, with the names joined.

  2. How cells are typed

    Dates are date cells shown as YYYY-MM-DD. Amounts and balances are number cells shown with as many decimals as the file wrote.

    Every other column is text. Account numbers and ids keep their leading zeros and all their digits.

  3. Balances

    Each balance is counted from the opening balance when the count meets the closing balance.

CAMT and ODS.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 · ODS

OpenDocument Spreadsheet

OpenDocument spreadsheet, the native format of LibreOffice Calc.

Extensions
.ods
MIME type
application/vnd.oasis.opendocument.spreadsheet
Kind
Documents

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

terminal
$ cv convert report.camt report.ods
$ cv convert report.camt report.ods

Questions.What people ask about CAMT to ODS.

01OF 04

camt.053 statements, camt.052 intraday reports and camt.054 notifications. Every entry in them gives a row.

Yes. Account numbers and ids are stored as text, so they keep their leading zeros and all their digits.

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

See every ODS conversion for the other formats that convert to ODS.

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