Duplicate rows are tiny spreadsheet goblins. One minute your list looks tidy, and the next you have the same customer, product, or email address showing up three different times. Luckily, Google Sheets has a built-in spell for cleaning them up.

In this tutorial, you’ll learn how to remove duplicates in Google Sheets without losing your data, plus when to use the UNIQUE formula instead of deleting anything.

Step 1: Make a quick backup first

Before you remove duplicates, make a copy of your sheet. This is especially important if you’re cleaning a customer list, inventory tracker, order export, or anything you can’t easily rebuild.

1. Right-click the sheet tab at the bottom.
2. Choose Duplicate.
3. Rename the copied tab something like Backup before duplicate cleanup.

That gives you an undo portal if your cleanup removes more than expected.

Step 2: Select the range you want to clean

Click and drag to highlight the rows and columns you want Google Sheets to check. If your data has headers, include the header row too. For example, if your list uses columns A through D, you might select A1:D250.

The columns you select matter. If you select only the Email column, Sheets will treat matching email addresses as duplicates. If you select Name, Email, and Order Date, Sheets will only remove rows where all selected columns match.

Step 3: Use the Remove duplicates tool

1. Go to Data in the top menu.
2. Choose Data cleanup.
3. Click Remove duplicates.
4. If your first row contains labels, check Data has header row.
5. Choose which columns should be compared.
6. Click Remove duplicates.

Google Sheets will show a short summary telling you how many duplicate rows were removed and how many unique rows remain. That summary is your little “spell complete” message.

Example: Remove duplicate email addresses

Let’s say column A has names and column B has email addresses. If your goal is one row per email address, select your full range, open Data > Data cleanup > Remove duplicates, then check only the Email column in the duplicate settings.

This tells Google Sheets, “Keep the first version of each email address and remove later repeats.” It does not merge data from duplicate rows, so check your backup if different rows contain different notes, dates, or order details.

Use UNIQUE if you do not want to delete anything

If you want a clean list while keeping the original data untouched, use the UNIQUE formula on another sheet or in an empty area:

=UNIQUE(A2:D250)

This creates a new list with duplicate rows removed. Your original range stays exactly where it is. If you only want unique email addresses from column B, use:

=UNIQUE(B2:B250)

This is often the safer option when you’re experimenting or building a report.

Common mistakes to watch for

• Forgetting the header row: If you do not check “Data has header row,” your column labels may be treated like regular data.
• Selecting too few columns: You may remove rows based on one matching value, even when the rest of the row is different.
• Expecting rows to merge: Remove duplicates deletes repeated rows. It does not combine notes or values from multiple rows.
• Cleaning the only copy: Always duplicate the sheet tab first. Spreadsheet magic is better with a safety net.

Quick recap

To remove duplicates in Google Sheets, back up your tab, select your data range, then use Data > Data cleanup > Remove duplicates. If you want a non-destructive cleanup, use =UNIQUE(range) instead. Either way, you’ll have a cleaner sheet and fewer duplicate gremlins causing chaos.