# How to remove duplicate rows in Google Sheets on Mac: step by step with fixes

> Learn how to remove duplicate rows in Google Sheets on Mac using Data > Data cleanup > Remove duplicates. Steps, Mac shortcut, and fixes when it fails.

URL: https://www.lazur.app/how-to/remove-duplicate-rows-in-google-sheets
Updated: 2026-11-06

To remove duplicate rows in Google Sheets on a Mac, select your data, then click Data > Data cleanup > Remove duplicates. Pick the columns that define a duplicate, say whether your first row holds headers, and click Remove duplicates to finish.

## Quick answer

- Google does not list a Mac app for Sheets. You run it in a browser, and the tool lives in the Data menu.
- Select your data first. Even if you click a single cell, the removal applies to the whole range.
- Choose the columns that define a duplicate, and tell Sheets when row one holds headers.
- Copy the sheet before you start. Press ⌘Z right after a removal if the result looks wrong.
- If the menu is greyed out or duplicates survive, check for filters, protected ranges, and hidden spaces.

Applies to: Google Sheets in a browser on a Mac, the web version. Time: 5 min. Difficulty: Easy.

## What you need

- Edit access to the spreadsheet. Viewers cannot remove rows.
- Google Sheets open in a browser on your Mac.
- A backup tab with the original data.
- Chrome or Edge if you want to work offline.

## How to Remove duplicate rows in Google Sheets in Google Sheets on a Mac

1. **Open your spreadsheet.** Open the spreadsheet in Google Sheets in your browser. Make sure you have edit access, since viewers cannot remove rows. Tip: Google's product page does not mention a Mac app, so the browser is the route.
2. **Select the data range.** Drag from the top-left cell of your data to the bottom-right cell. Include the header row if you have one. If you click only one cell inside the range, Google still applies the removal to the whole range. Tip: Third-party guides say an active filter can grey out the menu, so clear it first.
3. **Open the Data menu.** (Data) Shortcut: ⌃⌥D. Click Data in the Sheets menu bar. You can also press ⌃⌥D to open the Data menu from the keyboard. Tip: Google lists this shortcut as Ctrl + Option + D. On a Mac keyboard that is ⌃⌥D.
4. **Point to Data cleanup.** (Data > Data cleanup) Move the pointer onto Data cleanup so its submenu opens. Tip: If the submenu does not open, click Data cleanup once.
5. **Click Remove duplicates.** (Data > Data cleanup > Remove duplicates) Click Remove duplicates. A dialog opens with your columns and a setting about headers. Tip: Google's help page does not give the exact label of the header setting, so read the dialog text.
6. **Choose columns and the header setting.** Pick the columns that should define a duplicate. Then say whether the data has headers. Rows match only when every chosen column matches. Tip: Start with the columns that identify one record, such as an ID or an email.
7. **Confirm the removal.** Click Remove duplicates in the dialog. Sheets removes the matching rows from the range. Check the sheet right away. Tip: If the result is wrong, press ⌘Z before you make any other change.

## Google Sheets on a Mac runs in your browser

Google does not list a Mac app for Sheets. Its Sheets product page does not mention a Mac app or any downloadable desktop application. You open your spreadsheet in a browser tab and work there. The same page says you can use Sheets from a phone, a tablet, or a desktop, so the browser is the route on a Mac.

The steps in this guide follow Google's Data cleanup instructions for the computer version of Sheets. Google's help page does not list Mac-specific notes for this tool. So the menu names are the ones you see in the browser, and the Mac shortcut comes from Google's shortcut list. If a name looks slightly different on your screen, look for the same words under Data.

## Before you remove anything, keep a copy

Removing duplicates deletes rows from your sheet. Google's help page does not say whether removed rows can be brought back once you leave the sheet. Treat the removal as final unless you can undo it right away. Google's shortcut list gives ⌘Z for undo.

The safest habit is a second tab. Copy the original data into a new tab, then run the removal on the tab you plan to keep. If the result is wrong, the untouched version is still there. For a large file, this takes little time and saves a lot of trouble.

- Confirm you have edit access. A viewer cannot remove rows.
- Clear any filter so you can see every row.
- Decide which columns make a record unique, such as an ID or an email.
- Make the backup tab before you click anything in the Data menu.

## Choose which columns count as duplicates

A duplicate depends on the columns you choose. Google's help page says you select which columns to include. Sheets compares only those columns. If rows match in every chosen column, Sheets treats them as duplicates.

Here is a simple case. Say your sheet has a name column, an email column, and a city column. If you check only the email column, rows with the same email count as duplicates, even if the city differs. If you check all three, the rows stay, because the city differs.

Pick the columns that identify one record. For a customer list, an email or a customer ID often works. For an order log, you might need the order ID and the date together. Test your choice on the backup tab first, then run it on the real data.

## Keep the header row out of the comparison

If row one holds column names, tell Sheets that the data has headers. That keeps the names out of the comparison. Google's help page paraphrases this option and does not give the exact label, so read the dialog text before you click Remove duplicates.

Headers matter most when a header name could match a real value. A column named Email in row one should not compete with the addresses below it. Mark the header setting, then check the first few rows after the removal.

## Three ways to handle duplicate rows in Google Sheets on Mac

| Option | What it does | Where the claim comes from |
| --- | --- | --- |
| Data > Data cleanup > Remove duplicates | Removes matching rows from the range you select | Google Docs Editors Help |
| UNIQUE formula | Returns a copy of the unique rows and leaves your data in place | Third-party guides, not verified by Google |
| Remove Duplicates add-on by Ablebits | Third-party add-on with a 3.3 star average from 1,742 ratings | Google Workspace Marketplace listing |

_Built-in removal, a formula, and an add-on compared_

The built-in tool suits a one-time cleanup. UNIQUE suits you when you want to keep the original rows and build a clean list beside them. An add-on makes sense only after you read its reviews and permissions.

## Why some duplicate rows survive the removal

Google's help page says cells with identical values count as duplicates, even if they differ in letter case, formatting, or formulas. So formatting alone will not stop a match. Some third-party guides report a different cause. Hidden spaces at the start or end of a cell can stop a match, even though the cell looks the same.

If a row you expected to remove stays, check for spaces. A helper column with TRIM can show the cleaned text. Third-party guides also mention UPPER and LOWER for letter case. Google's help page is the more reliable source on case, so test any case fix on the backup tab first. To replace spaces across many cells, see [How to find and replace in Google Sheets on Mac](https://www.lazur.app/how-to/find-and-replace-text-in-google-sheets).

![Person at a Mac laptop checking a spreadsheet before they remove duplicate rows in Google Sheets](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/remove-duplicate-rows-in-google-sheets/how-to-remove-duplicate-rows-in-google-1-c653cb.jpg)

## Use UNIQUE to keep a copy instead

UNIQUE is a formula, not a menu command. Type it into an empty cell and point it at your data. For example, =UNIQUE(A:C) returns the unique rows from columns A through C. Your original data stays where it is. The header row is part of that range, so it comes back too.

Third-party guides describe UNIQUE as non-destructive. Google's Remove duplicates help page does not cover the formula. Use UNIQUE when you want both versions. Use Remove duplicates when you want the sheet itself cleaned. Either way, label the new output so the next person knows which tab is clean.

## Mac keyboard shortcuts for this task

Google's keyboard shortcut page lists ⌃⌥D for the Data menu on a Mac. It lists ⌘Z for undo and ⌘F for find. It does not list a shortcut for Remove duplicates, so you click that item with the trackpad or mouse.

Use ⌘F to find a value across the sheet before you remove anything. Searching for a name shows you every match. If a removal goes wrong, press ⌘Z before any other edit, so you undo only the removal.

![Man working on a MacBook at a desk, the setting for cleaning up duplicate data in a sheet](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/remove-duplicate-rows-in-google-sheets/how-to-remove-duplicate-rows-in-google-2-7b0335.jpg)

## Limits to check on a big sheet

Google's Drive help page says a spreadsheet can hold up to 20 million cells or 100 MB. If your file sits close to either limit, split the data across tabs or files before you clean it. A smaller file is easier to check after the removal.

If your sheet started in Excel, check the long cells. Google's help page says that any cell with more than 50,000 characters is removed when you convert an Excel file. That is a conversion issue, not a duplicate issue, but it can change the rows you compare.

## Add-ons for removing duplicates: what the ratings tell you

The Remove Duplicates add-on from Ablebits is listed in the Google Workspace Marketplace. The listing shows more than 3 million installs and an average rating of 3.3 stars from 1,742 ratings. A low average for an add-on with that many installs is worth a close look.

An install count shows how many people tried the add-on. It does not show how well it worked for them. Read the newest reviews, and check which data the add-on asks to access before you install it. The built-in menu needs no add-on.

## Common mistakes people make

- Removing duplicates before making a copy of the data.
- Checking only one column when the whole row defines a record.
- Leaving the header setting off, so column names get compared like data.
- Clicking one cell and assuming only that column is checked. Google applies the removal to the whole range.
- Opening the menu with a filter on, then wondering why it is greyed out.
- Trusting the first result without checking the rows at the top and bottom.

## Work offline or check your access on a Mac

If you need to clean a sheet without a connection, offline access is the route. Google's offline help page lists Chrome and Edge only. It does not mention Safari or a Mac version. Open Google Drive in Chrome or Edge, click the Settings gear, then Settings, and turn on the Offline setting.

The Google Docs Offline Chrome extension is required. Do not use private browsing. If you see Offline sync is disabled by your administrator, your organization has blocked offline access. Only one account per browser profile can have offline access, so sign in to the right account first.

## What to do after the cleanup

Compare the new row count with your backup tab. Scan a few rows near the top, the middle, and the bottom. Look for a row that should have stayed. If the sheet is long, freeze the header row so column names stay visible while you scroll. The steps are in [How to freeze the top row in Google Sheets on Mac](https://www.lazur.app/how-to/freeze-the-top-row-in-google-sheets).

Then save the clean version under a name that says it is clean. Keep the backup until you have used the clean data in whatever comes next, such as a report or a shared file. A clear name saves a question later.

![Laptop screen showing a table of data, the kind of sheet where duplicate rows build up](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/remove-duplicate-rows-in-google-sheets/how-to-remove-duplicate-rows-in-google-3-6421c7.jpg)

## Shortcuts

- Open the Data menu in Google Sheets on a Mac: ⌃⌥D
- Undo the last change, including a removal: ⌘Z
- Find text in the sheet: ⌘F

## If it does not work

- **Remove duplicates is greyed out** Google's help page does not list this error. Third-party guides say an active filter, a protected range, or a cell still in edit mode can block the menu. Clear the filter, press Escape to leave edit mode, and check for protected ranges.
- **Duplicate rows are still there** Google counts values as duplicates even when case or formatting differs. Some third-party guides say hidden spaces still block a match. Use TRIM in a helper column to see the cleaned text, and run the removal again only after you check it.
- **Rows disappeared that should have stayed** Press ⌘Z right away. If you already left the sheet, Google's help page does not say whether the rows can be recovered, so use your backup tab. Then run the removal again with the right columns selected.
- **The header row was removed** Press ⌘Z to bring back the rows you lost. Then run the removal again with the header setting turned on, and check the first row before you continue.
- **Long text is missing after converting an Excel file** Google's help page says any cell with more than 50,000 characters is removed when you convert an Excel file. Check long cells in the original file, and keep that file as a backup.
- **The sheet is too large to work with** Sheets caps a spreadsheet at 20 million cells or 100 MB. Split the data across tabs or files. Duplicates that cross the split will not match, so check the columns carefully.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where is Remove duplicates in this sheet?”: Lazur circles the Remove duplicates menu item and labels it on your screen. You still click it yourself. (Points at it)

## FAQ

### Is there a Mac app for Google Sheets?

Google does not list a Mac app for Sheets. Its Sheets product page does not mention a Mac app or downloadable desktop application. Open the spreadsheet in a browser on your Mac, select your data, then use Data > Data cleanup > Remove duplicates.

### What is the Mac shortcut for the Data menu in Google Sheets?

⌃⌥D opens the Data menu in Google Sheets on a Mac. Google writes it as Ctrl + Option + D. Google's shortcut list does not include a shortcut for Remove duplicates, so you click that item.

### Does removing duplicates delete rows for good?

Google's help page does not say whether removed rows can be recovered after you leave the sheet. Press ⌘Z right away if you need to undo a removal. Keep a backup tab before you start.

### Why do some duplicates stay after I run the tool?

Some third-party guides point to hidden spaces, so check for them with TRIM in a helper column. Also confirm you chose the right columns. Rows match only when every chosen column matches.

### Can I remove duplicates based on only some columns?

Yes. The dialog lets you select which columns to include. Sheets compares only those columns, so rows that differ in other columns can still be removed.

### Do I need to select the whole table first?

Not always. Google's help page says that if you select a single cell within a range, duplicates are removed for the whole range. Select the full data range anyway, so it is clear what you are cleaning.

### Can I do this on an iPhone or iPad?

This guide covers the browser version on a Mac. Google's help page for this feature covers the computer version, so check the menus on a phone or tablet before you follow these steps.

### Is the Ablebits add-on worth installing?

The Marketplace listing shows more than 3 million installs and a 3.3 star average from 1,742 ratings. Those numbers do not prove how the add-on handles your data. Read recent reviews and check the access it asks for.

## Sources

1. [Split text, remove duplicates, or trim whitespace: Computer, Google Docs Editors Help](https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-07
2. [Google Docs Editors Help: Keyboard shortcuts](https://support.google.com/docs/answer/181110?hl=en), Google, checked 2026-11-07
3. [Google Drive Help: File size and limits](https://support.google.com/drive/answer/37603?hl=en), Google, checked 2026-11-07
4. [Google Docs Editors Help: Use Google Docs, Sheets, and Slides offline](https://support.google.com/docs/answer/6388102?hl=en), Google, checked 2026-11-07
5. [Google Workspace: Google Sheets product page](https://workspace.google.com/products/sheets/), Google, checked 2026-11-07
6. [Remove Duplicates: Google Workspace Marketplace](https://workspace.google.com/marketplace/app/remove_duplicates/347814268012), Ablebits (developer), checked 2026-11-07