Your bank gives you statements as PDF files. They are fine for reading, but useless when you want to add up your spending per category, prepare your taxes, send figures to an accountant or import transactions into budgeting software.
Copy and paste rarely works: columns end up in a single cell, amounts become text and long descriptions are cut in two. Here is a cleaner way.
Convert the statement in four steps
- Download the statement as a PDF from your online banking. A PDF downloaded from the bank contains real text, which gives far better results than a photo or a scan.
- Open Bank statement to CSV and select the PDF. You can add several months at once.
- Choose CSV (for import into software) or Excel (to work on the figures directly). If your Excel is in French or another language that uses a comma for decimals, choose the semicolon separator.
- Download the file and open it.
You get one row per transaction, with the date, description, debit, credit and balance in separate columns.
What the converter fixes for you
Bank statements are designed for reading, so their tables have quirks that break a simple copy:
- No grid lines. The columns are rebuilt from the position of the text on the page.
- Right-aligned amounts. Debit and credit amounts stay in their own columns even when their width changes.
- Descriptions on two lines. The second line is joined back to its transaction instead of creating an empty row.
- Headers on every page. All pages are merged into one table and the column titles are kept only once.
- Number formats. In the Excel version, 1,250.00, 1 250,00 and (85.00) become real numbers, so SUM and pivot tables work straight away.
CSV or Excel: which one should I choose?
| You want to… | Choose |
|---|---|
| Import into accounting or budgeting software | CSV |
| Open in Google Sheets | CSV or Excel |
| Sort, filter and add up in Excel | Excel |
| Keep one sheet per page, with layout | PDF to Excel |
For other kinds of tables (reports, price lists, invoices), PDF to CSV works the same way.
My statement is a scan or a photo
A scan is a picture: there is no text to read. First run it through OCR PDF to recognise the text, then convert the result. Use a straight, well-lit scan for the best accuracy, and check the totals after conversion.
Is it safe?
Statements contain sensitive data, so the processing is fully automatic: the file travels over an encrypted connection, nobody reads it, and it is deleted automatically after one hour. You can also delete it immediately with one click after downloading your CSV.