Skip to content
Guides
Sheets Mega ToolsGoogle Workspace add-on

Text Case Transform

Change capitalization in Google Sheets™ with fixed rules: upper, lower, title, smart title, sentence, or proper case, with an ignore list for brands and IDs.

Text Case Transform changes capitalization in your selection or the current sheet using fixed rules. You can keep specific words, such as brand names or IDs, exactly as they are written.

How to use Text Case Transform#

  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 Text Case Transform.

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

  1. Choose the scope
    • Selection (default)
    • Current sheet
  1. Choose a case style
    • UPPERCASE: HELLO WORLD
    • lowercase: hello world
    • Title Case: Hello World
    • Smart Title Case: The Rise of AI (small words such as "of" and "the" stay lowercase unless they come first)
    • Sentence case: Hello world
    • Proper Case: Hello World
  1. Set the options
    • Ignore numbers: on by default
    • Trim whitespace: on by default
    • Ignore words (comma separated): for example iPhone, ID, USA

Cells that contain formulas are always skipped.

  1. Preview or apply
    • Preview changes lists the affected cells in a table with the columns Cell and New value. Click Apply preview to write them.
    • Quick apply changes the cells without a preview.

Any scope other than Selection shows a warning first. You can continue or cancel.

Tip: Use Preview changes before applying to a whole sheet.

Ignore words#

A word in the ignore list is left exactly as it is written in the cell. The tool does not apply the casing from your list. Matching ignores capitalization and matches whole words only.

With the ignore list iPhone, ID, USA, and the style Title Case:

CellWithout ignore wordsWith ignore words
iPhone 13 pro maxIphone 13 Pro MaxiPhone 13 Pro Max
customer ID is 12345Customer Id Is 12345Customer ID Is 12345
made in USAMade In UsaMade In USA
made in usaMade In UsaMade In usa

In the last row the cell has "usa" in lowercase, so it stays "usa". To keep a word in a certain casing, it must already be written that way in the cell.

Limits#

  • A run scans up to 100,000 cells and changes up to 2,000 cells. If more would change, narrow the range.
  • Only text is changed. Numbers and formulas are not touched.

Use Cases#

  • Standardize column headers
  • Clean inconsistent survey answers
  • Fix capitalization in pasted text
  • Keep brand names and acronyms intact with the ignore list

Looking for context-aware capitalization?: Smart Text Case uses AI to handle names, addresses, and product titles.