SheetSweep is a Google Sheets add-on that finds duplicate rows in the
spreadsheet you open, shows a preview before anything changes, creates a
backup tab, then removes the duplicates — or moves them to a Review tab.
SheetSweep helps people clean messy Google Sheets by removing duplicate
rows safely. You choose which columns define a unique row, preview how many
duplicates will be removed, and SheetSweep always creates a backup tab
before cleaning. It only works in the spreadsheet you currently have open
and does not store your sheet data on a separate server.
Find duplicate rows by the columns you select
Preview counts before any change
Automatic backup tab, then clean or move duplicates to Review
Limited access: only the open spreadsheet + add-on UI
How it works
One clear job. No formulas. No suite. Free for sheets up to 5,000 data rows.
Pick columnsChoose what makes a row unique — or keep all columns selected.
PreviewSee duplicate counts before anything changes.
CleanWe create a backup tab first, then remove the duplicates.
