Home › Spreadsheets & Data › Clean CSV
✨

Clean CSV

Trim spaces, drop empty rows and remove duplicate rows.

✓ Free✓ No watermark
Advertisement
  1. 1Upload
  2. 2Settings
  3. 3Download

How to use Clean CSV

Add your file (or type your content) using the box above.
Adjust the options if you want something different from the defaults.
Click the button, then download your result.

About Clean CSV

Data copied from different places is rarely tidy: stray spaces around names, blank lines between records and the same row repeated several times. This free tool cleans a CSV file in your browser with four optional steps and tells you how many rows it removed.

It can trim spaces around every cell, remove completely empty rows, remove duplicate rows and lower-case the header row. A duplicate means the whole row is identical to an earlier one, and the first copy is kept. The cleaned data is saved as a new file ending in _clean.csv, and your original is never changed.

How it works: the tool tidies a CSV by trimming stray spaces, removing empty rows and optionally dropping duplicate rows, then writes a cleaner file. It improves consistency without changing what the data means.

Step by step: 1) add your CSV; 2) tick the cleaning options you want; 3) run it; 4) review the summary and download the file. Compare the row count before and after to make sure only what you intended was removed.

Realistic limits: automatic cleaning cannot know what is wrong with your data. It will not correct misspelt names, convert date formats, or decide which of two conflicting duplicates is correct. Removing duplicates assumes identical rows are true duplicates, which is not always the case for transaction lists. Processing runs locally.

Typical uses: preparing a mailing list for import, tidying an export from a form tool, or removing trailing blank lines that make importers fail.

What to check: whitespace at the start or end of cells causes mismatches in lookups and joins, since "Smith" and "Smith " are different strings. Blank rows often come from copying ranges out of a spreadsheet, and duplicate rows from combining exports. Cleaning these first makes later imports predictable.

What it leaves alone: spelling, capitalisation, date formats and numeric formats are deliberately untouched, because the right choice depends on your data. For those, use find and replace in a spreadsheet or a script. After cleaning, check the totals: compare the row count and a key column sum with the original so you know exactly what changed.

Tips for better results

  • Trim spaces first. Two rows that differ only by a trailing space are otherwise not treated as duplicates.
  • Lower-casing only affects the header row, not the data in the cells.
  • To remove duplicates based on one column only, open the cleaned file in a spreadsheet and use its own duplicate tool.
  • Large files can be cut into pieces with CSV split.
  • Keep an untouched copy before cleaning.
  • Run duplicates removal only when rows are meant to be unique.
  • Check key columns such as IDs afterwards.