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.

Learn more
This tool is part of
Ultimate Suite
Duplicate Remover for Excel 2016 - 2007

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
Video: how to remove duplicates in Excel
Select the table to search for duplicates
Choose to find duplicate values
Select the key columns
Choose the action
Get all the duplicates highlighted

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license
for 2 computers
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

About Duplicate Remover for Excel

Supported versions

 

Excel

  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • Windows Vista
  • Windows XP
  • 32-bit and 64-bit
Free download
14-day trial version
  • Included in Ultimate Suite for Excel
  • 14-day fully-functional version

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.
Excel add-ins and Outlook tools - Ablebits.com