Remove duplicates in Google Sheets

Remove duplicates in Google Sheets

Find dupes in one sheet or compare two or more tables

This add-on comes with 6 tools for deleting duplicates in Google Sheets.

2 of them will check your Google sheet for duplicate rows; the 3d will find single cells with identical records; the 4th will compare multiple sheets; the 5th will compare two columns on a sheet;

and the 6th will combine duplicate rows.

Go through the settings in each tool manually, or automate the process by saving the desired options into scenarios and even scheduling their daily autostart.

Buy license

Choose your plan

Download

Try it for free

With Remove Duplicates you will

Check your data for dupes, uniques, and 1st occurrences Find duplicates or uniques only, or include their 1st occurrences to the result.
Save the most commonly used options into scenarios Make the add-on process the data in just 1 click based on those saved settings without your going over all steps again.
Compare two and more sheets or columns in Google Sheets Scan as many datasets as you need for differences and matches.
Highlight duplicate & unique results Choose a hue to color what’s been found and see those entries instantly.
Transfer the found values Copy or move records to another sheet, spreadsheet, or a place of your choice.
Search for duplicate and unique entries in one spreadsheet Identify duplicates & uniques in single cells within one spreadsheet.
Schedule autostart Schedule your scenarios to find, highlight & remove duplicates 1-2 times a day even when you are offline.
Combine duplicate rows in Google Sheets Merge data from duplicate rows based on a unique column.
Mark the results in a status column A helper column will come in handy to count, sort or filter data by its status.
Delete duplicates in Google Sheets Decide to clear only repeated cells or delete duplicate rows entirely.