Remove Duplicate Rows

Add a spreadsheet, choose which columns must match, and remove the repeats.

Drop a spreadsheet here, or click to choose

XLSX, XLS, ODS or CSV. Nothing is uploaded.

Private: everything happens in your browser. Nothing you add is uploaded.

  1. Add a spreadsheetExcel or CSV.
  2. Choose the columnsthat make a row a duplicate.
  3. Downloadthe cleaned file, or just the duplicates.

Remove duplicates from Excel and CSV

Duplicate rows creep in when lists are merged or exported twice. This tool removes duplicate rows from Excel and CSV files and shows exactly which rows are repeats (highlighted in red) before you download. Compare whole rows, or only key columns: for example, treat two contacts with the same email address as duplicates even if their names are spelled differently.

How to remove duplicate rows
  1. Drop your spreadsheet onto the box. If it has several sheets, choose one at the top.
  2. Under A row is a duplicate when these match, tick the columns to compare. Leave all ticked to compare whole rows; tick just “Email” to find people listed twice.
  3. Keep Ignore capitals and Ignore extra spaces ticked so “John@Mail.com ” and “john@mail.com” count as the same.
  4. Check the red rows in the preview: they'll be removed.
  5. Click Download cleaned file, or Download only the duplicates to review them separately.

Questions

Which copy is kept?

The first one, unless you choose “the last copy”. Rows keep their original order.

Is my data uploaded?

No. The file is cleaned in your browser, so customer lists and private data stay on your computer.

More spreadsheet tools

Excel to CSVSave any sheet as a CSV file. CSV to ExcelTurn CSV files into proper spreadsheets. Merge SpreadsheetsCombine sheets or files into one. CSV ViewerOpen and search big CSV files instantly. Split SpreadsheetBreak a big sheet into smaller files.