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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Parcel Pros
July 20, 2021
It is finding false positive duplicates. Super frustrating. why is it so hard to find duplicates?!?!
Is this review helpful?
Yes
No
Profile Picture
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
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Duplicates
March 31, 2020
We've been using your add-on for the last few weeks and it's helped clear through a ton of data effortlessly.
Is this review helpful?
Yes
No
Profile Picture
Spectrum3900
May 2, 2021
easy to use - worked with my 10k rows easily.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Duplicates
March 27, 2020
Great! I had a large sheet, which I was struggling to clean with another add-on, but yours whizzed through it in no time.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Duplicates
April 8, 2020
We had been struggling to clean the large amount of logs from our app in Excel. We gave this a try and it's been a breeze. Highly recommended.
Is this review helpful?
Yes
No
Profile Picture
Simon Neil
September 22, 2020
We've been using this add-on for the last few days to process a large amount of data with no problems. Great!
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
1-10 of 47
Search
Clear search
Close search
Google apps
Main menu