Remove duplicates, find duplicates, and highlight duplicates in Google Sheets.
SheetDupes cleans the spreadsheet you already have open. Preview matching rows, highlight the extras, remove or merge them, compare two tabs, and standardize names, emails and phone numbers — without sending your data to us.
14-day free trial · No credit card to start · After the trial, Preview and Highlight stay free, and writes stay available on sheets with up to 500 data rows · Your data never leaves your Google account
Built for messy lists, not a new database.
Contacts, unsubscribes, event sign-ups, CRM exports — clean them in place.
Find duplicates
Match on any columns you pick. Exact match ignores extra spaces, and can ignore case or punctuation when you want.
Highlight duplicates
Shade the extra rows and leave every value as it is, so you can review before anything is removed.
Remove or merge
Keep the first or last row in each group, or merge by filling blanks and joining distinct notes. A backup tab is made first.
Clean data
Standardize Proper Case names, US phones with extensions, lowercase emails, and stray spaces.
Set up in about a minute
No formulas, no scripts. It lives in the Extensions menu of Google Sheets.
Pick the match columns
Name, email, phone, or any mix. SheetDupes suggests Text, Email or Phone from your headers, and you can change the type.
Preview or highlight
See the groups, then highlight duplicates if you want a visual pass. Nothing is rewritten yet.
Remove, merge, or standardize
A backup tab is copied first. Sheets with formulas are refused, so nothing in a formula cell is lost.
Everything you need to clean a sheet
Focused on duplicates and tidy values, in the file you already use.
- Find and preview duplicates for free, always
- Highlight duplicates without changing values, also free on any size sheet
- Exact and fuzzy match, including near-names like Jon / John
- Per-column types: Text, Email, or Phone
- Gmail folding for dots, +tags and googlemail.com, only when you turn it on
- US phone matching across common formats
- Compare two tabs in the same spreadsheet, for example to drop unsubscribes
- Backup tab first before Remove, merge or Standardize
- 14-day free trial, then writes stay available on sheets with up to 500 data rows
Why SheetDupes
Built for people who want a careful cleanup, not a suite of 40 tools.
| SheetDupes | Built-in Remove duplicates | |
|---|---|---|
| Find and preview first | Preview groups before you change anything | Removes in place once you confirm |
| Highlight duplicates | Shade extras without rewriting values | Not a highlight pass |
| Fuzzy and format folding | Typos, Gmail dots/+tags, US phone formats | Exact values only |
| Compare two tabs | Same spreadsheet, active tab only is changed | One range at a time |
| Where your data goes | Stays in your Google account | Stays in your Google account |
Private by design
SheetDupes runs inside Google Apps Script, in your own Google account, and only in the spreadsheet you have open. Your rows stay in Google. They are never copied to Loomwise servers, and nobody at Loomwise can read them.
It does not request access to your Drive, to other spreadsheets, or to Gmail. The only thing our license service will receive, once paid plans are on, is your Google account email, to know whether your trial or plan is active.
Questions
How do I remove duplicates in Google Sheets with SheetDupes?
Open the spreadsheet, choose Extensions → SheetDupes → Open SheetDupes, pick the columns to match on, run Preview, then Remove or merge. A backup tab is made first.
Can I find and highlight duplicates without deleting anything?
Yes. Preview finds duplicates and shows sample groups. Highlight shades the extra rows and leaves every value as it is. Both stay free on any size sheet.
What happens when the trial ends?
Preview and Highlight still work on any size sheet. Remove, merge, Standardize and compare-Remove still work on sheets with up to 500 data rows. For larger write jobs, email hello@loomwise.app for early access to a paid plan.
Does it work on two tabs, like a contacts list and an unsubscribe list?
Yes. Compare looks at another tab in the same spreadsheet and can preview, highlight, or remove rows that appear in both (or only here). Only the tab you are on is changed.
Will it overwrite formulas?
No. Remove, merge and Standardize refuse a sheet that contains formulas, so those cells are not rewritten. Use Highlight instead, or paste values first if you really want a rewrite.
Start with the sheet you already have.
A 14-day free trial, no credit card, and a free tier after that for Preview, Highlight, and writes on sheets with up to 500 data rows.
Email hello@loomwise.app for early access