Find and delete duplicates in Excel table

Check your worksheet for dupes and unique values

Finding and removing duplicates in Excel may be a real headache, especially when your worksheets contain thousands of rows. Duplicate Remover for Excel does the job quickly and perfectly – it can find and delete duplicates based on one or several key columns, identify unique values, highlight, copy or move the found entries.

Free download Ultimate Suite for:
2019 365 2016 2013 2010
Download this and 60+ other tools for Excel included in Ablebits Ultimate Suite

14-day fully functional version
Duplicate Remover for Excel 2019, 2016 - 2010

With Duplicate Remover for Excel you will

  • Search for duplicates Find absolutely all duplicates in your worksheet, including their first occurrences.
  • Find dupes without 1st occurrences Check your table for duplicate records, excluding their first instances.
  • Dedupe by multiple key columns Check your worksheet for duplicate rows by selecting several key columns.
  • Delete duplicates in Excel Eliminate all duplicate cells or repeated rows in one go.
  • Highlight duplicate and unique values Shade repeated and unique values in any color of your choosing.
  • Check for unique values Use this option to find the entries that appear in your spreadsheet only once.
  • Find uniques + 1st occurrences of dupes Identify all different values in your Excel document to get a list of distinct entries.
  • Identify duplicates in a status column Get a new column with "Unique" or "Duplicate" marks added in each row.
  • Show duplicates by selecting them Have unique or duplicate cells selected in your table.
  • Move or copy dupes and uniques Copy unique entries or move dupes to a new Excel file.

How to remove duplicates in Excel

Video: how to remove duplicates in Excel
Select the table to search for duplicates
Select the table to search for duplicates
Choose to find duplicate values
Choose to find duplicate values
Select the key columns
Select the key columns
Choose the action
Choose the action
Get all the duplicates highlighted
Get all the duplicates highlighted

License benefits

Our customers get

Unconditional 60-days money-back guarantee
Life-time license, no additional
fees ever
Free life-time support
Secure payment guarantee
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Duplicate Remover for Excel?

Duplicate Remover for Excel is designed to find duplicates and unique values in one Excel table. It offers plenty of options to deal with the found entries: delete duplicates, identify dupes and unique values by adding a status column, highlight with any color, select, copy, or move the results to another file or worksheet.

Can't I remove duplicates using Excel's built-in features?

The Remove Duplicates tool is available in Excel 2007, Excel 2010, Excel 2013, and Excel 2016. But it can only delete duplicates, leaving unique values and first occurrences of duplicates in a table, and does nothing else.

Our Duplicate Remover add-in offers a wide range of options. It can search for repeated or unique records with or without 1st occurrences. Apart from removing duplicate values and eliminating repeated rows, it can select and highlight them, add a status column, copy or move.

How to search for duplicates with or without first occurrences?

Click the Duplicate Remover icon on the Ablebits Data tab, and perform the following steps:

  1. Select your table or any single cell within it.
  2. Choose what kind of entries you want to find:
    • Duplicates except their first occurrences.
    • All duplicates including the first instances.
  3. Select one or more columns to check for duplicate values.
  4. Choose the desired action, for example Highlight with color.
  5. Click Finish.

The detailed step-by-step instructions can be found here.

How to check my worksheet for unique and distinct values?

To identify only unique entries or all different items in a list, run Duplicate Remover and select one of these options on the second step:

  • Uniques to find only unique values.
  • Uniques + 1st occurrences to find distinct values, i.e. uniques and first instances of repeated values.

Is it possible to show duplicates in Excel without removing them?

Sure. Don't let the name of the add-in trick you, with Duplicate Remover you can get all the duplicate values automatically selected or highlighted without any actual removals.

What if I want to find dupes or uniques and copy them to another worksheet?

No problem. You can do with the found values whatever you want: select or highlight them, identify in the status column, copy or move to another file or worksheet.

Is there a faster way to deduplicate my Excel tables?

Yes, it is. Our Quick Dedupe tool can find and remove duplicates in an Excel table, list or column with a single mouse click.

Supported versions

Microsoft Excel

  • Excel included in ​Microsoft 365 (formerly Office 365)
  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • 32-bit and 64-bit
  • Note! Office Insider is not supported


  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
  • Note! Windows insider is not supported
  • Note! Surface Pro X and Windows X are not supported

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.