Help & Support
Send Feedback
Remove Duplicates
Quickly remove duplicate rows, unique rows and other types of data. Giving you results you can trust.
25,243 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/
Please visit the Chrome Web Store if you would like to reply or rate a review for this app.
Reviews
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
A User of Remove Duplicates
December 3, 2018
My line of work requires working with clients from differing industries, which means the data can come in many formats. With how well your addon has tackled some of our more complex datasets, we've saved a lot of time. Happy customer.
Submit reply
Cancel
A User of Remove Duplicates
November 2, 2018
Great. Keyword search was very useful.
Submit reply
Cancel
A User of Remove Duplicates
September 24, 2018
premium product
Submit reply
Cancel
1-10 of 19
Additional information
Search
Clear search
Close search
Google apps
Main menu