How To Check For Duplicates In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to check for duplicates in Google Sheets

How To Check For Duplicates In Google Sheets

When you’re working with data in Google Sheets, you may find that you have duplicates in your sheet. This can be a problem if you’re trying to keep your data clean and organized.

Google Sheets has a built-in feature that can help you find and remove duplicates. This feature is called “Cleanup suggestions”, and it can be found in the “Data” menu.

In this guide, we will show you how to use the Cleanup suggestions feature to find and remove duplicates in Google Sheets.

How To Find Duplicates In a Google Sheets Spreadsheet

Here’s how to find duplicates in a Google Sheets Spreadsheet.

Step 1

First, select the range you want to remove duplicates from.

Step 2

In the Data menu, select Data cleanup > Remove duplicates.

Step 3

Google Sheets will ask which columns to analyze to identify duplicates. Once you’ve selected which columns to analyze, click on Remove duplicates to proceed.

You should also ensure that the Data has header row option is checked if it is applicable. It will also make it easier to determine which column corresponds to what variable.

Step 4

Google Sheets will indicate how many duplicate rows were found and deleted.

Step 5

If you do not wish to remove duplicates right away, you can use the Cleanup suggestions option instead.

Step 6

The Cleanup suggestions option will open up a panel on the right side of the window. Users can see which values are shown to be duplicates.

This tool gives users the option to remove all duplicates at once or to selectively remove duplicates one at a time.


This guide should be everything you need to check for duplicates in Google Sheets

You may make a copy of this example spreadsheet to test it out on your own.