CSV Duplicate Row Cleaner
Business
New
Find and remove duplicate rows, based on whichever columns matter.
Your CSV
Drop a .csv file, or paste its contents below.
Drag a CSV file here, or click to browse
Columns to compare
Rows are duplicates if all selected columns match. Turn off a column (like a unique ID) to compare on the rest.
Cleaned result
Duplicates removed, first occurrence of each kept.
1 duplicate found
| name | city | |
|---|---|---|
| Ada Lovelace | ada@example.com | London |
| Grace Hopper | grace@example.com | New York |
| Alan Turing | alan@example.com | London |
| Grace Hopper | grace@example.com | Arlington |
| Ada Lovelace | ada.l@example.com | London |
Kept 5 of 6 rows.
About this tool
Drop in a CSV file and choose which columns define a duplicate — a full-row match, or just a subset like name and email. See exactly which rows get removed, then download or copy the cleaned result.
How to use CSV Duplicate Row Cleaner
- 1
Drop a CSV file, or paste its contents directly into the text box.
- 2
Turn off any columns that shouldn't count toward a match — for example, a unique row ID.
- 3
Review the duplicate count, then download or copy the cleaned CSV.