Find duplicates in a Google Sheets table in a single step

Quick Dedupe is a speedy solution to remove duplicate rows in Google Sheets. There's only one step where you choose the columns to check and decide how to deal with repeated entries.

Before you start

We care about your data and suggest you always create backup copies of your spreadsheets. A special option of the add-on will do that for you if you select it.

Please bear in mind that Google Sheets limits the total number of possible cells in your file up to 5 million cells.

How to use Quick Dedupe

Start the add-on

Open your spreadsheet and go to Add-ons > Remove Duplicates > Quick dedupe:
Run the add-on from the Google Sheets menu.

Tweak the settings

The only step of the add-on will ask you to fine-tune the following settings:
Quick Dedupe options.

  1. Based on the first two options, the tool will process or skip certain data:
    • Tick off My table has headers if the range of interest contains header rows. Such lines won't be checked for duplicates, and you will see the title of each column in the tool.
    • To ignore recurring blanks, make sure to check the Skip empty cells option. Or else, matching blank cells will be treated as duplicated data.
  2. Use the checkbox in the header row to select all columns at once and search for complete row duplicates. The 1st row content will hint on the records your columns contain.
  3. Choose the columns you want to scan for duplicated data in your Google Sheets. If you check more than one column, a row will be considered duplicate if the values in all selected columns are the same:
    How key columns work.
  4. Decide how to process the found records:
    Process Google Sheets duplicates in different ways.

    • Highlight duplicates in Google Sheets with a color of your choice.
    • Remove the entire dupe lines by choosing Delete rows within selection.
    • Pick Add a status column to identify rows in a neighbouring column:
      Add a status column.
    • The Clear values option will delete duplicate entries from the selected columns only, keeping other data in the same rows intact.
    • Have the rows with the found duplicates copied to a new sheet of the same file.
    • Or make the add-on move (cut and paste) duplicates to a new sheet while shifting your original data up.

Click Dedupe to quickly check your data for duplicates.

See the result

Once the add-on deduplicates your table, you will see the confirmation message saying how many rows have been found and what action was applied to them:
Quick Dedupe result message.

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.