How to Remove Duplicates in Excel Based on One Column
Remove duplicate rows when only one field should be unique—such as email, phone number, or order ID.
When to deduplicate by one column
Use a single-column key when one field must be unique across the sheet—customer email, employee ID, or product SKU.
Excel: Data → Remove Duplicates on one column
Select your table, open Data → Remove Duplicates, check only the target column, and click OK. There is no preview step.
Preview-based online dedup by column
Upload your file, select one key column, click Preview to see duplicate groups, then download.
Common mistakes
Verify trailing spaces are not causing missed duplicates. Always backup before deleting in Excel.
Tips
- Sort by date first if you need keep-first vs keep-last behavior
- Use mark-duplicates mode to audit before permanent deletion
- Export unique values only when you need a distinct list of IDs
- Combine with Excel to SQL after dedup to avoid duplicate key errors on import
Excel Duplicate Removal FAQ
Does removing duplicates by one column delete the whole row?
Yes. The selected column defines the duplicate key, but the whole matching row is removed or kept depending on keep-first or keep-last.
Which columns should I select for email deduplication?
If email is the unique identifier, select only the email column. Trim spaces and ignore case to catch hidden duplicates.
Should I backup before deduplicating one column?
Yes. Use preview or mark-duplicates mode first, then export the final result after checking rows to remove.