CSV Duplicate Remover
Remove repeated rows from CSV, comparing whole rows or only the columns you choose, with or without matching case.
Processed on your device. Files are not uploaded
How to remove duplicate rows from CSV
Paste your CSV
Paste or type it into the box, or press Try an example.
Choose what counts as a duplicate
Compare whole rows, or only the columns you list.
Copy or download
Save the cleaned CSV.
Worked example
This is what CSV Duplicate Remover gives for its own sample values. Open the tool above and change anything to try your own.
CSV
name,team,city,age Ada,Platform,London,36 Linus,Kernel,Helsinki,54 Grace,Compilers,New York,85 Ada,Platform,London,36 Alan,Research,London,41
- Delimiter
- Detect automatically
- Compare only these columns (optional)
- Treat upper and lower case as different
- Yes
CSV without duplicates
name,team,city,age Ada,Platform,London,36 Linus,Kernel,Helsinki,54 Grace,Compilers,New York,85 Alan,Research,London,41
About CSV Duplicate Remover
Remove repeated rows from CSV and keep the first of each. Compare entire rows, or only chosen columns such as email, and decide whether upper and lower case count as different.
FAQs
Which copy is kept?
The first one.
Can I match on one column only?
Yes. List the column names or numbers.
Can I do the same for plain lists?
Use Duplicate Line Remover.