ColumnryCSV the way your software expects it
Choose a comma-separated file with a dot as the decimal mark, or a semicolon-separated file with a decimal comma for European Excel. Files are UTF-8 with a byte-order mark, and cells that start with = + - or @ are protected so they are not run as formulas.
OFX and QIF
OFX (bank or credit card) and QIF files contain the date, amount, description and reference of each transaction, with a stable ID per row so that re-importing is easier to spot.
Dates and amounts
Dates are written as real dates (ISO 2024-03-05 in CSV), and amounts as signed numbers: negative for money out.
How it works
- Download the statement from your online banking as a PDF.
- Open it in Columnry. The PDF is read on your device and is not uploaded.
- Check the columns and rows, fix anything that is off, and export to Excel, CSV, OFX or QIF.
What you get
Stays on your device
There is no server behind the converter, and the page's security policy blocks every network connection. You can turn off Wi-Fi after it opens.
Finds the columns
Date, description, money out, money in and balance are detected from the layout and the headers, across all pages of the statement.
Balance check
When the statement has a running balance or totals, Columnry checks every row against it and marks the rows that don't add up.
Review before export
Change what each column means, move the column lines on the page, untick rows that are not transactions, and correct any cell.
Dates and numbers from many countries
1,234.56 and 1.234,56, 31/12 and 12/31, month names in many languages, minus signs, brackets, CR/DR and Arabic-Indic digits.
Remembers your bank
Save the column setup once, and the next statement with the same layout is read the same way.
Good to know
- Columnry reads PDFs that contain real text, which is what online banking usually produces. Scanned or photographed statements (images) are not supported: there is no OCR. The app tells you when a PDF has no text.
- Statement layouts differ a lot. Always check the result, especially the balance check, before you rely on it.
- Password-protected PDFs work if you know the password. Columnry cannot remove protection you don't have the password for.
Questions
Which programs can import these files?
Many programs can, but each has its own rules. Check your software's import help for the format it prefers.
Can I change the column order?
Open the CSV in Excel or another spreadsheet and arrange it as you like, or use the Excel export.
Is my statement uploaded?
No. Columnry runs in your browser. The converter page is not allowed to send data anywhere, and it keeps working offline.
What does it cost?
Previewing the whole statement is free, and you can export the first page (up to 20 rows). A 30-day pass costs $9 and a lifetime key costs $29, paid once.
Does it work with my bank?
It works with most text-based PDF statements, whatever the bank, because it reads the layout rather than using a fixed list of banks. Try your file with the free preview first.