Skip to content

Bank Statement CSV Formatter

Bank exports use local formats such as 31/01/2026 and 1.234,56 that accounting software and spreadsheets often misread. This tool converts the dates to YYYY-MM-DD and the amounts to plain numbers with a dot, and keeps descriptions and references exactly as written.

Processed in your browser · never uploaded

  1. 1Add input
  2. 2Review
  3. 3Download
Column numbers in the file

How to use the Bank Statement CSV Formatter

  1. Choose the CSV export from your bank, or paste it.
  2. Choose the date format, decimal and thousands separators, and the column numbers of the date, description and amount.
  3. Select Convert statement, review the result and download the converted CSV.

Supported files and limits

  • Choose the date format yourself: a date such as 02/03/2026 can mean 2 March or 3 February, and the tool never guesses.
  • If any row cannot be converted, no file is created. Instead you get a list of the rows to fix, so no transaction is dropped silently.
  • The output has five columns: date, description, amount, currency and reference. Other columns are left out.
  • Up to 50,000 rows or 20 MB, in UTF-8 or Windows-1252 encoding.

Common questions

Why does Excel show my bank amounts wrongly?
An amount such as 1.234,56 uses a comma as the decimal separator. With English settings, Excel reads it as text or as the wrong number. The converted file uses 1234.56, which software reads consistently.
Which banks are supported?
Any bank whose export is a CSV or text table with one transaction per row. You tell the tool which column holds what, so the bank does not matter.
Can it read PDF statements, MT940 or CAMT files?
No. Only CSV and text table exports are supported.
Is my bank statement uploaded?
No. The conversion runs in your browser, and your statement is never sent to our server or anyone else.

Related tools