Find Duplicate Rows

Find Duplicate Rows finds rows with the same values in the columns you choose. You review the results first, then highlight, delete, mark, or export them.

How to use Find Duplicate Rows#

1. Open the tool

Open the sidebar from Extensions > Text To Table Converter > ⚡ Launch Sidebar. On the home screen, under Sheets tools, choose Sheets Mega Tools, then choose Find Duplicate Rows.

You can also use Extensions > Text To Table Converter > Sheets Mega Tools to open the Sheets Mega Tools screen directly.

2. Choose the range
   • Selection
   • Current Sheet (default)
   • All Sheets: every sheet is scanned, but each sheet is checked on its own. Rows are never compared across sheets.

3. Set the options

Open the arrow next to Find Duplicates:

• Find: Duplicates (default) or Unique
• Columns to check: all columns by default. Click a column to include or exclude it. The refresh button (Refresh column names) reloads the column names from the first row.
• Data has headers: on by default
• Ignore empty rows: on by default
• Trim whitespace: on by default
• Case-sensitive: off by default

4. Click Find Duplicates

5. Review the results

Above the list you see the statistics: Total duplicates, Groups, Largest group, and Avg group size.

• Switch the view between List and Groups.
• Use Show results to filter: Except First, Except Last, or All Duplicates (default). "Except First" hides the first row of each group so only the extra copies are selected.
• Use Select all or Select none, or check rows one by one.
• Click a row to jump to it in the sheet.

6. Choose an action

The actions work on the selected rows.

Actions#

• Highlight selected: choose Single or Multi-color (default). Multi-color gives each group its own color between a min and max color.
• Delete selected: deletes the selected rows. Create backup saves a backup sheet first. You must confirm, and the deletion cannot be undone.
• Mark status: writes "Duplicate Row N" in a status column next to each selected row. Enable numbering adds the number. Under Column position choose Auto or Fixed column and enter the column letter or number.
• Export to CSV: export the Selected rows or All results. Include group IDs is on by default.

Limits#

A run scans up to 100,000 cells and returns up to 2,000 results.

Use Cases#

• Review duplicates before deleting anything
• Check specific columns, such as email and date, for repeats
• Mark duplicates so a teammate can review them
• Export a list of duplicates