Remove duplicate rows from a CSV file

Duplicate rows inflate totals, break imports and send the same email twice. CSVFix finds rows that are identical and keeps the first copy of each.

Open CSVFix

How to do it

  1. Drop your CSV file on the page, or paste a table from Excel or Google Sheets.
  2. Keep Remove duplicate rows switched on. Turn on Ignore case if ANA@mail.com and ana@mail.com should count as the same row.
  3. Check the preview. Removed rows are highlighted in red, so you can see exactly what will disappear.
  4. Download the result as CSV or Excel.

Why it happens

Duplicates usually appear after merging several exports, importing the same file twice or copy-pasting data by hand. Rows that differ only by stray spaces are not caught by most tools, so CSVFix trims spaces first and then compares rows.

Questions

Does it keep the first or the last copy?

It keeps the first occurrence and removes the later ones.

Can I compare only one column, like email?

Not yet. CSVFix currently compares whole rows.

Is my file uploaded to a server?

No. The file is processed inside your browser tab and never leaves your device.

Clean your CSV now

More CSV fixes