How to Remove Duplicates in Google Sheets | Scribe
This guide was created with Scribe in 15 seconds. Sign in and create your own!
How to Remove Duplicates in Google Sheets
0 step |
15 seconds
Google Sheets
Tip! When you work with large amounts of data in a spreadsheet, you're bound to have duplicate records.
Google Sheets makes it very easy to eliminate redundant data immediately without manually reviewing it first.
Log in to your Google account and navigate to [https://docs.google.com/spreadsheets/](https://docs.google.com/spreadsheets/d/11yQjHlR4yOj2gag5r98eh2RO4n2HyQOptMRENdhhltU/edit?gid=0#gid=0)
Click any cell that contains data.
Zoom Saved
Click on the ”Data" tab in the menu bar.
Zoom Saved
Hover over or click on “Data cleanup”
Zoom Saved
Click on “Remove duplicates"
Zoom Saved
A “Remove duplicates” window will appear. Select which columns you'd like to include in your search for duplicate data.
Click "Data has header row" if your spreadsheet includes a header row so Google Sheets ignores this row when removing duplicates.
Zoom Saved
After selecting which columns you'd like to include in your search for duplicate data, click "Remove duplicates".
Zoom Saved
The “Remove duplicates” window will show the number of duplicate values found and removed, as well as the unique values remaining.
Zoom Saved
Documents you might like
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe
Have something to say?Create an account to leave messages for the author to see!
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key