Find dupes in one sheet or compare two tables
This add-on comes with 5 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 two columns or sheets; and the 5th 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.
Try it for 30 days for freeRemove Duplicates offers 5 easy ways to deal with replicated data in your Google Sheets.
To look for all instances of values or check for unique records on one spreadsheet, use the Find duplicate or unique cells tool. Based on the settings you select, it will highlight duplicates, copy or move them, or free cells from the values completely.
Find duplicate or unique rows as well as its one-step alternative Quick dedupe are perfect for identifying duplicate rows rather than single cells. Simply tick off key columns that should be scanned for uniques or dupes, and let the add-ons do the rest.
In case you need to check two ranges for duplicates, Compare columns or sheets is a tool to go. It compares your first table or column with another similar one and marks replicated or different data in the first dataset.
Combine duplicate rows will help whenever you need to merge or add up records from duplicate rows rather than delete them. It equips you with a set of functions to calculate numbers and with a few delimiters to bring values together instead. There's an option to use your own custom separators.
Compared to our add-on, the Remove duplicates tool embedded in Google Sheets offers significantly reduced functionality. Yes, it includes or ignores your header row and analyzes all or some columns of your table. But all it does with your data is literally — delete duplicate rows.
Our add-on:
To help you even more, we've made the add-on case and blanks sensitive (there are options to manage these) and made sure it backs up your data whenever you need.
Run Remove duplicate rows from the Dedupe & Compare group in Power Tools or from the Exntensions menu directly (if you have a single add-on) and do the following:
See a more detailed description here.
The key columns let the add-on check more than one column at the same time. For example, you have first and last names in different columns. If you choose them both in Find duplicate or unique rows, the tool will scan both columns at once to make sure you find duplicate full names instead of the same first names separate from their last names.
Yes! And what's even better – there are 2 ways!
Scenarios. Save those options that you choose most often to run them later with just a click.
On a schedule. Or go further and schedule the add-on to run those scenarios for you at a certain time. Even when the file is closed or your computer is turned off.
Find Compare two sheets in the Dedupe & Compare group in Power Tools and follow these steps:
See a more detailed description here.
The add-on doesn't show what's the same and what's different in both ranges. It treats the first table (column) as the main one and simply compares it with another. Basically, the tool processes first dataset and makes changes to it compared with the contents of the second range.
Run Remove duplicate cells from the Dedupe & Compare group in Power Tools and do the following:
See a more detailed description here.
Run Combine rows from the Remove Duplicates add-on and follow these steps:
See a more detailed description here.