About CSV Cleaner

CSV Cleaner tidies a messy export without a spreadsheet. Trim every cell, drop rows and columns that are entirely blank, remove duplicate rows, fill blank cells from the value above, run a find-and-replace, and reformat the header row.

The file is read with the browser File API and the cleaned copy is built in the page. Nothing is uploaded.

How to use it

  1. Drop a CSV. The delimiter is detected automatically.
  2. Tick the operations you want; the preview and the row and column counts update live.
  3. Download the cleaned CSV.

Common questions

In what order do the operations run?

Trim, collapse spaces, drop blank rows, drop blank columns, dedupe, fill down, find and replace, then header case.

Can find-and-replace use a regular expression?

Yes, with an optional ignore-case flag. It never touches the header row.

How much of the file does the preview show?

The first 50 rows. The download contains every row.

Is my data uploaded?

No. Reading and cleaning both happen in your browser.