Excel guide

Remove Duplicates in Excel Without Losing Data (3 Ways)

Last updated: October 10, 2026 · 3 min read

The same customer twice, the same contact in two exports. Excel can remove duplicates, but its own command does not show a preview first. Here are three ways to find and remove duplicates in Excel: two remove them, one only marks them. Start with Fix 1.

Fix 1

Review duplicates before you delete with the free tool

  1. Open the Find and Remove Duplicates tool.
  2. Choose your Excel file.
  3. Pick the columns that count, for example Name and Email.
  4. Check each group of duplicates. Change the ticks if you like.
  5. Confirm and save the cleaned copy.

Nothing is removed until you confirm. The tool ignores upper and lower case and extra spaces, so BRIGHTLINE DENTAL and Brightline Dental count as the same. Your original file stays as it is.

Fix 2

Remove duplicates with the Excel command

  1. Make a copy of your file first. Removed rows are gone for good.
  2. Click any cell in your table.
  3. Go to Data, Remove Duplicates.
  4. Tick the columns that Excel should compare.
  5. Click OK.

Two rows are duplicates only when all ticked columns match.

Fix 3

Highlight duplicates in Excel before you remove them

  1. Select the cells you want to check.
  2. Go to Home, Conditional Formatting, Highlight Cells Rules, Duplicate Values.
  3. Click OK.

The duplicates get a color. Nothing is deleted. Look at them first, then decide.

Why Excel does not find duplicates that look the same

A space at the end, a space copied from a website or a different spelling is enough. For Excel, "Brightline Dental" and "Brightline Dental " are two different entries. Clean the hidden spaces first. Use the Clean Whitespace tool to remove them. See also our guide on VLOOKUP #N/A.

This is where the Find and Remove Duplicates tool differs from the Excel command: it ignores upper and lower case and extra spaces when it compares. The Excel command does not.

Choose the columns with care. Name and Email together is a safe choice. Email alone is risky, because a shared inbox like info@ can belong to different contacts.

Remove duplicates in Excel: before and after

RowCompanyEmailResult
2Brightline Dentalinfo@brightline.comkept
9BRIGHTLINE DENTALinfo@brightline.comremoved
4Harbor Logisticsops@harbor.comkept

Matched on Company and Email.

Find and remove duplicates with a preview

The Find and Remove Duplicates tool runs on your own computer. Your file is never uploaded.

Questions about duplicates in Excel

Does Excel remove duplicates for good?

Yes. Rows removed with the Remove Duplicates command are gone, so copy your file first.

How do I find duplicates without deleting them?

Use Conditional Formatting, Highlight Cells Rules, Duplicate Values. The duplicates get a color and nothing is deleted.

Why does Excel not find my duplicates?

Hidden spaces or different spelling. Clean the spaces first with the Clean Whitespace tool, then check again.

Which columns should I compare?

Use the columns that make a row unique, like Name and Email together. Avoid a single column that can repeat for good reasons.

More Excel guides

← All Excel guides