Convert an N26 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.
Download your N26 account activity as CSV on N26 web and convert it to Excel for free. Reading the CSV is in beta; Klarbon asks for the opening balance.
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 N26 transactions into Excel, download the account activity report on N26 web as a CSV file and drop it on Klarbon. Klarbon reads N26'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 N26 statement before you import it.
How do I download the CSV from N26?
From N26's help page (checked on 21 November 2026, source), on N26 web:
- On the Home tab, choose the account or Space and select "Downloads".
- Under "Account Activity", enter the start and end dates.
- Choose CSV as the format and select "Download".
Alternatively, go to the Spaces tab, choose the account or Space, open "Settings", then "Balance Statements", and download the report there. The monthly balance statements themselves are PDF only.
What should I know about N26's CSV?
- Signs as printed. N26 does not publish the CSV's columns, so Klarbon reads Amount (EUR) 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 report 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 the app.
- One account or Space per file. Each report covers what you chose on the Home tab. A transfer to a Space is money out in one file and money in on the other.
- No account number. The CSV does not name your IBAN. CAMT.053 and MT940 need one, so Klarbon does not offer them for this file.
Klarbon's test file for N26 is synthetic, built to the columns of N26's current export; Klarbon also knows the earlier layout without Booking Date and Value Date. 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 N26 account.
- Choose Excel or CSV and download it.
What else should I know?
From the CSV, Excel and CSV are free; OFX written from it costs one credit per started 500 transactions. Klarbon is not affiliated with N26. Klarbon reads an N26 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?
N26's account activity CSV lists transactions without any balance. Enter the balance of the account or Space before the first transaction in the file, for example from the monthly balance statement. Klarbon adds the transactions to it and shows the closing balance, which you compare with the N26 app.
How does Klarbon read the plus and minus signs?
N26 does not describe the CSV's columns, so Klarbon reads the Amount (EUR) 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 download the CSV in the N26 app?
N26's help page describes the account activity report, the export with a CSV option, on N26 web. In the app it describes the monthly balance statements, which are PDF.
What about card payments in another currency?
Klarbon reads the amount in euros, as it left the account. The original amount and the exchange rate N26 lists beside it are not carried into the rows.
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 a Commerzbank CSV export to Excel
- Convert a Qonto export to Excel
- Convert a Rabobank business bank statement to Excel