How to Remove Duplicates in Google Sheets | Scribe
logged out logo

How to Remove Duplicates in Google Sheets

  • 0 step |
  • 15 seconds
  • Google SheetsGoogle 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.
Click on the ”Data" tab in the menu bar.
Hover over or click on “Data cleanup”
Click on “Remove duplicates"
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.
After selecting which columns you'd like to include in your search for duplicate data, click "Remove duplicates".
The “Remove duplicates” window will show the number of duplicate values found and removed, as well as the unique values remaining.
Documents you might like
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe