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

Complete support for:

Removing duplicates in Microsoft Excel 2013 - 2003

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 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 2013, 2010, and 2007)
  • Search in 2 lists with different number of columns
  • Choose columns to be checked for duplicates

Find more details

29.95
Buy now

How to remove duplicates in a single Excel worksheet

You can view the video in the fullscreen mode by clicking fullscreen icon

Compare two Excel worksheets and delete duplicates

You can view the video in the fullscreen mode by clicking fullscreen icon

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

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 or find unique records in Excel table



Free Download
Free 15-day trial version, 6/18/2014

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, or on a Terminal Server (servers farm) 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.4.2
published on: Jun 18, 2014

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
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
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
Awesome!!!
Sheila Blanchard