Convert Knab transactions in CSV 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 Knab transactions as CSV in the Persoonlijke Bankomgeving and convert them to Excel for free. Reading the CSV is in beta; check the preview.
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 Knab transactions into Excel, download them as a CSV file in the Persoonlijke Bankomgeving and drop it on Klarbon. Klarbon reads Knab'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 Knab statement before you import it.
How do I download the CSV from Knab?
Knab's help page gives the steps in Dutch (checked on 21 November 2026, source). They apply to private and business transactions alike:
- Log in to your Persoonlijke Bankomgeving in a web browser.
- Click the account, then "Zoeken en downloaden".
- Set the filter you want, such as the period, and click "Zoeken".
- Click download to download the selection. Knab offers it as PDF, Excel or CSV: choose CSV.
The monthly statements (afschriften) are PDF.
What should I know about Knab's CSV?
- D and C instead of signs. Each amount is printed without a sign, with D or C beside it in CreditDebet. Knab does not describe the columns, so Klarbon reads D as money out and C as 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 Knab.
- A title line first. The file starts with a line reading KNAB EXPORT above the column headings. Klarbon skips it.
- Newest first. Knab lists the latest transaction first; Klarbon puts the rows in date order.
Klarbon's test file for Knab is synthetic, built to the columns of real Knab 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 Knab 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 Knab. Klarbon reads a Knab 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?
Knab's CSV lists the transactions without a balance before or after them. Enter the balance of the account before the first transaction in the file, for example from the monthly statement. Klarbon adds the transactions to it and shows the closing balance, which you compare with Knab.
How does Klarbon read money in and money out?
Knab prints every amount without a sign and marks it D or C in the CreditDebet column. Knab does not describe these columns, so Klarbon reads D as money out and C as money in. The preview shows every amount with its sign before you download anything.
I have a business account. Should I use CAMT.053 instead?
You can. Knab offers business accounts CAMT.053 and MT940 under the account's three dots, "boekhoudexport". A CAMT.053 file states its own balances and opens in the converter for [CAMT.053 to Excel](page:camt-excel-en), also in beta. The CSV works for private and business accounts.
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 the Netherlands: current and planned rules
- Understanding Excel workbook (XLSX)
- Convert a Commerzbank CSV export to Excel
- Convert an N26 CSV export to Excel
- Convert a Qonto export to Excel