Remove Duplicates

Modified on Fri, 26 Apr at 9:39 AM

Delete Duplicates allows a user to delete rows containing any repeat values found in a single column or a combination of columns. This article will cover how to deduplicate in Gigasheet. 

Note: To review duplicates without deletion, please visit our article on how to group values

How to Delete Duplicates 

To Delete Duplicates select Data > Data Cleanup > Delete Duplicates

Under DataData Cleanup, select Remove Duplicates.

Select the column(s) you would like to delete duplicates from and select Remove

Review the prompt for accuracy. Note, this function cannot be undone. We recommend making a copy of a sheet if you are unsure about deleting duplicates. Deleting duplicates will delete entire row in which the duplicate value is found.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article