How to remove duplicates from Google Sheets - tutorial

How to remove duplicates in Google Sheets

No one likes duplicates in their spreadsheets, but filtering these out is no easy task even if you’re familiar with formulas.

In this short tutorial, we will show you how you can remove duplicates in seconds from any Google sheet or CSV file in just a few clicks using Hexomatic. No need for complex formulas or code.

Step 1: Create a new workflow

Go to the automations list, and find the Google sheets import automation. Then, click Create Workflow.

Or create your workflow from a data input if you want to upload a CSV file. 

Step 2: Choose the account

Next, choose the Google account which you want to use, Select the spreadsheet and specify the column you want to check for duplicates.

Step 3: Add the Remove duplicates automation

Add the remove duplicates from spreadsheet automation, selecting Google import as the source.

This automation detects duplicates in specific columns. 

Step 4: Add the Filter data by criteria automation

If you found duplicates in Google sheet you should add the filter data by criteria automation, selecting Google import as the source in order to remove them from the column. Select “Doesn’t contain” as the criteria type, adding duplicate as the value.

Then, click Continue. 

Step 5: Run or schedule the workflow

You can click Run now to run the automation or schedule it.

Step 6: View and save the results

Once your workflow has finished running, you can view the results in the Results preview. Then, you can export the results to Google sheets. 

Automate & scale time-consuming tasks like never before

Hexomatic. The no-code, point and click work automation platform.

Harness the internet as your own data source, build your own scraping bots and leverage ready made automations to delegate time consuming tasks and scale your business.

No coding or PhD in programming required.