CSV that comes from scraping, copying or exporting often arrives with padded cells and stray empty rows.
This cleaner parses the CSV first, then trims whitespace from each cell and drops blank rows, so the cleanup never corrupts quoted values.
How to use CSV Cleaner
- Paste your messy CSV into the left panel.
- Toggle Trim cell whitespace and Remove empty rows as needed.
- Copy the cleaned CSV from the right panel or download it.
What you can do with it
- Tidy a scraped CSV before importing it.
- Remove blank rows from a copied table.
- Trim padded cells in an export.
Good to know
Trimming should happen after parsing, not as a raw string replace, otherwise spaces inside quoted values could be damaged. This tool parses first, so quoted fields stay intact while padding is removed.
Frequently asked questions
Why trim after parsing?
Because trimming raw CSV text could alter spaces inside quoted values; parsing first means only cell contents are trimmed.
What counts as an empty row?
A row where every field is empty after trimming is treated as empty and removed when the toggle is on.
Are quoted fields preserved?
Yes. Quoting is reapplied on output, so values that need quotes keep them.