How to remove duplicate rows
- Choose an Excel or CSV file and pick the sheet.
- Choose the columns that must match for two rows to count as duplicates. For example, just the email column.
- Optionally ignore upper and lower case and extra spaces.
- Press Remove duplicates, check the result and download it as Excel or CSV.
Which rows are kept
The first time a row appears it is kept, and later copies are removed, so the original order of your data is preserved. The header row is always kept.
Matching on some columns
Two customer rows might have the same email address but different sign-up dates. Untick every column except Email to treat them as duplicates. Tick Ignore upper/lower case and extra spaces so that Sam@Example.com and sam@example.com count as the same.
Frequently asked questions
How do I remove duplicates in Excel?
Choose the file here, pick the columns to compare and press Remove duplicates. Download the cleaned file.
Does it change my original file?
No. A new file is downloaded; the original stays as it was.
Can I remove duplicates from a CSV?
Yes, and you can save the result as CSV again.
Is my spreadsheet uploaded?
No. The file is opened by your own browser and never leaves your device, so it is safe for payroll, customer lists and other confidential data.