Quick Delete Duplicate Rows

The Quick Delete Duplicate Rows tool is a streamlined duplicate-row remover for your current selection with minimal options. It provides a fast path to clean your data without the full feature set of the “Find Duplicate Rows” tool.

---

How to Use Quick Delete Duplicate Rows

1. Select a range Select the range of cells containing the rows you want to clean. This tool works only with your current selection (no sheet or all-sheets scope options).

2. Open the Quick Delete panel Navigate through the Google Workspace™ menu: Extensions > Text To Table Converter > Mega Tools > Quick Delete Duplicate Rows.

3. Configure options (optional) The panel offers simple toggles:

   • Keep first occurrence (default: on) - Preserves the first instance of each duplicate row
   • Create backup sheet (default: off) - Creates a backup sheet before deletion

4. Execute deletion Click the “Execute” button to delete duplicate rows immediately.

5. View status message A status message shows:

   • Number of rows deleted
   • Backup sheet information (if created)

---

Key Features

• Fast and simple - Streamlined interface for quick data cleaning
• Current selection only - Works with your selected range (no complex scope options)
• Safe deletion - Option to keep first occurrence and create backup
• Immediate execution - No find-first step; deletes duplicates directly

Astuce

This tool is perfect when you know you want to remove duplicates from a specific range and don’t need the advanced options available in “Find Duplicate Rows”.

Data Safety

Consider enabling “Create backup sheet” before executing, especially for important data. The backup will be created automatically before any rows are deleted.

---

When to Use Quick Delete vs. Find and Manage

Use Quick Delete Duplicate Rows when:

• You want to quickly clean a specific selection
• You don’t need to review duplicates before deleting
• You’re working with a small to medium range
• You want a simple, one-click solution

Use Find Duplicate Rows when:

• You need to review duplicates before deleting
• You want to highlight or mark duplicates first
• You need advanced options (selecting specific columns, finding unique rows)
• You want to work across multiple sheets

---

Use Cases

• Quick data cleanup - Remove duplicates from imported data
• Preparing data for analysis - Clean datasets before pivot tables or charts
• Database preparation - Ensure unique records before import
• Report cleanup - Remove accidental duplicate entries

---

Note

This tool is part of the Mega Tools suite, available exclusively in Google Sheets™. It uses the same backend as “Find Duplicate Rows” but provides a simplified, faster workflow.