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.
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
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
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
- 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 2016, 2013, 2010, and 2007)
- Search in 2 lists with different number of columns
- Choose columns to be checked for duplicates
Find more details
Compare two 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! 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, 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
Duplicate Remover for Excel system requirements:
- 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
- Microsoft Excel 2003
- Windows 10 (32- and 64-bit)
- 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 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: 4.1
published on: May 19, 2016
End-User License Agreement (EULA).