Where Is Remove Duplicates in Google Sheets? Find It

In Google Sheets in a web browser, select the cells you want to check, then choose Data > Data cleanup > Remove duplicates. In the dialog, confirm whether the range has a header row and which columns should be compared, then click Remove duplicates to delete matching rows from the selected range.

Where the tool is and what it does

Remove duplicates is a built-in data-cleanup command, not a setting in the Format menu or a spreadsheet function. The path is Data > Data cleanup > Remove duplicates. It appears in Google Sheets’ browser interface after you select a range of cells. If the command is unavailable, first check that you are editing a Google Sheet and have selected a suitable range.

The command removes repeated records from the selection and keeps one occurrence of each record, rather than merely highlighting duplicates. For example, if a contact list contains the same name, email address, and phone number on three rows, you can compare all three columns and remove the extra copies. The remaining rows stay in the sheet; the tool does not create a separate cleaned list.

Because this action changes the selected data, check the range before running it. A quick safeguard is to duplicate the sheet using the sheet tab’s menu, or make a copy of the file if the original data needs to remain untouched.

How to remove duplicates step by step

Select the data range to clean. Include all columns that belong to each record, not just the column where a repeated value is obvious. You can select a single column if that is genuinely the only data you want to deduplicate.
Open Data > Data cleanup > Remove duplicates.
In the dialog, turn on Data has header row if the first row contains labels such as “Name” or “Email.” This tells Sheets not to treat those labels as an ordinary record.
Under Columns to analyze, choose the columns that define a duplicate. Review the selection: comparing every column is different from comparing only one or two.
Click Remove duplicates. Sheets reports how many duplicate rows it removed and how many unique rows remain. Check the cleaned range before continuing with other edits.

Suppose a table runs from A1 to C50, with headings in row 1 and customer details in columns A through C. Select A1:C50, mark the header-row option, and analyze all three columns if an entire row must match to count as a duplicate. If you instead analyze only the email column, two rows with the same email can be treated as duplicates even when their names or phone numbers differ.

How to choose the columns to compare

The most important decision is what “duplicate” means for your task. Sheets checks the columns you choose, so the right selection depends on the record’s identity, not merely on which column contains repeated-looking text.

Compare every column when you want to remove only identical records. Two rows with the same email but different phone numbers will both remain if those phone numbers differ.
Compare an ID or email column when that field is a reliable unique identifier and you want one row per identifier. Be cautious if the same identifier can legitimately appear more than once.
Compare several key columns when a record is defined by a combination, such as date, product code, and location. A repeated product code alone may not indicate a duplicate sale.
Exclude notes or changing fields if those fields should not determine whether two records are duplicates. Otherwise, different notes or timestamps may cause otherwise matching records to be kept as separate rows.

Also confirm that the selected range covers complete rows of related data. If you select only column A from a table that extends through column D, removing duplicate values in A will not clean the corresponding records in B through D. It can leave the remaining columns misaligned with the intended records. When cleaning a table, select the whole table so each deleted duplicate row is removed as a record.

What counts as a duplicate

The tool uses the contents of the selected columns to determine whether rows match; visual similarity alone is not a dependable guide. Formatting, such as font color or cell shading, should not be treated as a unique identifier. Likewise, two values that look similar may differ underneath—for example, a date stored as text may not match a real date value, or a name may contain an extra space.

Sheets’ duplicate-removal tool treats values as duplicates regardless of capitalization, so “North” and “north” can be considered the same for this cleanup. That can be useful for inconsistently capitalized names, but it matters if capitalization distinguishes codes in your data. Review the selected comparison columns and the resulting rows rather than assuming that the tool preserves every capitalization variation.

A further distinction is between duplicate rows and duplicate values in one column. If “Jordan Lee” appears twice but the rows contain different order numbers, those may be two legitimate transactions. Selecting just the name column would treat the repeated name as the basis for removal; selecting the whole transaction table would keep both if their other values differ. The command follows the comparison you set, not your unstated idea of what a record represents.

Check the data before and after cleanup

Before using the command, inspect the top and bottom of the range and confirm that it contains the intended records. Include the header only if you can mark the header option. Avoid selecting unrelated totals or notes in the same columns: those values can be swept into the comparison and may be changed as part of the operation.

Afterward, use the removal summary as a quick reasonableness check. If you expected a few repeated rows but Sheets reports many, stop and consider whether you selected the wrong columns or omitted important fields. If it reports none, the apparent duplicates may differ in a selected value, contain invisible spaces, or be outside the selected range.

For high-stakes or hard-to-rebuild lists, preserve a copy before cleaning. You can also immediately use Undo if the result is not what you intended, but do not rely on undo as your only backup—especially if you make additional edits afterward. Google Sheets keeps version history, which can help recover an earlier state, but a separate copy makes it easier to compare original and cleaned data.

Common problems and how to fix them

The command is missing or disabled: Verify that you are in Google Sheets, have editing permission, and have selected cells in the sheet. A view-only file may not allow the cleanup edit.
It removed too many rows: The selected comparison columns may be too narrow. Undo if possible, then rerun the command with additional columns that distinguish legitimate records.
It removed no rows: Check whether the range includes the repeated records and whether the selected columns really match. Extra spaces, inconsistent data types, or a differing value in a selected column can prevent a match.
The wrong row was kept: Sort or arrange the data before deduplicating if a particular occurrence should be retained. For example, sort by a timestamp so the preferred record appears first, then run the cleanup. Verify the sort and result carefully.
Related columns no longer line up: You may have selected only part of the table. Undo, select the complete record range, and repeat the operation so duplicate records are removed as whole rows.

Cleaning inconsistent text is a separate task from removing duplicates. If entries differ because of extra spaces or inconsistent spellings, standardize those values first, then run the cleanup. Otherwise, two records that a person considers equivalent may not match as expected. Make a copy before applying bulk changes to a source list.

Remove duplicates versus formulas and highlighting

Use the menu command when you want to change the existing data by deleting repeated records. If you want to keep the source intact and generate a live list of distinct rows elsewhere, the Google Sheets UNIQUE function is an alternative. With source records in A2:C100, enter =UNIQUE(A2:C100) in an empty area; it returns distinct rows based on the complete rows across those three columns. The result updates as the source range changes, while the original records remain in place.

A formula is often better for a report or a working view because it does not delete source rows. The menu command is more suitable when the goal is to clean the actual table. A formula output also needs enough empty space to expand, and it is not the same as permanently removing duplicate records from the source.

Conditional formatting is another different option: it can visually flag repeated values so you can inspect them, but highlighting does not remove them. Use highlighting when duplicates require a human decision—for example, when two customer records share a phone number but may belong to different people. For a one-time cleanup with a clear rule, the Data cleanup command is usually more direct.

How it compares with Excel

Excel has a similar remove-duplicates feature, but this article’s menu path applies to Google Sheets in a browser. In Excel for Microsoft 365 on Windows, the comparable command is on the Data tab, under Data Tools > Remove Duplicates. The dialogs and exact interface differ, so do not look for Google Sheets’ Data cleanup submenu in Excel.

The same practical cautions apply in either program: select complete records, decide which columns define a duplicate, and protect the original if you need to preserve it. If a spreadsheet is shared with other people, tell collaborators that you are changing the underlying rows or make a copy first, so the cleanup does not surprise someone relying on the original list.

Frequently Asked Questions

Does Remove duplicates delete the whole row?
It removes duplicate rows within the range you selected. Select all columns belonging to each record if you want complete duplicate records removed together; selecting only one column does not make unrelated, unselected data part of the comparison.

How do I keep the header row?
Select the table, open Data > Data cleanup > Remove duplicates, and check Data has header row in the dialog. Then choose the comparison columns and run the cleanup.

Can I remove duplicates based on just one column?
Yes. In Columns to analyze, select only the field that defines a duplicate, such as an email address. Check that this is safe for your data: rows with the same email but different details may still represent information you need to retain.

Can I undo Remove duplicates?
Use Undo immediately if you notice an unwanted result. For better protection, duplicate the sheet or make a file copy before cleaning, particularly when you may need to compare or restore the original records later.

Does Remove duplicates only highlight repeated values?
No. It removes duplicate rows from the selected range. To inspect repeated entries without deleting them, use a highlighting method such as conditional formatting, or make a separate distinct list with UNIQUE.

Why are two entries that look the same not removed?
They may differ in a selected column because of spaces, stored data types, or another less-visible difference, or one may be outside the selected range. Check the underlying cell contents and the columns chosen in the dialog.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.