---
title: "How to Delete Duplicates in Google Sheets"
h1: "How to Delete Duplicates in Google Sheets"
description: "Easily remove duplicate entries in Google Sheets to maintain data integrity. Follow step-by-step instructions to streamline your spreadsheet."
route: "/learn/how-to-delete-duplicates-in-google-sheets"
canonical: "https://www.layerpath.com/learn/how-to-delete-duplicates-in-google-sheets"
---

# How to Delete Duplicates in Google Sheets

Easily remove duplicate entries in Google Sheets to maintain data integrity. Follow step-by-step instructions to streamline your spreadsheet.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cm6ffghlq0001jm0c0n3m2bpn/tour

Tour id: cm6ffghlq0001jm0c0n3m2bpn

1. Highlight the data range that may contain duplicates.
2. Click **Data** in the top menu and select **Data cleanup > Remove duplicates**.
3. If your range has headers, check the **Data has header row** box.
4. Click **Remove duplicates**, and Google Sheets will scan for identical rows.
5. A pop-up will show how many duplicates were found and removed.
6. Click **OK** to finalize, and your data will now be free of duplicates.