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.
Dedupe rows quickly.

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

Select the range you want to process and go to Extensions > Remove Duplicates > Quick dedupe:
Run the add-on from the Google Sheets menu.

Tip. If you don't select your table before running the add-on, it will automatically pick up the used range — cells with data till the first blank row & column.
Tip. You can also spot Quick Dedupe in the Dedupe & Compare group in Power Tools. Just click the icon with a blue lightning:
Quick Dedupe in Power Tools.

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 lines with dupes inside your table by choosing Delete rows within selection.
    • Delete entire rows on the sheet will completely remove cells outside of the selected table as well (assuming it's a row with duplicates, of course).
    • 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.

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

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