Remove Duplicates Excel

Excel duplicate removal guide

How to Remove Duplicates in Excel

The safest workflow is to find duplicates first, copy or save the original data, then remove rows only after you understand which columns define a duplicate.

Use Excel Remove Duplicates

  1. Make a backup copy of the range, sheet, or workbook before deleting rows.
  2. Select a cell in the range or Excel table that contains the duplicate rows.
  3. Open the Data tab and choose Remove Duplicates.
  4. Confirm whether the first row contains headers.
  5. Select the columns that should define a duplicate. Excel removes the entire row when the selected columns match.
  6. Review the count Excel reports after removal, then save the cleaned copy only if the result is expected.

Microsoft documents that Remove Duplicates keeps the first matching row and deletes later matching rows. It also recommends checking or copying data before removal because deletion is permanent unless you undo before saving.

Find Duplicates Before Deleting

Conditional Formatting is useful when you want to highlight duplicate values first. It is a review step, not the same as row-level deletion across selected columns. Use it when a visible check is safer than immediate removal.

Filter Unique Values Instead

Advanced Filter can show or copy unique records without deleting the original list. Use it when the source data should remain unchanged and you only need a unique output range.

Use UNIQUE or Power Query

The UNIQUE function is helpful in Microsoft 365 and recent Excel versions when you want a dynamic unique list. Power Query is better when the same cleanup should be repeatable on refreshed data. In Power Query, you can select columns and remove or keep duplicate rows as part of the query steps.

How This Browser Tool Differs

The tool on this site creates a cleaned copy instead of editing the original workbook. It lets you preview duplicate groups, choose keep first, keep last, or remove all rows in duplicate groups, and export after verifying the generated file can be parsed again.

Common Edge Cases

  • Different date formats can compare differently if their displayed text is different.
  • Spaces matter unless a trim option is enabled.
  • Case matters unless a case-insensitive option is enabled.
  • Blank cells can be part of a duplicate key.
  • Duplicate header names should be disambiguated before selecting columns.
  • Password-protected or damaged workbooks need to be repaired or unlocked before browser tools can process them.

Sources