Account

What new tool do you want?

Office & Documents

CSV Cleaner & Deduplicator

Clean up a CSV file — trim spaces, remove empty rows and duplicate rows (or duplicates by one column), and fix ragged rows — all in your browser.

How to use

  1. 1Paste your CSV (the first row should be headers).
  2. 2Choose the clean-up options and copy or download the result.

Frequently asked questions

Can I remove duplicates by email only?

Yes — enter the column name (e.g. email) in 'Duplicate key column'. The first row for each value is kept.

Is matching case-sensitive?

Not when 'Ignore case' is on — so [email protected] and [email protected] count as duplicates.

Is my data uploaded?

No — the cleaning runs entirely in your browser.

What counts as a duplicate is something you choose

Without a key column, two rows only count as duplicates if every cell matches — the tool joins the whole row into one string and compares that. Set a key column like email instead, and matching narrows to just that field, so two rows with different names but the same email become duplicates of each other. Whole-row matching suits exact re-imports of the same data; column-based matching suits finding the same person across inconsistent re-entries.

Ragged rows get padded, not rejected

Real-world CSVs exported from different tools often have rows with missing trailing commas. Rather than erroring out, the cleaner pads every row to the width of the longest row with empty cells before doing anything else, so a short row's missing columns read as blank rather than shifting the rest of that row's data sideways.

A worked example: a mailing list with four rows, two duplicates

Paste name,email\nAlice , [email protected]\nalice,[email protected]\n,\nBob,[email protected] with Trim, Remove empty rows and Remove duplicates all on, 'Duplicate key column' set to email, and Ignore case on. The blank fourth row is dropped first. Then 'alice,[email protected]' is recognized as a duplicate of 'Alice , [email protected]' because Ignore case folds both emails to the same key — and since Alice's row appeared first, it's the one kept, trimmed to 'Alice,[email protected]'. The result is two clean rows from four messy ones: Alice and Bob, each appearing exactly once.

An empty paste does nothing, and the header is never treated as junk

If I clear the box, the result is simply blank. There is no error. Once there is text, the delimiter is detected and every row is padded out to the widest row before trimming or duplicate checks, so a short line does not shift later columns. Trim is on by default and it does more than the ends of a cell: repeated spaces inside a cell collapse to a single space. Empty-row removal looks only at the data lines. The header stays even if it would have looked blank. Rows-before in the summary does not count that header line.

A key that is not a real column stops the clean

Duplicate removal is on, and ignore-case is on, so the first matching row is the one kept. If I type a key column, the header match ignores capitalization, but a name that is not on the header at all stops with a message that quotes the name I typed. Leaving the key blank compares the whole row instead. The summary then shows how many data rows I started with, how many remain, and how many were removed. I can turn any of the three switches off and the same paste is reworked immediately, without a separate apply step.

Related tools

More: Office & Documents