Smart Text Case ✨

Smart Text Case is a separate Sheets Mega Tools tool that uses AI to fix capitalization based on context. It knows patterns such as McDonald and O'Malley, keeps acronyms like CEO, and repairs text typed with caps lock on. It changes capitalization only. It does not rewrite or abbreviate words.

Before you start#

• Smart Text Case uses AI. In Settings, set AI Permission to Allow.
• Every batch of up to 50 cells counts as 1 AI request. The free plan includes 25 AI requests every 30 days. Pro has no AI request limit.

How to use Smart Text Case#

1. Select the cells on your sheet

The tool works on your current selection.

2. 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 Smart Text Case ✨.

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

3. Choose the data type

Use the What kind of data is this? dropdown:

• Auto-Detect (default)
• People Names
• Addresses
• Product Titles
• Sloppy User Input

4. Set Ignore numbers

Ignore numbers is checked by default.

5. Click Analyze & Preview

The tool shows "Analyzing N rows with AI..." while it works.

6. Review the preview

The table lists each cell address, and its New Value. There are no per-row checkboxes.

7. Click Quick Apply

The suggested capitalization is written to the cells.

Data types#

Auto-Detect#

The AI picks the best approach from the content. Use it for mixed data.

People Names#

Handles patterns that fixed rules miss.

• "leonardo dicaprio" becomes "Leonardo DiCaprio"
• "sean o'malley" becomes "Sean O'Malley"
• "ronald mcdonald" becomes "Ronald McDonald"

Addresses#

Fixes capitalization in addresses.

• "123 n. main st, apt 4" becomes "123 N. Main St, Apt 4"

Only capitalization changes. Smart Text Case will not turn "avenue" into "Ave" or expand "st" to "Street".

Product Titles#

Keeps brand names and units in their usual form.

• "iphone 13 pro max 256gb" becomes "iPhone 13 Pro Max 256GB"
• "samsung galaxy s23 ultra black" becomes "Samsung Galaxy S23 Ultra Black"

Sloppy User Input#

Repairs caps lock and random mixed case.

• "tHANKS fOR yOUR hELP" becomes "Thanks for your help"
• "PLEASE SEND THE REPORT" becomes "Please send the report"

Limits#

• Up to 500 text cells per run. More stops with "Smart Text Case supports up to 500 text cells at a time."
• Up to 100,000 characters of text per run. More stops with an error.
• No warning appears before a run. Errors appear if a limit is exceeded.

Rules-based vs AI#

If you want predictable, rule-based results with your own exception list, use Text Case Transform.