How To remove duplicates in Google Sheets

How To remove duplicates in Google Sheets

When you are dealing with a large volume of data in a spreadsheet, you are bound to have duplicate entries. After all, no human is immune to making errors. But no worries, Google Sheets have a solution for it.

Having to remove duplicates one by one could be an extremely time-consuming task. But luckily, Google Sheets gives you the option to remove duplicates in just a few clicks.If you take a good look at the Sheets, you won’t see a direct button to perform the step. So then how to do it? You are lucky to have found this page. In this post, we are going to discuss the steps you need to follow to remove the duplicate entry in Sheets. Even if you are using Sheets for the first time, you should be able to follow the steps. So without wasting time, let’s get into the details.

Steps to remove duplicates in Google Sheets:

  1. Open Google Sheets:
How To remove duplicates in Google Sheets
  1. Now, select the column you want to remove duplicates from:
How To remove duplicates in Google Sheets
  1. Next, navigate to  Data > Remove duplicates:
How To remove duplicates in Google Sheets
  1. You will now see a pop-up. Tick the box next to Data has header now > click Remove duplicates > click Done.
How To remove duplicates in Google Sheets
How To remove duplicates in Google Sheets
  1. Duplicates from the selected data will be removed:
How To remove duplicates in Google Sheets

Checkout our post on, How to highlight duplicates in Google Sheets, if you just want to highlight the duplicates.