Remove Duplicate Rows
Find and remove duplicate rows in a CSV or a list.
Remove Duplicate Rows finds repeated rows in a CSV or pasted text. Choose which columns decide what counts as a duplicate, whether case and surrounding spaces are ignored, and whether the first or last copy is kept. The duplicates are shown before anything is removed, and none of it leaves your device.
Loading Remove Duplicate Rows…
Runs entirely on your device. No file or text you enter here is uploaded. How to verify it.
How to use Remove Duplicate Rows
- Add a CSV file, or paste the rows in.
- Choose the columns that decide what counts as a duplicate.
- Review the duplicates found, then download the cleaned rows.
Questions about Remove Duplicate Rows
Why choose which columns count?
Because two rows are rarely identical in every column. The same customer might appear twice with different notes or timestamps, and comparing whole rows would find nothing. Comparing only the email column, or the name and postcode together, finds the duplicates that actually matter.
Should I keep the first or the last copy?
Keep the last when the file is in chronological order and later rows carry updated information. Keep the first when the earliest record is the authoritative one, such as a signup date. The tool shows both counts so you can see how many rows the choice affects.
Does it delete anything from my file?
No. It shows you what it found and produces a new, cleaned file in your downloads. Your original is untouched. You can also download just the removed rows, which is worth keeping until you are sure the result is right.
Are “John Smith” and “john smith ” treated as the same?
Only if you tick the options to ignore case and surrounding whitespace, which are off by default. Trailing spaces from a copy-and-paste are the single most common reason a duplicate hides from a spreadsheet’s own deduplication.
Can I use it on a plain list rather than a CSV?
Yes. Paste any list of lines and treat it as a single-column file. That covers the common case of a list of emails or reference numbers that needs deduplicating before it goes anywhere.
Is Remove Duplicate Rows really free, with no limits?
Yes. There is no account, no daily cap, no file-size tier and no watermark, because there is no server cost to recover. The site is funded by clearly disclosed partner recommendations on the Partners page, never by metering the tools.
Are my files or text uploaded when I use Remove Duplicate Rows?
No. Everything is processed by JavaScript running in your browser, on your device. You can verify it: open your browser's developer tools, switch to the Network tab, and use the tool. You will see no request carrying your data — because there is nowhere for it to go.