跳到內容
Text To Table Converter

Mega Tools Overview

Mega Tools are a powerful suite of features designed specifically for Google Sheets™ to help you manage, analyze, and clean your spreadsheet data more efficiently.

What are Mega Tools?

Section titled “What are Mega Tools?”

Mega Tools provide essential functionality for spreadsheet and data work, organized into three main categories:

尋找和分析儲存格值

Tools to search, find, and analyze cell content:

  • Find Values in Cells - Search for values using regex or substring matching
  • Find Duplicate Cells - Identify duplicate values in your selection or sheet
  • Find duplicates within two columns - Compare two columns to find overlapping values
  • Sum by Color - Calculate sums grouped by cell background or text color

根據值格式化儲存格

Visualization and formatting tools:

  • 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

管理列和欄

Tools for row and column management:

  • Find Duplicate Rows - Identify and manage duplicate rows with advanced options
  • Find duplicate rows across selected sheets - Compare multiple sheets for duplicated rows
  • Sort by Color - Order rows using fill colors as the sort key
  • Combine Rows, Columns, or Cells - Merge cell content without losing data
  • Fill Blank Cells - Intelligently fill blanks using nearby patterns or defaults

These tools are available exclusively in Google Sheets™ when you open the Text To Table Converter add-on.

Standard Workflow

Section titled “Standard Workflow”

Most Mega Tools follow a find-first pattern:

  1. Select your scope - Choose whether to work with your current selection, the current sheet, or all sheets
  2. Configure options - Set up search criteria, comparison settings, or formatting preferences
  3. Run the find/search - Execute the primary action to identify matches
  4. Review results - View results in a table with checkboxes, locations, and type badges
  5. Apply actions - Select specific results and apply actions like highlighting, deleting, or formatting

Available Tools

Section titled “Available Tools”
Find Values in Cells Search for values via regex or substring, then highlight, replace, format, or copy matches.
Find Duplicate Cells Locate cells with duplicate values, with options for case sensitivity and whitespace trimming.
Find duplicates within two columns Compare two columns in the same sheet to flag duplicates between them.
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.
Find duplicate rows across selected sheets Compare multiple sheets to spot duplicated rows across tabs.
Sort by Color Sort the current selection using cell background colors.
Combine Rows, Columns, or Cells Merge cell content without losing data while keeping delimiters under control.
Fill Blank Cells Intelligently fill blanks using nearby patterns or defaults.