How to Delete Duplicates in Google Sheets: A Step-by-Step Guide

Getting rid of duplicates in Google Sheets can be a real headache, right? But don’t you worry, because I’ve got your back. After reading this, you’ll be able to clean up your sheet in no time. All you need is a few clicks here and there, and voilĂ ! Your data will be as neat as a new pin.

Step by Step Tutorial on How to Delete Duplicates in Google Sheets

Before we get into the nitty-gritty, let me tell you what we’re going to do. We’ll use Google Sheet’s built-in features to find and remove any duplicate entries. It’s simple and doesn’t require any fancy add-ons or formulas.

Step 1: Open your Google Sheet

First things first, open up the Google Sheet you want to clean up.

Once you have your Google Sheet open, take a quick look through your data. It’ll help you spot the duplicates you’re about to zap away.

Step 2: Select the range or column

Click and drag to select the range or column where you suspect the duplicates are lurking.

Selecting the right range is crucial. If you pick too little, you might miss some duplicates; too much, and you might delete data you want to keep.

Step 3: Click on ‘Data’ in the menu

Now, go up and click on ‘Data’ in the top menu. That’s where the magic happens.

The ‘Data’ menu is like the control center for your sheet. It’s got all the tools you need to whip your data into shape.

Step 4: Click on ‘Remove duplicates’

In the ‘Data’ menu, find and click on ‘Remove duplicates’. It’s like a vacuum cleaner for your data.

This is the critical step. Once you click this, Google Sheets will start hunting down those pesky duplicates.

Step 5: Choose if your data has headers or not

A little window will pop up asking if your data has headers. Check the box if it does, leave it unchecked if it doesn’t.

Headers are important because they tell Google Sheets what kind of data it’s looking at, which helps it spot duplicates more accurately.

Step 6: Select the columns to analyze

Still in that window, pick the columns you want Google Sheets to check for duplicates.

Be selective! Only choose the columns that you need to be deduplicated. This makes sure you only remove the duplicates you want to.

Step 7: Click on ‘Remove duplicates’

All set? Now hit that ‘Remove duplicates’ button in the window.

After you click this, hold tight because Google Sheets is about to sweep out those duplicates.

Once you’ve completed these steps, you’ll have a nice, clean sheet. All the duplicates will have vanished, just like that!

Tips for Deleting Duplicates in Google Sheets

  • Always make sure to have a backup of your data before removing duplicates. Better safe than sorry!
  • Use the ‘Undo’ feature (Ctrl + Z) if you accidentally remove something you didn’t mean to.
  • Regularly check for duplicates to keep your sheet tidy.
  • If you have a massive amount of data, consider using a script or add-on for more efficiency.
  • Remember that ‘Remove duplicates’ only works on contiguous rows of data, so make sure your duplicates aren’t broken up by empty rows.

Frequently Asked Questions

What if I only want to remove duplicates from a specific range and not an entire column?

Just select the range you want to deduplicate before clicking on ‘Remove duplicates’. That way, you’ll limit the clean-up to your chosen area.

Can I remove duplicates based on multiple columns?

Absolutely! In the ‘Remove duplicates’ window, you can select as many columns as you need. Google Sheets will then only remove rows where all the selected columns have duplicate data.

What happens if my data has headers?

If your data has headers, make sure to check the ‘Data has header row’ box. This tells Google Sheets to ignore the first row when looking for duplicates.

Will ‘Remove duplicates’ delete my formatting?

No, it won’t. ‘Remove duplicates’ only removes the data, not any formatting you’ve applied to your cells.

Can I use ‘Remove duplicates’ with data from different sheets?

No, ‘Remove duplicates’ only works within a single sheet. If you need to deduplicate data from multiple sheets, you’ll need to combine them first.


  1. Open your Google Sheet.
  2. Select the range or column.
  3. Click on ‘Data’ in the menu.
  4. Click on ‘Remove duplicates’.
  5. Choose if your data has headers.
  6. Select the columns to analyze.
  7. Click on ‘Remove duplicates’.


Phew! You’ve made it to the end, and you’re now a pro at deleting duplicates in Google Sheets. Remember, having clean and accurate data is key to making informed decisions, whether you’re crunching numbers for work, school, or your personal projects. It’s all about getting the most out of your data, and a tidy Google Sheet is a happy Google Sheet.

And hey, why stop here? Mastering this skill is just the beginning. There’s a whole world of Google Sheets tips and tricks out there that can boost your productivity and make you a data wizard. So, keep exploring, keep learning, and don’t forget to back up your data before you go on a deleting spree. Happy deduplicating!