Quickly remove duplicate rows, unique rows and other types of data. Giving you results you can trust.
Works with:
214K+
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/
Additional information
PricingNot available
Developer
Trader status unspecified
Privacy policy
Terms of service
Remove Duplicates will ask for the permissions shown below. Learn more
Remove Duplicates will need access to your Google account
This will allow Remove Duplicates to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu