CSV Cleaner

Paste or upload a CSV, pick what to clean, and download the tidied file — nothing is uploaded.

Cleaning happens entirely in your browser — your CSV is never uploaded.

How it works

Messy CSVs usually have the same handful of problems: stray whitespace around values, a few duplicate rows from a bad export, blank rows left over from Excel, and columns nobody filled in. Toggle the checks you need, clean, and review the preview before downloading — the original text stays in the box so you can compare or re-run with different options.

FAQ

What counts as a duplicate row?

Two rows are duplicates if every cell matches exactly (after trimming, if that option is on). The first occurrence is kept; later ones are removed.

Will this remove my header row?

No, unless it happens to be an exact duplicate of another row further down — the header is treated as a normal row, not detected specially.

Does this handle quoted fields with commas inside them?

Yes. The parser follows standard CSV quoting rules — a comma or newline inside double quotes stays part of the field.