If you’ve noticed that you have the same data in more than one place in your Google Spreadsheet, don’t worry! You can quickly tidy it up by removing these extra bits, which are called ‘duplicates’. Follow these easy steps that show you how to remove duplicates from a Google Spreadsheet using the Remove duplicates feature.

Step 1: Highlight or Select Your Data

Select the data range that you’d like to remove duplicates in. Or you can select all cells in the sheet.

Step 2: Navigate to the ‘Data’ Menu Option

At the top menu, find Data / Data cleanup / Remove duplicates menu item.

Step 3: Start the Cleanup Process

Now, you’re ready to get rid of those duplicates! Click “Remove duplicates”. A box will pop up and tell you how many duplicates were found and removed. Click on “Done”.

And that’s it! You’ve just cleaned up your Google Spreadsheet by removing all duplicate data entries. Now, your spreadsheet should be nice and tidy. Well done!