Remove Duplicates for Google Sheets

Quickly find duplicates in your sheet or compare two columns

This add-on comes with two convenient tools for deleting duplicate entries. One will carefully check your sheet and find duplicate rows, the other will compare data from two columns. It will lead you through the process to make it as simple and flexible as possible.

  • Search for duplicate and unique entries
  • Compare data from two columns or sheets
  • Remove duplicate lines from your sheets
  • Highlight the found values with color

Learn how to work with the add-on.

Remove Duplicates add-on will help you find, color, or delete the found rows

How to delete duplicates in Google Sheets

When you get a large table that has a lot of repeating values, there is a solution in Google Sheets: Remove Duplicates add-on. Follow 4 simple steps of the wizard to remove duplicates in a column or find the same rows in your table. Include the first occurrences of the dupes into the search results or look for unique entries, it takes just a click to choose.

You also get six different ways to deal with the results: highlight or remove duplicate rows, copy or move them to another sheet, clear repeated cells or mark them in a status column.

How to compare lists

The task of removing duplicates becomes more complicated when you have two sheets with a few common records. Compare spreadsheet columns using the second 5-step wizard and instantly see if there are duplicate values among them.

Just select the sheets and pick the key columns you want to compare. The add-on will provide you with the summary of the found duplicate entries or uniques and have them moved, deleted, or highlighted in your main Google Sheets table.

Remove Duplicates for Google Sheets: video how-to



Duplicate Remover for Google sheets screenshots

Remove duplicates


Compare columns

 
Contact us
 
  Publish your message on our support forum
 

Our working hours: 0am to 9am PST; 3am to 12am EST; 9am 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
Awesome!!!
Sheila Blanchard
 
 
Excel add-ins and Outlook tools - Ablebits.com