How to Remove Duplicates in Google Sheets
Duplicate data can cause errors in your analysis. Google Sheets provides built-in tools and formulas to help you clean duplicate entries.
Select Your Data Range
Highlight the range or column that contains duplicates.
Use Data Cleanup
Go to Data > Data cleanup > Remove duplicates. Google Sheets will show you how many duplicates were found and removed.
💡 Always check "Data has header row" if your selection includes headers.
Remove Duplicates Based on Multiple Columns
In the Remove duplicates dialog, check specific columns to define what counts as a duplicate. Rows must match in all checked columns to be removed.
Use UNIQUE Formula
Use =UNIQUE(A1:C100) to create a new range with duplicates removed. This is a non-destructive way to see unique values without deleting original data.
Try These Templates
Frequently Asked Questions
Can I undo removing duplicates?
Yes. Immediately after removing duplicates, use Ctrl+Z (Cmd+Z) to undo.
What is the difference between Remove duplicates and UNIQUE?
Remove duplicates deletes rows from your data. UNIQUE creates a new range without altering your original data.