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.
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.
Select the range you want to process and go to Extensions > Remove Duplicates > Quick dedupe:
The only step of the add-on will ask you to fine-tune the following settings:
Click Dedupe to quickly check your data for duplicates.
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:
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!