Remove duplicate rows
Find and remove repeated rows in a CSV, by all columns or by the ones you choose
How to use it
- Paste your CSV or open a file.
- Leave the columns empty to compare whole rows, or name the columns that make a row a duplicate.
- Copy the result or download it.
Questions
How are duplicates found?
Two rows are duplicates when every compared cell is equal. By default all columns are compared. Name one column (for example email) to treat rows with the same email as duplicates, whatever else they hold.
Which copy is kept?
The first one by default. Choose The last copy to keep the later row instead. The rows stay in their original order either way.
Can I see what was removed?
Yes. Set Show to Only the rows that were removed.
Is the header row ever removed?
No. With the first-row option on, the header is kept as it is and never compared with the data.
Is my data uploaded anywhere?
No. The conversion runs in your browser. Your text is not sent to a server.
Is my text sent to a server?
No. Everything happens in your browser. Your text is not uploaded or stored.
Is it free?
Yes, you can use it for free. A subscription removes limits and unlocks premium tools.