Find and remove duplicates in Excel

Duplicate Remover for Excel 2016, 2013-2007

Duplicate Remover tool lets you remove duplicates from your Microsoft Excel 2016, 2013, 2010, and 2007 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 the found entries; copy or move dupes to another location

Free download for:

Removing duplicates in Microsoft Excel 2016 - 2007

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 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.

Dedupe Table: 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 Compare Two Tables tool when you need to compare 2 lists, which can be located either in one worksheet or in two different workbooks. 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 Select duplicates with the original value
  • All unique records Find uniques
  • 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 2016, 2013, 2010, and 2007)
  • Search in 2 lists with different number of columns
  • Choose columns to be checked for duplicates

Find more details

Buy now

Compare 2 Excel worksheets and delete duplicates

How to remove duplicates in a single Excel worksheet

I absolutely LOVE your program.

I absolutely LOVE your program. I use Duplicate Remover and Trim Spaces on an hourly basis. I export reports from a software program we use and AbleBits has taken the frustration out of cleaning up the mess that they give me. I recommended you to our IT Company to let their clients know about it and if I find out someone uses Excel I tell them that your program is a definite "must have". Thank you so much, you have shaved countless hours off of my workload. 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

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

Great software!

Great software! It's making my life so much easier already! David Crawford

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,

Duplicate Remover for Excel screenshots

Compare two Excel worksheets to find duplicated data

Remove duplicates or find unique records in Excel table

Free Download
7-day fully functional version

Duplicate Remover for Excel system requirements:

Microsoft Excel

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

Operating System

  • Windows 10 (32- and 64-bit)
  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Server 2008, 2012, 2016
  • .NET Framework 4.0 must be installed.

If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment

Duplicate Remover version

Current add-in version: 2018.2
published on: Nov 17, 2017

End-User License Agreement (EULA).

Featured customers featured customers
Contact us
  Publish your message on our support forum

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard
Excel add-ins and Outlook tools -