Help & Support
Send Feedback
Remove Duplicates
Quickly remove duplicate rows, unique rows and other types of data. Giving you results you can trust.
38,194 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
February 26, 2020
The ability to search rows by keyword has been a life saver this last week! Thanks!
Submit reply
Cancel
A User of Remove Duplicates
February 24, 2020
Great add-on!
Submit reply
Cancel
A User of Remove Duplicates
February 22, 2020
Cannot make it work
Submit reply
Cancel
A User of Remove Duplicates
February 10, 2020
Been using this for the last few weeks and it's been nothing short of first class. The support from the developers has been fast and helpful also.
Submit reply
Cancel
A User of Remove Duplicates
January 28, 2020
Simple and easy to use. Thanks!
Submit reply
Cancel
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
1-10 of 27
Additional information
Search
Clear search
Close search
Google apps
Main menu