Sheets Mega Tools Overview for Google Sheets™

Sheets Mega Tools is a Google Sheets™ workspace for finding, cleaning, formatting, and reviewing spreadsheet data in bulk.

What are Sheets Mega Tools?

Open Sheets Mega Tools from the add-on sidebar, or use the Sheets Mega Tools menu shortcut to open the same sidebar section.

The tools are grouped into three tabs:

Find and analyze cell values

###

Find and analyze cell values

Tools in Cell Values:

• Find Values in Cells - Search for values, formulas, notes, links, or errors
• Find Duplicate Cells - Identify duplicate values in your selection or sheet
• Sum by Color - Calculate sums grouped by cell background or text color

Format cells based on their values

###

Format cells based on their values

Tools in Cell Formatting:

• Cell Value Heatmap - Apply color gradients to visualize data patterns
• Text Case Transform - Normalize or smart-capitalize text based on value rules
• Smart Text Case ✨ - AI-powered, context-aware capitalization

Manage rows and columns

###

Manage rows and columns

Tools in Rows & Columns:

• Find Duplicate Rows - Identify and manage duplicate rows with advanced options
• Quick Delete Duplicate Rows - Preview and remove duplicate rows with minimal setup
• Sort by Color - Order rows using fill colors as the sort key

These tools are available only in Google Sheets™.

Get the Add-On - Free

Text To Table Converter

Ready to Get Started?: Install Text To Table Converter to unlock Sheets Mega Tools and all other powerful features.

Install free

Standard Workflow

Most Sheets Mega Tools follow a simple sidebar workflow:

1. Open Google Sheets™ and open the add-on sidebar
2. Expand `Sheets Mega Tools`
3. Choose a tab: Cell Values, Cell Formatting, or Rows & Columns
4. Open the tool you want to use
5. Configure the tool options
6. Run the tool and review the result before your next action

Scope and Safety

• Use Selection when you want the safest and most predictable scope.
• Use Current sheet when the whole active sheet is your target.
• Use All sheets only when you intentionally want workbook-wide processing.
• Prefer preview-driven workflows before deleting rows, clearing values, or applying large text-case changes.
• Use backup options before destructive actions when the tool offers them.

Recommended First Steps

1. Try Find Values in Cells first to understand the panel and results workflow.
2. Use Text Case Transform on a small selection and review the preview.
3. Use Find Duplicate Rows before Quick Delete Duplicate Rows when you want more control.
4. Use workbook-wide scopes only after you are comfortable with smaller runs.

Available Tools

• Find Values in Cells - Search for values, formulas, notes, links, or errors, then highlight, replace, format, delete rows, or copy matches.

• Find Duplicate Cells - Locate cells with duplicate values, with options for case sensitivity and whitespace trimming.

• Sum by Color - Calculate sums grouped by cell background or text color, with results displayed in the sidebar.

• Cell Value Heatmap - Visualize data patterns by applying color gradients to cell values based on their numeric or text content.

• Text Case Transform - Normalize capitalization across your selection with smart sentence and proper case options.

• Smart Text Case ✨ - AI-powered, context-aware capitalization for names, addresses, and messy input.

• Find Duplicate Rows - Identify rows with identical data across multiple columns, then highlight, delete, or mark them.

• Quick Delete Duplicate Rows - Preview duplicate-row cleanup for a selected range, then delete duplicates only after the preview looks correct.

• Sort by Color - Sort the current selection using cell background colors.

Google Sheets™ Only

Sheets Mega Tools is available only in Google Sheets™.