Find and remove duplicates in Excel

Duplicate Remover for Excel 2010, 2013, 2007, 2003

Duplicate Remover tool lets you remove duplicates from your Microsoft Excel 2013, 2010, 2007, and 2003 worksheets alike. Besides, it lets you find unique entries in your tables in a breeze.

Instant search to remove duplicates in 1 Excel table
Use the add-in to find all Excel duplicates in 2 spreadsheets with different number of columns
Choose one or several columns for comparison
Delete all duplicated rows; select and color found entries; copy or move dupes to another location

Removing duplicates in Microsoft Excel 2013 - 2003

Complete support for:

Dedupe your worksheets in no time

Removing all duplicate entries in Excel manually may be a real headache when you have large worksheets containing thousands of rows, and you can never be certain that you've eliminated them all. The Duplicate Remover add-in does the job promptly, quietly and perfectly - you can be 100% sure that no duplicates are left unnoticed in your spreadsheets. Remove duplicates in Excel simply by choosing the mode of the wizard that suits you.

Quick Remover: find duplicates in one Excel sheet

Remove duplicates in 1 Excel sheet: Quick Remover

This is the option you use when you have just 1 list to search for duplicates. All is done on one screen and literally in a few seconds: you simply select the needed columns, choose what you want to do with the found entries and click Run. That's it - highlighting or deleting duplicates in Excel is easy!

For more details, please see
How to find duplicates in Excel worksheet.

Remove duplicates in 2 Excel worsheets

Compare Excel worksheets & delete duplicates

You use the Advanced Wizard when you need to compare 2 lists, which can be located either in one worksheet or in two different workbooks. You can also use the Advanced Wizard on one list instead of the Quick Remover if you like it better :) A smart wizard walks you through the process, and here you are - duplicates / uniques are deleted, highlighted, colored or moved, or whatever you choose.

For more information, please see
How to remove duplicates from two Excel worksheets.

Find exactly the data you need

With Duplicate Remover you can easily choose the right type of data to dedupe a particular Excel list. The add-in lets you find and delete:

Duplicated values only
Duplicates with their first occurrences
All unique records
Uniques and first occurrences of dupes

After duplicates or unique data are found you can

Delete duplicate rows
Select the found rows
Color found items
Add a status column that marks rows as "duplicate" or "unique"
Copy or move found rows to another location: a new Microsoft Excel workbook, new / existing worksheet

What you can do with Excel Duplicate Remover

Remove duplicates in Excel worksheet or find uniques in 1 table
Find duplicate and unique entries in 2 tables by comparing matching columns
Process lists with up to one million rows (in Microsoft Excel 2013, 2010, and 2007)
Search in 2 lists with different number of columns
Choose columns to be checked for duplicates

Find more details

What customers say about Duplicate Remover
Video: see how to remove duplicates in Excel using this add-in

$ 29.95

Buy now

See how to remove duplicates in Excel using this add-in

You can view the video in the fullscreen mode by clicking

Your software really helps make my job easier

Your software really helps make my job easier. I don't know what I would do without Duplicate Remover, I use it several times a day for every project I work on. Thanks for making my life easier. Jeannie C.

It is like having an expert at my shoulder helping me...

I really feel that Ablebits has people like me in mind with your software development. It is like having an expert at my shoulder helping me work more effectively and efficiently. Now I have more time to goof off at work — none the wiser. Uh, that last statement is not really true — I will just have a lot less stress because things will go so much smoother. Linda Shakespeare

Your program saved me so much time and headaches,
I cannot tell you!

Your Duplicate remover program for Excel has saved me so much time and headaches, I cannot tell you! I love it! It literally just saved me days of grueling & painstaking deletion of dupes and that was for just one project..

I can only imagine what it will save me in the long run. Oh, and thank you as well for the ability to install this on up to 3 computers with one activation, I can now enjoy the same capabilities whether I am working from home or the office. Thanks Hunter Fitzgerald

This little ditty saved me hours!

I put it to use immediately and it is AWESOME! This little ditty saved me hours comparing the 2 worksheets that both had over 2,000 lines. I was able to find any that didn't match in about 2 seconds! Sue Covington

Thanks for a terrific product that is worth every single cent!

I just have to tell you that the Duplicate Remover is the best tool I could ever have. I spend all day in Excel and Access and this tool has increased my efficiency 100% - ok well maybe 50%. But I honestly do not know how anyone who has to constantly run pivots, graphs, data exports yadda yadda yadda all day could ever go back to living without this tool once they have used it. Thanks for a terrific product that is worth every single cent! Dianne Young

The best software plug-in I have ever used

Duplicate Remover for Excel is the best software plug-in I have ever used. It has saved me days of work, quicker and easier than using the Count IF function. I will recommend this product to my clients without reservation. Your staff are a talented bunch and very helpful. Liza Vela, www.pluvi.com

Duplicate Remover for Excel screenshots

Compare two Excel worksheets to find duplicated data

Remove duplicates in 2 tables with Excel Duplicate Remover

Choose the type of data you're looking for

Select common columns that will be compared

Remove duplicates from Excel 2010, 2013, and other versions: choose to delete, move, color or highlight them

Remove duplicates of find unique records in Excel table

Use the wizard for advanced search in one Excel table

Find duplicates, uniques, first dupe occurrences etc.

Select common columns that will be compared for duplicates

Select, color, copy, mover, or delete duplicate values

Duplicate Remover for Excel system requirements:

Operating System

Windows 8 (32- and 64-bit)
Windows 7 (32- and 64-bit)
Windows Vista (32- and 64-bit)
Windows XP (32-bit)
Windows Server 2003, 2008, 2012
.NET Framework 2.0 must be installed.

If you need to install the add-in for a group of users, please see Corporate deployment.

Microsoft Excel

Microsoft Excel 2013 (32- and 64-bit)
Microsoft Excel 2010 (32- and 64-bit)
Microsoft Excel 2007
Microsoft Excel 2003

Duplicate Remover version

Current add-in version: 3.0.4
published on: Feb 27, 2013

This add-in comes as part of Ultimate Suite (20+ useful Excel tools)

Try Duplicate Remover for Excel in the package without any limitations for 30 days.
You can order the add-in separately or buy it in the Suite at the best price.

Free Download

Free 30-day trial version, 32.56 MB