Remove duplicates
Find and delete duplicate rows in an Excel, CSV or ODS file. The first row of each group stays.
The tool could not be loaded. It needs JavaScript: please enable it or reload the page.
or drag them here
CSV, TXT, Excel (XLSX, XLS), OpenDocument (ODS) or JSON.
Values like 12.50 become numbers. Leading zeros (postcodes, IDs) stay text.
These rows are dropped
Preview
No image chosen yet.
Frequently asked questions
Which row stays?
Always the first. Later identical rows are dropped; the list shows which row was the same as which.
Can I search by one column only, such as the email address?
Yes. Untick all columns except that one. Rows with the same email address then count as duplicates.
More tools in this category
- Convert spreadsheets Convert between CSV, Excel, ODS and JSON.
- Split a spreadsheet Split large CSV or Excel files.
- XML ↔ JSON Convert XML to JSON and back.
- Compare tables Compare two Excel or CSV files.
- Average & median Mean, median, standard deviation, quartiles.
- YAML ↔ JSON Convert YAML to JSON and back.