Remove duplicates in Google Sheets

Remove Duplicates offers 6 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. You can also automate the process by saving the settings into scenarios and scheduling their autostart a couple times a day.

In case you need to compare two or more ranges for duplicates, Compare sheets for duplicates is a tool to go. It compares multiple tables against the main one and marks replicated or different data in the selected datasets.

There's also Compare two columns to check two columns within one Google sheets for duplicate or unique values.

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:

1. works automatically if you save the settings and schedule autostart
2. finds not only dupes but also uniques and their 1st occurrences
3. processes not only rows but also single cells
4. compares two and more sheets or columns for the same values even from different files
5. highlights duplicates or uniques, marks them in a status column, copies or moves them to a specified place, clears cells, or deletes entire rows.

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 Exntensions menu directly and do the following:

1. Select the range with your data.
2. Choose what to find:
   • Duplicates only
   • Duplicates + 1st occurrences
   • Uniques
   • Uniques + 1st occurrences
3. Select key columns to search in.
4. Decide what to do with the found records.
5. Click Finish.

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 sheets for duplicates under the Extensions menu and follow these steps:

1. Select the sheets.
2. Pick the main one among them.
3. Choose what to find:
   • Duplicates
   • Uniques
4. Select the columns to compare.
5. Decide what to do with the found values.
6. Click Finish.

See a more detailed description here.

The add-on compares your main sheet against all other selected sheets. And vice versa: each selected sheet against the main one. The found values will show the relation between your main sheet and every other compared sheet.

Run Remove duplicate cells from the Extensions menu and do the following:

1. Choose the type of cells to find:
   • Duplicates
   • Duplicates + 1st occurrences
   • Uniques only
   • Uniques + 1st occurrences
2. Decide what to do with the found cells.
3. Click Finish.

See a more detailed description here.

Run Combine rows from the Remove Duplicates add-on and follow these steps:

1. Select the data range.
2. Identify columns with duplicate records.
3. Choose the columns to combine and either:
   • Merge values using delimiters.
   • Or calculate numbers with the help of some functions.
4. Click Finish.

See a more detailed description here.

1. Open the add-on.
2. Select the range containing the columns of interest.
3. Set one column as the main one, and another as a compared one.
4. Choose the values to find: duplicate or unique.
5. Decide what to do with the results.
6. Click Compare.

For all the details, visit this tutorial.