Help & Support
Send Feedback
Remove Duplicates
Quickly find duplicates or uniques in one sheet or in two columns. Move, delete, or highlight the results.
1,767 users
Works with
Install
Overview
This add-on comes with two useful wizards. One will show how to delete duplicates in Google Sheets in 4 steps, the other will quickly compare data from two columns for repeated values.

"Find duplicates or uniques" is a quick assistant for Google Sheets: remove duplicates in a column or find duplicate rows or cells. You are free to include the first occurrences or look for unique entries. It lets you choose one of 6 ways you can deal with the results: highlight or remove duplicate lines, copy or move them to another Google Spreadsheet, or clear duplicate entries leaving the cells intact.  Once you run the add-on, it will display a summary for the results found in your sheet.

Use the "Compare columns or sheets" tool to quickly scan two Google Sheets columns for the same values. It will take you five simple steps to compare lists and mark the results with colour or status, copy or move them, clear repeating cells, or remove duplicate rows from your main table. 

The add-on offers case-sensitive search and additional options for handling empty cells and headers. You can use this tool to make your Google Sheets duplicate-free in a flash.

What's new:
Version 1.9
New Features:
 - Scenario. Just save the settings you use most often and give this set a name – this is your scenario. Once you run it, your sheet will be processed right away, and you won't need to go over the same steps again.

Fixed:
 - Remove Duplicate Cells: copy and move results to a new location.

Improved:
 - Minor improvements and text adjustments.

Version 1.8
New Features:
 - Find duplicate cells. You can find and process duplicate or unique cells within the selected range.

Improved:
 - Range selector UX. If you had slow Internet connection or server response, you could get an incorrect range. We've significantly reduced that possibility.
 - UX; the add-on will offer the most possible actions and warn about possible mistakes and lags.
 - Small screens and minor issues UIs.
 - Performance. The new version of the add-on processes colored cells faster.

Fixed:
 - Removing Alternating colors.
 - Corrupting main table formatting.

Version 1.7: We introduced yearly subscriptions, you can still enjoy a fully-functional trial version of the add-on for 30 days.

Version 1.6: We fixed the issues you reported and made the add-on much faster!

Version 1.2: Take advantage of all Pro features for free: mark duplicate values in a separate column, copy or move the found rows to another sheet.

Feel free to try it out on this test spreadsheet:
http://goo.gl/wHBySu

If you have any questions about deleting duplicates in Google Sheets, please post them here: https://www.ablebits.com/docs/howto-find-duplicate-rows/
We'll be happy to assist!
Please visit the Chrome Web Store if you would like to reply or rate a review for this app.
Reviews
January 11, 2019
Good extension - gives you all the options you want with duplicates, uniques. I like the color cell feature. great support - these guys work hard and are very responsive. I'd like to see a keyboard shortcut for fast check for duplicates (ie you sometimes just want something quick and dirty to get an idea of your data rather than 4 clicks to perform something basic)
Submit reply
Cancel
January 9, 2019
This tool is absolutely wonderful it saved me hours of exasperation and it worked flawlessly.
Submit reply
Cancel
January 6, 2019
I am using this software since 3 Months and it is helping me out big time in my work. I can only recommend it.
Submit reply
Cancel
December 29, 2018
It is great for me to see such an improvement in Technical service in the world today (I am 65) Ablebits are a fine example
Submit reply
Cancel
December 22, 2018
Probably the most useful add-on for Google Sheets. Does what you need. Excellent product
Submit reply
Cancel
December 20, 2018
I've used this removal tool for over a year now. For the time and energy is saves me instead of writing my own functions (macros) in Google sheets, I'm happy with the functionality. The support is also very good. For those who have the problem with 'HELP' only appearing, remove the Add-on and the google account permissions then install the add-on again. Works like a charm (thanks to Natalia on their Support team for this). Again, this add-on saves me hours of work.
Submit reply
Cancel
December 20, 2018
I have the paid version and I am having the same exact problem dotalocus has. When I select "Remove Duplicates" the only option available is "Help". So I am unable to use the addon. I have closed/reopened the sheet over 10 times, and have tried in both Safari and Chrome.
Submit reply
Cancel
A Google User
December 20, 2018
I have the same problem,only Help option...
December 20, 2018
It is not working. I only see "Help" in the add-on and nothing else. Maybe I need to pay $60 for this add-on to use it? I will rather buy a Microsoft Office suite over paying for this pile of garbage.
Submit reply
Cancel
A Google User
December 24, 2018
omg, excel solved those issues back in 90-es..
December 20, 2018
Remove the Add-on and the google account permissions (https://myaccount.google.com/permissions) then install the add-on again.
A Google User
December 20, 2018
Same Problem... I need the remove duplicates the soon as possible.
December 17, 2018
I have found this really helpful and time-saving.
Submit reply
Cancel
November 18, 2018
I am a paying customer. It's great.
Submit reply
Cancel
1-10 of 103
Additional information
Search
Clear search
Close search
Google apps
Main menu