How To Remove Duplicates From A Spreadsheet
Last Updated: October 29, 2021
There are certain instances when you’ll have to delete specific data and information. Deleting is an easy task, sure, but when you encounter the need to delete a bunch of this particular data, that’s another story. Imagine the effort and time that you’ll invest in removing the same type of data several times in your spreadsheet. Quite a hassle!
Fortunately, Google Sheets has a function that allows you to remove duplicate data from your sheet with just a few clicks away. How convenient, right? Just follow these steps, and you’re good to go.
1. Go to Google Sheets then select a spreadsheet to edit.
To begin, launch your web browser and navigate to Google Sheets. If you’re already on the Google Sheets page, go through all of your existing spreadsheets and choose the one you want to edit. If there aren’t any, you can make one, and then after you’ve entered data, you can remove duplicates from the columns.
2. Select the column from where you want to remove duplicates.
Select a column in the spreadsheet where you want to remove duplicates. Depending on how many columns you want to edit, you can remove duplicates from them all at once. To know that you’ve selected the right column, you must see a blue outline around it.
3. Click the “Data” option from the menu bar.
After you’ve chosen a column, click the “Data” button in the menu bar. This will generate a drop-down menu on your screen.
4. Choose “Remove duplicates” from the list.
The drop-down menu will contain various editing options related to all of the data and information in the sheet. It is divided into several sections, including one for filters, data ranges, and rows and columns. Scroll down until you see the “Remove duplicates” option in the list, then click it to bring up a pop-up window on your screen.
5. Click the “Remove duplicates” button in the pop-up window.
After you’ve decided to remove duplicates from a specific column, a pop-up window will appear on your screen, requesting confirmation. You must double-check the data in this window to remove the correct data, and then click the “Remove duplicates” button to confirm your action and permit Google to delete duplicated data.
6. Click the “OK” button on the pop-up information window.
After you’ve removed the duplicates, the results will be immediately applied to your sheet, but a pop-up window will appear informing you of the action you just took. It will inform you of the number of duplicated rows that were removed. Click the “OK” button in the pop-up window’s bottom right corner to confirm the activity.
Simply repeat the process if you want to remove duplicates from other columns as well.
Deleting duplicate data is as easy as you think it is. Thanks to the “Remove duplicates” function, of course! However, it would be best to keep in mind that you are sure of the data you want to delete. You’ll never know, but it might be something of significance to you. Always remember to be mindful and cautious of your actions. This will save you so much time!