How to Remove Duplicates in Google Sheets in Minutes

Every list gets duplicates eventually. A customer signs up to your mailing list twice, a form gets submitted again, you merge two exports and half the names appear double. The result is a Sheet you can't trust, and it's easy to count the same person twice without noticing.

Google Sheets has a built-in tool that clears them in a few clicks. I've gone through Google's own help page so the steps below match what it says, including the one rule about duplicates that surprises most people.

Using Data cleanup to remove duplicates in Google Sheets

On a computer, Google's help gives these steps:

1. Open your spreadsheet in Google Sheets.
2. Select the data range you want to check.
3. Open the Data menu, go to Data cleanup, then choose Remove duplicates.
4. Choose which columns to include, and tell Sheets whether your data has a header row.
5. Click Remove duplicates.

Google adds a small but useful note: if you select a single cell inside a range, the duplicates are removed for the whole range. So you don't have to drag across every row if your data is one neat block.

What Google Sheets counts as a duplicate

This is the part to read twice. Google's help says cells with identical values but different letter cases, formatting or formulas are considered to be duplicates. In plain English, "Anna" and "ANNA" are treated as the same entry, even if one is bold and one is red.

That's usually what you want for a customer list. It's worth knowing if you keep two similar-looking entries on purpose, such as product codes where capital letters matter. In that case, check a copy first.

Choosing the right columns before you remove duplicates

The column choice decides what "duplicate" means for your data. A few examples from everyday small business sheets:

• A mailing list with name, email and sign-up source: tick only the email column if you want one row per address.
• An orders list with order number, customer and item: tick every column if only fully identical rows should go.
• A supplier list with company name and contact: tick the company column if you want one row per supplier.

The header option matters too. If your first row holds labels like Name and Email, tell Sheets so it doesn't treat the labels as data.

Protecting your data before you remove duplicates

Removal deletes rows, so treat it with respect. Before you run it on anything important:

1. Make a copy of the Sheet or duplicate the tab so you have a clean original.
2. Sort or scan the list so you know roughly what to expect.
3. Run the tool on a copy, check the result, then repeat on the real tab.
4. If something looks wrong straight away, use Undo from the Edit menu.

If your Sheet collects answers from a web form, duplicates are often a sign that the form lets people submit more than once. My round-up of Google Forms alternatives covers form builders if you decide yours needs tighter rules.

Other Data cleanup tools next to Remove duplicates

The same Google help page covers two close relatives that tidy messy imports:

Tool	What Google says it does
Remove duplicates	Removes repeated rows in the selected range, based on the columns you pick
Trim whitespace	Removes extra leading, trailing or repeated spaces in the selected range
Split text to columns	Splits clearly defined data, like text separated by commas, into several columns

Trim whitespace is worth running first. Google notes that non-breaking spaces won't be trimmed, but for ordinary stray spaces it can stop two near-identical entries slipping past the duplicate check.

Removing duplicates in Google Sheets on a phone

Google's help for iPhone and iPad points you back to a computer for these data tools, so plan to do your clean-up in a browser. I couldn't confirm a phone route in the official pages, so I wouldn't rely on one.

If you're building a Sheet that other people will keep adding to, a good template saves repeat clean-ups. I put together some thoughts on picking a productivity template that suits your business, and the same thinking applies to a shared list.

A tidy routine for keeping duplicates out of a Google Sheets list

Clearing duplicates once is satisfying, but the same mess comes back if the source doesn't change. A short routine keeps a customer or content list healthy without much effort:

• Decide which column is the unique identifier, usually the email address or an order number, and always tick that one first.
• Run Trim whitespace, then Remove duplicates, so invisible spaces don't hide repeats.
• Do the clean-up before you import the list into an email tool or hand it to a colleague.
• Keep a dated copy of the tab from before the clean-up. It takes seconds and saves arguments later.

I like to keep one tab for raw data and one for the cleaned list. That way, if a client asks why a name vanished, you can point to the raw tab and show exactly what was removed.

If Remove duplicates in Google Sheets misses some rows

1. Check for stray spaces at the start or end of cells, and run Trim whitespace first.
2. Check that you ticked the right columns. A hidden difference in an extra column means the rows aren't identical.
3. Look for small spelling differences. Sheets matches values, not meaning, so "Jon" and "John" stay separate.
4. Make sure you selected the whole range, or a cell inside it.

Frequently asked questions

How do I remove duplicates in Google Sheets?

Select your data, open Data, then Data cleanup, then Remove duplicates. Choose the columns to compare, say whether you have a header row, and click Remove duplicates.

Does Google Sheets treat upper and lower case as the same?

Yes. Google's help says cells with identical values but different letter cases, formatting or formulas are considered duplicates.

Do I need to select the whole range?

No. Google's help says that if you select a single cell within a range, duplicates are removed for the whole range.

Can I undo removing duplicates?

Use Undo from the Edit menu straight away. It's safest to work on a copy of the tab first.

Can I trim spaces as well?

Yes. Data cleanup also has Trim whitespace, which removes extra leading, trailing or repeated spaces. Non-breaking spaces won't be trimmed.