Remove duplicates in Google Sheets

Find dupes in one sheet or compare two tables

This add-on comes with 3 tools for deleting duplicate records in Google Sheets. One will check your sheet and find duplicate rows; the other will compare data from two columns or tables; the last one will find single cells with identical records. Scan your data for differences or matches and include the first occurrences into the result - the process is as simple and flexible as possible.

Try it for 30 days for free
  • Find duplicate or unique rows
  • Remove dupes or uniques
  • Compare two tables

With Remove Duplicates you will

  • Scan your data for dupes, uniques, and 1st occurrences Find unique values or duplicate records only or include their 1st occurrences to the result.
  • Compare two tables or columns in Google Sheets Scan two datasets for differences and matches.
  • Color the results Choose a hue to highlight what's been found and see the entries instantly.
  • Transfer the found values Copy or move the records to a new sheet, another spreadsheet, or a place of your choice.
  • Search for duplicate and unique entries on one spreadsheet Locate all single cells with the records of interest within one spreadsheet.
  • Find different or unique rows Detect lines with the found values in one or more columns.
  • Mark the results in a status column A helper column will come in handy for sorting or filtering data according to the status.
  • Eliminate redundant records Choose to clear only repeated cells or delete duplicate rows entirely.

How to remove duplicates in Google Sheets

   
Video: Find duplicate rows in Google Sheets
Video: Compare 2 Google spreadsheets for duplicates
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
If you use Remove Duplicate Rows, the row will be considered repeated if all columns you pick contain identical records
If you use Remove Duplicate Rows, the row will be considered repeated if all columns you pick contain identical records
Decide what to do with the found entries
Decide what to do with the found entries
Find and color dupes using any of three add-ons
Find and color dupes using any of three add-ons
For the Compare Columns or Sheets add-on, tick off those columns you want to compare
For the Compare Columns or Sheets add-on, tick off those columns you want to compare
Video: Find duplicate rows in Google Sheets
Video: Compare 2 Google spreadsheets for duplicates
Choose to find dupes or uniques only, or their 1st occurrences as well
If you use Remove Duplicate Rows, the row will be considered repeated if all columns you pick contain identical records
Decide what to do with the found entries
Find and color dupes using any of three add-ons
For the Compare Columns or Sheets add-on, tick off those columns you want to compare

License benefits

Our customers get

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

These companies choose Ablebits products

   

Frequently asked questions

About Remove Duplicates for Google Sheets

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

    Remove Duplicates offers 3 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 fill the results with color, copy or move them, or free cells from the values completely.

    Find duplicate or unique rows is perfect for when it comes to locating duplicate rows rather than single cells. Simply tick off key columns that should be scanned for uniques or dupes, and let the add-on 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.

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

    You can copy unique values from your range using the UNIQUE function in Google Sheets. However, if your task is to make changes to your source data - you will still have to do that manually. Besides, the function won't check for duplicates.

    As an alternative, there's Google App Script. But this may become rather difficult if you're not a power user and haven't worked with Google Script Editor before.

    Our add-on offers formula-free ways to find not only uniques, but also duplicates and their first occurrences. Depending on your task, it will color, move, and delete these values from your spreadsheet, saving you time and mouse clicks.

  • How to find different rows in Google Sheets?

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

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

  • How to find duplicates 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.

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

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

    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.

Choose your plan

12-months

  • 12-month access with all updates
$33.60
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: Yosemite 10.10 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close