Google Sheets™ add-on for text cleaning and transformation - change text case, insert or strip characters, add prefix/suffix, extract emails, URLs, dates, and more - without leaving the sheet.
Listing updated:May 14, 2026
Works with:
67
Overview
Key Features

1. Case: Change capitalization and programmer-style naming in one click.

- Common options include:
  - Sentence case — capitalizes the start of sentences
  - Capitalized Case — first letter of each word uppercase
  - lower case and UPPER CASE
  - iNVERT cASE — swaps upper and lower case per character

- Advanced options include:
  - kebab-case, hyphen-case (word-style hyphenation), dot.case
  - camelCase, PascalCase
  - snake_case, SCREAMING_SNAKE_CASE, SCREAMING-KEBAB-CASE
  - AlTeRnAtInG cAsE


2. Insert: Add or inject text without using formulas.

- Add prefix — prepend text
- Add suffix — append text
- Add prefix and suffix — do both at once
- Insert at position — insert text at a specific 1-based index
  - Position 1 inserts before the first character
  - Use length + 1 to append at the end

3. Clean: Trim and filter characters with Unicode-aware rules where applicable.

- Whitespace options:
  - Trim start
  - Trim end
  - Trim both ends

- Keep or remove:
  - Keep alphanumeric only (letters and numbers)
  - Keep letters only
  - Keep digits only
  - Remove all digits

- Strip specific characters:
  - Remove every occurrence of selected characters (such as currency symbols or punctuation)

4. Extract: Find patterns in each cell and replace the content with extracted matches.

- Built-in presets:
  - Email addresses
  - URLs (http/https)
  - Phone numbers (flexible international formats)
  - #hashtags and @mentions (Unicode-friendly, may include values like #FF5733)
  - Dates — MM/DD/YYYY, DD-MM-YYYY, YYYY-MM-DD
  - 24-hour time — HH:MM with optional seconds

- Options:
  - Custom regex — apply your own pattern (global match)
  - Delimiter — choose how multiple matches are joined (default is newline)
  - Unique matches only — remove duplicates before joining
Additional information
PricingFree of charge
Developer
Non-trader
Privacy policy
Terms of service
Text Power Tools will ask for the permissions shown below. Learn more
Text Power Tools will need access to your Google account
This will allow Text Power Tools to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Chandini Mahalakshmi
May 14, 2026
I run into columns that are basically mini-essays, free-form notes crammed into a cell and I still need the emails, phone numbers, and URLs buried inside. The Extract tab is what I use instead of reading every line by hand. A few clicks and I’m done. The built-in presets have been reliable for me; I don’t spend time second-guessing them.
Is this review helpful?
Yes
No
Profile Picture
rohit mentee
May 14, 2026
Text Power Tools has simplified a lot of my day-to-day spreadsheet work. Instead of writing formulas, I can bulk edit selected cells to trim extra spaces, add prefixes and suffixes, fix capitalizations, case conversions exactly where I need it.
Is this review helpful?
Yes
No
1-2 of 2
Search
Clear search
Close search
Google apps
Main menu