Convert a Commerzbank CSV export 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.
Export your Commerzbank transactions as CSV in online banking and convert them to Excel for free. Reading the CSV is in beta; check the preview first.
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 your Commerzbank transactions into Excel, export them from online banking as a CSV file and drop it on Klarbon. Klarbon reads Commerzbank's CSV layout in beta and writes Excel or CSV at no charge. The file prints no balances, so Klarbon asks for the opening balance. Compare the result with your Commerzbank statement before you import it.
How do I export the CSV from Commerzbank?
From Commerzbank's help page (in German, checked on 21 November 2026, source), in online banking:
- Log in and open the transaction overview ("Umsatzübersicht").
- Choose the account.
- Click "PDF/CSV" on the right above the transactions.
- Choose "Umsätze exportieren".
- Set the period and, if you like, the sort order, an amount range, incoming or outgoing payments only, or the type of transaction.
- Choose CSV as the file format and click "Exportieren".
The overview covers the last 24 months, or 60 months with Commerzbank's premium products.
What should I know about Commerzbank's CSV?
- Signs as printed. Commerzbank does not publish the CSV's columns, so Klarbon reads the Betrag column with its sign: a minus is money out, no sign is money in. The preview shows each amount with its sign before any download.
- No balances. The file has no opening or closing balance. Klarbon asks for the balance before the first transaction and works the closing balance out from it. That proves the arithmetic, not that every transaction is there, so compare the closing balance with your account.
- Details in one column. Commerzbank puts the counterparty, the reference and a direct debit's mandate in Buchungstext. Klarbon keeps that text, after the Umsatzart, as the row's description.
- Rows of zero. An information line, such as a Rechnungsabschluss, can carry an amount of 0. Klarbon keeps it as a row of 0.00.
- Any sort order. Newest or oldest first, Klarbon puts the rows in date order.
Klarbon's test file for Commerzbank is synthetic, built to the columns of real Commerzbank exports. If your file has other column headings, Klarbon matches them by name and says so on the preview.
How do I convert it with Klarbon?
- Drop the CSV file on the box above.
- Enter the opening balance when Klarbon asks for it.
- In the preview, check the signs, the dates and the closing balance against your Commerzbank account.
- Choose Excel or CSV and download it.
What else should I know?
From the CSV, Excel and CSV are free; MT940, CAMT.053 or OFX written from it cost one credit per started 500 transactions. Klarbon is not affiliated with Commerzbank. Klarbon reads a Commerzbank PDF statement into a draft, at one credit per started 10 pages for a download; compare it with the original before you import it.
Related
Frequently asked questions
Why does Klarbon ask for an opening balance?
Commerzbank's CSV lists the transactions but no balance before or after them. Enter the balance your account had before the first transaction in the file, from your statement or online banking. Klarbon adds the transactions to it and shows the closing balance it works out, so you can compare that with Commerzbank before you import.
How does Klarbon read the plus and minus signs?
Commerzbank does not describe the CSV's columns, so Klarbon reads the Betrag column as printed: a minus is money out, no sign is money in. The preview shows every amount with its sign before you download anything.
Can I export the CSV in the Commerzbank app?
Commerzbank's help page lists the PDF and CSV export for online banking in a browser. For the banking app it lists viewing transactions, not exporting them.
Is the CSV the same as my Kontoauszug?
No. The CSV is the list of transactions you filtered, not the bank statement. Klarbon reads it in beta, so compare the result with your Commerzbank statement before you import it into accounting software.
Sources
Related
- Open any e-invoice. Check it. Convert it.
- Klarbon help centre
- Bank statement tools
- Convert a CAMT.053, MT940 or OFX bank statement to CSV
- Understanding Bank CSV export
- Convert a CAMT.053, MT940 or OFX bank statement to Excel
- Why do my statement balances not match?
- Supported bank statement files
- Simple pricing for invoices and bank statements
- What happens to my files?
- E-invoicing in Germany: dates and exceptions
- Understanding Excel workbook (XLSX)
- Convert an N26 CSV export to Excel
- Convert a Qonto export to Excel
- Convert a Rabobank business bank statement to Excel