CSV Cleaner
Clean a CSV online: trim cells, remove duplicate or empty rows, drop empty columns, pick and reorder columns and fix header case, with a before and after summary.
How to use CSV Cleaner
- 1Paste CSV or open a file and check the detected delimiter.
- 2Turn on the cleaning steps you want: trimming, duplicates, empty rows or columns, column choice.
- 3Read the summary, then copy or download the cleaned CSV.
What makes it better
- Remove duplicate rows by every column or only by the columns you tick, optionally ignoring case
- Trim cells and normalise runs of whitespace and line breaks
- Remove empty rows and columns with no data
- Tick the columns to keep and reorder them with Up and Down
- Summary such as Removed 14 duplicate rows, 3 empty rows, plus a preview of the result
About CSV Cleaner
CSV Cleaner tidies a messy CSV in one pass: it trims cells, removes empty rows, removes duplicate rows by the whole row or by the columns you choose, drops empty columns and lets you keep, hide and reorder columns. A summary tells you exactly what was removed, and a preview shows the result before you copy or download it.
Common uses
- Prepare a mailing list by removing duplicate email rows.
- Clean a spreadsheet export before importing it into a CRM or database.
- Drop unused columns and put the important ones first.
- Standardise header names to lowercase or Title Case before a data load.
Example
Input
name,city Asha ,Chennai Ravi, Pune , Asha ,Chennai
Result
name,city Asha,Chennai Ravi,Pune Asha,Chennai
Good to know
- The first row is treated as the header, so it is never removed as a duplicate or empty row. Turn off First row is header for data without one.
- Duplicates keep the first occurrence and drop later ones. Comparing by chosen columns ignores the other columns, so rows that differ elsewhere are still removed.
- Short rows are padded with empty cells to the widest row so every output line has the same number of columns, and the summary says how many were padded.
CSV Cleaner FAQ
How do I remove duplicate rows from a CSV?
Set Duplicates to Remove duplicate rows to compare entire rows, or to Remove by chosen columns and tick the columns that define a duplicate, such as email. The first match is kept.
Can I keep only some columns and change their order?
Yes. Open Advanced, untick the columns you do not need and use the arrows to move the rest. The header and every row follow the new order.
What does Normalise whitespace do?
It turns every run of spaces, tabs and line breaks inside a cell into a single space and trims the ends, which fixes copy-pasted text with stray breaks.
Does it remove the header row if it is empty or repeated?
No. With First row is header on, the header is always kept. Only the data rows are checked for emptiness and duplicates.
What counts as an empty column?
A column in which no data row has any text, ignoring the header cell. Turn on Remove empty columns under Advanced to drop it.