CSV Cleaner
Tidies up a messy CSV export. Whitespace around every field is trimmed, blank rows are removed, duplicate data rows are dropped keeping the first occurrence, and columns that are empty in every row are deleted. The delimiter is detected automatically and the result is written as standard comma-delimited CSV. Runs entirely in your browser — nothing is sent to a server.
Tidies up a messy CSV export. Whitespace around every field is trimmed, blank rows are removed, duplicate data rows are dropped keeping the first occurrence, and columns that are empty in every row are deleted. The delimiter is detected automatically and the result is written as standard comma-delimited CSV. Runs entirely in your browser — nothing is sent to a server.
Use cases
- Cleaning a spreadsheet export before importing it into a database
- Removing the trailing empty column and padded spaces Excel adds
Examples
Padded and duplicated rows
name , age Ada , 36 Ada , 36 Linus , 54
name,age Ada,36 Linus,54
FAQ
Is my data sent to a server?
No — this tool runs entirely in your browser.
Is the header row ever removed as a duplicate?
No. The first non-blank row is treated as the header and is always kept, even if a later data row happens to be identical to it.
What counts as a duplicate row?
A row whose fields all match an earlier row exactly, after trimming. The first occurrence is kept and later ones are dropped.