Remove duplicates in Google Sheets

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 free
  • Find duplicate or unique rows
  • Schedule add-on autostart
  • Remove dupes or uniques
  • Combine duplicate rows
  • Compare two tables
  • Quick dedupe

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 sheets or columns in Google Sheets Scan two datasets 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.

How to delete duplicates in Google Sheets

Choose to find dupes or uniques only, or their 1st occurrences as well
Choose to find dupes or uniques only, or their 1st occurrences as well
Decide what to do with the found entries
Decide what to do with the found entries
Schedule the add-on to find duplicates at a certain time even when you are offline
Schedule the add-on to find duplicates at a certain time even when you are offline
Keep track of those automatic runs on a special log sheet
Keep track of those automatic runs on a special log sheet

Deal with duplicated data

using 5 handy add-ons

Find duplicate rows in one spreadsheet.
Find duplicate rows in one spreadsheet.
Treat lines as repeated based on matching values in one or more columns.
Treat lines as repeated based on matching values in one or more columns.
Compare two columns or sheets for duplicates.
Compare two columns or sheets for duplicates.
Get ahold of all recurring cells on the sheet.
Get ahold of all recurring cells on the sheet.
Merge values and consolidate numbers from duplicate rows.
Merge values and consolidate numbers from duplicate rows.

License benefits

Our customers get

Unconditional
30-day money-back guarantee
Free support
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Remove Duplicates and what do I need it for?

Remove 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.

Doesn't Google provide a free way to look for duplicates in Google Sheets?

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. knows how to work 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 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.

How to find different rows in Google Sheets?

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:

  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.

What are those "key columns" when looking for identical rows?

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.

Can I make the add-on find duplicates automatically?

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.

How to compare two tables in Google Sheets?

Find Compare two sheets in the Dedupe & Compare group in Power Tools and follow these steps:

  1. Select the main sheet.
  2. Select the second sheet to compare with.
  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.

Why would I select main and lookup tables when comparing two columns or sheets?

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.

How to find duplicate cells in Google Sheets?

Run Remove duplicate cells from the Dedupe & Compare group in Power Tools 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.

How to combine duplicate rows in Google Sheets?

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.

Choose your plan

12-month

  • 12-month access with all updates
$33.60
$19.99
Buy now

Lifetime

  • Get all new features and updates for free ever!
$59.90
Buy now

System requirements

Operating Systems

  • Microsoft: Windows 7 and up
  • Mac: High Sierra 10.13 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)