Free Bank CSV Cleaner

Tidy up a bank CSV before you import it. This tool runs a few safe, predictable cleanups on the file you upload and lets you download the result. Each step is optional — turn on only what you need.

What it does

• Trim whitespace. Removes leading and trailing spaces from every cell.
• Remove duplicate rows. Drops rows that are an exact match across all cells (compared after trimming), keeping the first occurrence.
• Normalize dates to ISO (YYYY-MM-DD). Converts the values in one date column you choose. A date-order selector lets you pick Auto, Day/Month/Year, or Month/Day/Year. In Auto mode, only dates that are unambiguous on their own are converted; any date whose day/month order is unclear (for example 03/04/2026) is left exactly as it is and flagged. Pick DMY or MDY to convert those rows — the cleaner never guesses an order for you.

After each run you see input rows, rows remaining after dedupe (and how many were removed), how many dates were normalized, and how many were flagged. The cleaned table is previewed before you download.

What it does not do

To keep the output predictable, this tool does not split packed columns into separate fields, merge debit and credit columns into a single amount, or detect and strip repeated header or footer rows. It only performs the three operations listed above.

How it works

1. Upload your bank CSV.
2. Choose which cleanups to apply, pick the date column, and set the date order if you're normalizing dates.
3. Review the cleaned preview and the before/after counts, including any flagged dates.
4. Download the cleaned CSV.

Everything runs in your browser — the file is never uploaded.

Related tools and guides

If you only want to check a file rather than change it, the bank statement to CSV guide walks through getting a clean export in the first place. Starting from a PDF? See how to convert a PDF bank statement to CSV, then run the result through this cleaner.