Removing duplicates in Google Sheets - Step-by-Step Guide

Introduction

Removing duplicates helps you clean your data by deleting repeated rows. This makes your list easier to read and analyze without extra copies of the same information.

When you have a contact list with repeated email addresses and want only unique contacts.

When you import data from another source and want to remove repeated entries before analysis.

When you track sales and want to count each customer only once.

When you prepare a list for mailing and want to avoid sending duplicates.

When you want to clean survey responses that may have been submitted multiple times.

Steps

Step 1: Select

- the range of cells containing your data

The cells you want to check for duplicates are highlighted

Step 2: Click

- Data menu at the top

A dropdown menu appears with data options

Step 3: Select

- Data cleanup > Remove duplicates

A dialog box opens to configure duplicate removal

Step 4: Check or uncheck

- Columns to analyze in the dialog box

You choose which columns to consider when finding duplicates

💡 Select all columns to remove rows that are exactly the same

Step 5: Click

- Remove duplicates button in the dialog

Duplicates are removed and a message shows how many rows were deleted

Before vs After

Before

A list with 10 rows where 3 rows have the same name and email repeated

After

The list shows 7 rows with all duplicates removed, only unique rows remain

Settings Reference

Columns to analyze

📍 Remove duplicates dialog box

Decides which columns must match to consider rows duplicates

Default: All columns selected

Remove duplicates button

📍 Remove duplicates dialog box

Starts the process of deleting duplicate rows

Default: N/A

Common Mistakes

Not selecting the full data range before removing duplicates

Duplicates outside the selected range will not be removed, leaving repeated data

Always select the entire data range you want to clean before using Remove duplicates

Not selecting all relevant columns in the dialog

Rows may be considered unique if only some columns are checked, leaving partial duplicates

Select all columns that define a duplicate row to ensure full duplicates are removed

Summary

Removing duplicates deletes repeated rows to keep only unique data.

Use the Data > Data cleanup > Remove duplicates menu to start.

Select the full data range and all relevant columns to avoid missing duplicates.