App Icon
Quickly remove duplicate rows, unique rows and other types of data. Giving you results you can trust.
Works with:
159,377
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
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:
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Duplicates
June 21, 2018
It's not bullet proof! I put together a spreadsheet and had 100 x 10 digit numbers( phone numbers) and i had it search for duplicates. Out of the 100 it found 1 duplicate. I counted 3 to be exact. I then added 2 more sets of duplicate numbers and it still only found the same duplicate. I tried all different sorts of configurations and it still failed. For each duplicate number I get charged $50 so you can see that i can't afford errors. You might as well take the time to proof you spreadsheets, can't count on this software. I so so wanted this to work for me. I'm so glad i didn't pay for this. Maybe it works for numbers without the dash i didn't try that. However it did find that one duplicate so I give up. 2 stars cause it was free.
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
Profile Picture
A User of Remove Duplicates
April 30, 2018
Great addon. The custom column search was a life saver!
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
February 26, 2019
Saved my bacon this last week. Good stuff!
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Duplicates
June 22, 2018
I had a sheet containing over 5000 rows and needed to search for all rows containing a certain word. This add-on made it so easy.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Duplicates
August 23, 2018
it does not work at removing duplicates. it does not remove duplicates.
Is this review helpful?
Yes
No
Profile Picture
A User of Remove Duplicates
September 21, 2018
Been using this for the last few weeks, working on some large sheets. Great add-on and worth the price.
Is this review helpful?
Yes
No
1-10 of 48
Search
Clear search
Close search
Google apps
Main menu