Remove duplicates
Clean repeated rows out of a list or a table.
Drop an XLSX or CSV, or paste the rows below
or click to choose (.xlsx, .csv). Up to 25 MB per file.
Separate columns with a tab or a semicolon. Pasting straight from a spreadsheet works.
- Runs right in your browser
- Free, no sign-up
More about Remove duplicates
How to clean duplicates out of a list
Paste the rows or drop an XLSX or CSV table in. The tool keeps one of every repeated item and shows you what repeated and how many times. Download the result as XLSX, CSV or plain text.
- Compare by column: a duplicate usually shows up in an email address or a company number, not in the whole row. Pick the column and the rest of the row comes along.
- Case and spaces: ignored by default, so
Jane@example.comandjane@example.comare the same record. - First or last: in exports the latest entry is usually the current one, and the switch takes care of that.
Frequently asked questions
Is the order preserved?
Yes, rows are never shuffled. Only the ones already seen earlier in the list disappear.
How do I paste data from Excel?
Select the cells, copy and paste into the box. Columns are held together by tabs, so they are recognised automatically. Or just drop the file in.
Can it find similar entries, not just identical ones?
No. The comparison is exact, optionally ignoring case and surrounding spaces. Typos like “Smith” and “Smyth” stay as two records.
Is the data sent to a server?
No, reading the file and comparing it both run in your browser.