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

  1. Paste your CSV

    Paste or type it into the box, or press Try an example.

  2. Choose what counts as a duplicate

    Compare whole rows, or only the columns you list.

  3. 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.

Related tools