How to Remove Duplicate Rows in Google Sheets

When consolidating customer contacts, event RSVPs, or transactional datasets from multiple team members into Google Sheets, identical entries frequently slip through. Duplicate records inflate survey totals, distort revenue metrics, and cause embarrassing double-emails to clients. Manually scanning and deleting duplicate rows is slow and error-prone.

Google Sheets includes a native data-cleaning tool that inspects entire tables or specific identifier columns and deletes redundant rows in a single click.

Method 1: Using the Native “Remove Duplicates” Tool

The most direct way to clean your table in-place is via the Data menu:

  1. Open your spreadsheet in Google Sheets.
  2. Click anywhere inside your dataset, or select the exact range of cells you wish to clean (for example, A1:E150).
  3. In the top menu bar, click on Data.
  4. Hover over Data cleanup and select Remove duplicates from the submenu.
  5. In the configuration popup:
    • Tick Data has header row if your top row contains column titles.
    • Choose which columns to analyse. You can select Select all to remove rows that are 100% identical, or tick a single column (such as Email or Order ID) to eliminate duplicates based on unique keys.
  6. Click Remove duplicates.

Google Sheets immediately purges the duplicate entries and displays an informational prompt stating how many duplicate rows were removed and how many unique rows remain.

Method 2: Non-Destructive Filtering with the UNIQUE Function

If you wish to keep your original raw database intact and output a pristine, deduplicated list into a separate worksheet tab:

  1. Navigate to a blank worksheet tab.
  2. Click cell A1 and enter the formula:
    =UNIQUE(Sheet1!A1:E150)
  3. Press Enter. Google Sheets generates an automated clean table containing only unique records dynamically.

Cleaning duplicated records ensures data integrity across operational dashboards, financial summaries, and client outreach campaigns.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.