Help & Support
Send Feedback
Remove Duplicates
Quickly remove duplicate rows, unique rows and other types of data. Giving you results you can trust.
36,646 users
Works with
Install
Overview
The #1 trusted Remove Duplicates add-on for Google Sheets™. Used by universities, charities and corporations worldwide, including the likes of Google and Lyft. Our add-on takes the pain and difficulty out of searching for duplicate, unique and other types of data. Providing you with results, you can trust.

Privacy and the integrity of your data is something we take seriously at EXPAND9. So be safe in the knowledge that no information ever leaves the spreadsheet and the results you're left with are correct. 

Install the Remove Duplicates add-on and join 1000s of other companies and make what was once a chore, fun!

Features 
--------------

► Correct: Results you can trust.
► Secure: No information ever leaves the spreadsheet.
► Simplicity: Search for duplicate rows, unique rows and empty rows.
► Powerful: Search for keywords or regular expressions.
► Flexible: Highlight, remove, append, copy or move results.
► Optimised: Easily handle spreadsheets containing 10,000+ rows.
► Quality: Designed and developed by a company who are passionate about making great products.

Cool things you can do
-------------------------------------

► Remove duplicate rows containing emails or names
► Use Regular expressions (regex) to find pretty much anything
► Remove duplicate rows containing phone numbers of any format
► Create a backup of the sheet before removing any duplicate rows
► Append matches to an existing sheet
► Remove duplicate rows containing order numbers
► Search for a keyword and highlight any matching rows
► Highlight duplicate rows in colour of your choice

We love hearing from you
-----------------------------------------

We at EXPAND9 hope you enjoy using our Remove Duplicates add-on and if you would like to spread the word, don't forget to leave a review!  ♥

Pro version
-------------------

New users will automatically have access to a 14 day trial of the Pro version of the add-on. After the trial, you can purchase a one-off license of the Remove Duplicate add-on at https://expand9.com/remove-duplicates#purchase

Terms of Use
---------------------

By installing the Remove Duplicates add-on, you are agreeing  to our Privacy Policy found at https://expand9.com/privacy/ and the Terms and Conditions found at https://expand9.com/terms/
Reviews
A User of Remove Duplicates
January 20, 2020
cant get it work - just keeps loading
Submit reply
Cancel
A User of Remove Duplicates
January 5, 2020
Excellent! Fast and accurate. Happy user.
Submit reply
Cancel
A User of Remove Duplicates
December 26, 2019
Excellent plugin, 1) I downloaded it 2) I performed full operations in a really short time 3) I proudly purchased it. Good job. Very good price for lifetime service. (Not like your competitors ..) Thank you very much
Submit reply
Cancel
A User of Remove Duplicates
September 16, 2019
Great addon!
Submit reply
Cancel
A User of Remove Duplicates
May 20, 2019
A bunch of use this daily at our office and it's been flawless. Excellent.
Submit reply
Cancel
A User of Remove Duplicates
March 26, 2019
Long time paid user who has always been impressed with the speed and service offered. The add-on itself is very useful for my day job, I would like to see the option to compare columns but other than that, great.
Submit reply
Cancel
A User of Remove Duplicates
March 14, 2019
Easy to use. Perfect so far!
Submit reply
Cancel
A User of Remove Duplicates
February 26, 2019
Saved my bacon this last week. Good stuff!
Submit reply
Cancel
A User of Remove Duplicates
January 6, 2019
Just want to leave a message to thank you to the guys at EXPAND9. They helped me utilise the add on for a complex use case and I was blown away by the support offered. Again, thank you.
Submit reply
Cancel
A User of Remove Duplicates
December 21, 2018
I work with a tremendous amount of complex data, spreadsheets containing 40k plus on avg. Great add-on guys, makes my work go much smoother.
Submit reply
Cancel
1-10 of 22
Additional information
Search
Clear search
Close search
Google apps
Main menu