Remove duplicates from a file
Choose the columns that make one row the same as another. The tool shows the duplicates before removing them, and gives you the file without them, with the list of what was removed.
What this tool does
- The columns that matter, your choice: all of them, just the email address, or the name and the city.
- Case, extra spaces and accents ignored on request: "SMITH LTD" and "Smith Ltd" become the same value.
- The first or the last occurrence kept.
- A "Removed duplicates" sheet in the output file, so you can check.
What it does not do: These are exact duplicates once case, spaces and accents are set aside. "Smith Ltd" and "Smith Limited" are not recognised as the same company: fuzzy matching is a different job, with a row-by-row review.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Fix a CSV file : Broken accents, everything in one column, lost zeros: a file Excel opens right the first time.
- Near-duplicates : "Smith Ltd" and "SMITH LTD.": the almost-identical duplicates, reviewed one by one.
- Clean text : Extra spaces, non-breaking spaces, line breaks, invisible characters, case.
- Convert text to numbers : "1,234.56 $", "(45.00)", "12.5-": real numbers that add up.
- Fix dates : Dates as text, day and month swapped, "20260315": real dates.