FilePDQ

Clean up a bank CSVFREE

Tidy dates and amounts in a bank export, ready for your spreadsheet.

  1. 1 Add
  2. 2 Convert
  3. 3 Download

Drop a bank CSV here

CSV. Up to 20 MB each, 20 at once.

Stays on your device

Questions about Clean up a bank CSV

Is Clean up a bank CSV free?

Yes. It is free to use, with no sign-up, no watermark and no limit on how often.

Are my files uploaded?

No. It runs in your browser, so your files stay on your device and are never sent to us or anyone else. Privacy notice

Which files can I use?

CSV in, CSV out. Up to 20 MB per file, 20 files at a time.

Step by step, and if something goes wrong

Steps

  1. Download a CSV from your online banking (never share your bank login with any website).
  2. Drop the CSV here and say how dates are written in it.
  3. Select Clean up CSV, check the report, then download.

If something goes wrong

  • Amounts like £1,234.50, (12.00) and 12.00 DR become plain numbers; debits become negative.
  • A value that can’t be read with confidence is left exactly as it was and listed in the report. Nothing is guessed.
  • Keep “Remove duplicate rows” off if the same purchase can genuinely happen twice in a day.
  • Tick “Open in Excel” so the £ sign and accents show correctly in Excel.