Remove Duplicate Rows
Paste a table or a list to get the rows without duplicates and a count of what was removed. Free, with nothing uploaded.
Your result
Paste a table or choose a file to see the rows without duplicates here.
How to use it
- Paste the rows or choose a CSV file.
- Say whether the first row holds column names, and pick the columns to compare.
- Choose whether to keep the first or the last row of each repeat.
- Copy the result or download it as a CSV.
Examples
- A list of namesAda, then Sam, then Ada, one per line two rows stay and one is removed
- Compare by one columnAda,0101 then Ada,0103, comparing the first column only Ada,0101 stays
- Keep the last rowthe same two rows with “The last row” only Ada,0103 stays
Tool details and privacy
Paste a table or a list, or choose a CSV file, to get the rows without duplicates. The comparison runs in your browser and the data is not uploaded.
A row counts as a duplicate when all of its columns match. To compare by one column, such as phone or email, untick the other columns.
Options
- Compare by every column or by the columns you pick.
- Keep the first or the last row of each repeated group.
- Ignore upper and lower case.
- Delimiter: automatic, comma, semicolon, tab or pipe.
- A list of the repeated values and how many times each appears.
Limits
- A file up to 1 MB, or text up to 1,000,000 characters, and 5,000 rows.
- Spaces at the start and end of a cell are not counted as a difference.
- Arabic letter forms are not unified: «أحمد» and «احمد» are different values.
- Blank lines are skipped.
Privacy
The rows are compared in your browser. The data is not uploaded or stored by us.
Questions
How do I remove duplicate rows from a CSV file?
Choose the file or paste its text, and the rows appear without duplicates straight away. Then download the new CSV or copy the result.
How do I remove duplicates by one column only?
Leave only that column ticked, such as the phone column, and untick the others.
Which row is kept when rows repeat?
The first, unless you change it. Choose “The last row” when the newest data is at the bottom of the table.
Are “Ali” and “ali” the same row?
No, unless you tick “Ignore upper and lower case”. Extra spaces at the start and end of a cell are always ignored.