Skip to content
Guides
Sheets Mega ToolsGoogle Workspace add-onGoogle Sheets

Sheets Mega Tools Overview

Sheets Mega Tools is a set of Google Sheets™ sidebar tools for finding values, cleaning duplicates, fixing capitalization, heatmaps, and sorting by color.

Sheets Mega Tools is a set of Google Sheets™ sidebar tools for finding, cleaning, formatting, and reviewing spreadsheet data in bulk.

Open Sheets Mega Tools#

  1. In Google Sheets™, choose Extensions > Text To Table Converter > ⚡ Launch Sidebar.
  2. On the home screen, under Sheets tools, choose Sheets Mega Tools.
  3. Choose a tool from the list.

You can also choose Extensions > Text To Table Converter > Sheets Mega Tools to open the same list directly.

There are no tabs to switch. The list groups the tools under three headings:

Cell Values

  • Find Values in Cells: search for values, formulas, notes, links, or errors, then highlight, replace, format, delete rows, or copy the matches.
  • Find Duplicate Cells: find duplicate or unique cell values.
  • Sum by Color: total numbers grouped by cell background or text color.

Cell Formatting

  • Cell Value Heatmap: color numeric cells on a gradient from lowest to highest.
  • Text Case Transform: change capitalization with fixed rules.
  • Smart Text Case ✨: AI-assisted capitalization for names, addresses, and product titles.

Rows & Columns

  • Find Duplicate Rows: find duplicate rows, then highlight, delete, mark, or export them.
  • Quick Delete Duplicate Rows: preview and delete duplicate rows with minimal setup.
  • Sort by Color: order rows by background or text color.

These tools are available only in Google Sheets™.

Text To Table Converter

Get the Add-On - Free

Text To Table Converter

Ready to Get Started?: Install Text To Table Converter to use Sheets Mega Tools and the rest of the add-on.

Install free

Standard Workflow#

  1. Open the tool you want from the Sheets Mega Tools list.
  2. Select the range on the sheet if the tool works on a selection.
  3. Set the options.
  4. Run the tool, review the results or preview, then apply an action if the tool offers one.

Tip: Try a tool on a copy of your sheet and a small selection first. Use the preview before any delete.

Scope and Safety#

  • Selection is the most predictable scope.
  • Current sheet runs on the whole active sheet.
  • All sheets (where offered) scans every sheet, but it checks each sheet on its own. Duplicates are never matched between different sheets.
  • Delete actions ask you to confirm because they cannot be undone. Use Create backup where it is offered.

Limits#

  • Each run scans up to 100,000 cells.
  • Find Values in Cells, Find Duplicate Cells, and the duplicate-row tools stop at 2,000 results, and Text Case Transform stops at 2,000 changed cells. Narrow the range if you hit a limit.
  • Smart Text Case handles up to 500 text cells per run.
  • Cell Value Heatmap handles up to 50,000 numeric cells.

Warnings#

A warning appears before a run only in these cases:

  • Find Duplicate Cells when you scan the whole current sheet or all sheets.
  • Text Case Transform with any scope other than Selection.
  • Sum by Color on more than 10,000 cells.
  • Any delete, which asks for confirmation.

Other tools do not warn. They simply stop with an error if the range is too large.

Recommended First Steps#

  1. Try Find Values in Cells first to learn the results and actions 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. Move to whole-sheet scopes once small runs behave as you expect.

Available Tools#

Related Sheets Tool#

  • Chart Wizard - Select a table and get recommended charts. It opens from the same Sheets tools list.
Google Sheets™

Google Sheets™ Only

Sheets Mega Tools is available only in Google Sheets™.