ysskrishna logoysskrishna

Text Power Tools for Google Sheets: Clean, Change Case and Extract Text

Fix messy text in Google Sheets without formulas: trim spaces, change case and naming styles, add prefixes, and extract emails, URLs, phones and dates.

7 chapters · about 21 min · free

Google Sheets Text Power Tools
Google Sheets
Google Workspace Add-ons

Who it is for: Anyone who cleans imported or pasted data in Google Sheets: ops, marketing, sales ops, analysts and developers preparing data for an import.

What you will learn

  • Diagnose the common kinds of messy sheet text and pick the right fix
  • Trim, filter and strip characters across a whole range in one step
  • Change case and convert to programmer naming styles such as snake_case and camelCase
  • Add prefixes, suffixes or text at a position without helper formulas
  • Extract emails, URLs, phone numbers, hashtags, dates and times from free text
  • Write a custom regex for patterns the presets do not cover
  • Run a safe, repeatable clean-up on a real export

Before you start

  • A Google account with Google Sheets
  • Text Power Tools installed from the Google Workspace Marketplace (free)
  • Optional: the Text Power Tools - Examples Workbook to practise on

Chapters

  1. 01Why sheet text gets messy, and how to fix it safely3 min
  2. 02Trim and clean: spaces, digits and unwanted characters3 min
  3. 03Change case and naming styles3 min
  4. 04Add prefixes, suffixes and text at a position3 min
  5. 05Extract emails, URLs, phone numbers and dates3 min
  6. 06Custom regex extraction3 min
  7. 07Recipe: clean a CRM export in ten minutes3 min

Start the course

Frequently asked questions

Is Text Power Tools free?

Yes. The Google Workspace Marketplace listing shows it as free of charge.

How do I open Text Power Tools in Google Sheets?

After installing it from the Marketplace, open Text Power Tools → Start from the Sheets menu (add-ons usually sit under Extensions). The sidebar opens with four tabs: Case, Insert, Clean and Extract.

Does it change my original data?

Yes. It rewrites the selected cells in place; Extract replaces each cell with the matches it found. Duplicate the tab or copy the column first, and use Undo if a change is wrong.

How do I remove extra spaces in Google Sheets?

Select the cells, open the Clean tab and choose Trim both, then Apply. Trimming removes spaces at the start and end; to collapse double spaces inside text, use Find and replace with a regular expression or the TRIM formula.

Can I convert column headers to snake_case or camelCase?

Yes. The Case tab's Advanced group includes snake_case, camelCase, PascalCase, kebab-case, dot.case, SCREAMING_SNAKE_CASE and more. Clean punctuation and spaces first for tidy results.

How do I add the same prefix to many cells?

Select the cells, open Insert, choose Add prefix, type the text and click Apply. Add suffix, Add prefix and suffix, and Insert at position (1-based) are in the same dropdown.

How do I extract email addresses from text in Google Sheets?

Copy the text column, select the copy, open Extract, choose Email addresses, optionally set a delimiter and Unique matches only, then Apply. Each cell is replaced by the emails found in it.

Can I use my own regular expression?

Yes. Choose Custom regex in Extract. It is a global match, so every match in a cell is returned and joined with the delimiter.

Why did my phone numbers lose their leading zero?

After Keep digits only, Sheets may treat the result as a number. Format the column as Plain text before cleaning.

Is there a sample sheet to practise on?

Yes, the add-on's posts reference a Text Power Tools - Examples Workbook. Practise there or on a duplicated tab before cleaning real data.

Open the FAQ page

Continue exploring

ProductGoogle WorkspaceGoogle Sheets Text Power Tools

Google Sheets Text Power Tools

Fix messy sheet text in place. Case, trim, strip, and extract without leaving the grid.
Google Sheets Text Power Tools
Text & Data Conversion
Google Workspace Add-ons
Google Sheets
ProductGoogle WorkspaceGoogle Sheets Tab Manager

Google Sheets Tab Manager

Your workbook outgrew the tab bar. Clean it up in batches.
Google Sheets Tab Manager
Google Workspace Add-ons
Google Sheets
Google Apps Script
CourseCover image for Table Converter for Google Sheets: Import and Export Markdown, JSON, HTML and CSV

Table Converter for Google Sheets: Import and Export Markdown, JSON, HTML and CSV

Import Markdown, JSON, HTML and CSV tables into Google Sheets without broken columns, and export any range as clean Markdown, JSON, HTML or CSV.

Google Sheets Table Converter
Google Sheets
+1

6 chapters · 16 min

BlogCover image for How to Delete Multiple Tabs in Google Sheets at Once (Bulk Hide, Rename, Sort)

How to Delete Multiple Tabs in Google Sheets at Once (Bulk Hide, Rename, Sort)

Google Sheets Tab Manager
Google Workspace Add-ons
+1
2 min read
ProductGoogle WorkspaceGoogle Sheets Merge Tools

Google Sheets Merge Tools

Repeatable merges in Google Sheets, without the misclick marathon.
Google Sheets Merge Tools
Google Workspace Add-ons
Google Sheets
Google Apps Script
CourseCover image for Sheets Tab Manager: Delete, Hide, Rename, Colour and Sort Tabs in Bulk

Sheets Tab Manager: Delete, Hide, Rename, Colour and Sort Tabs in Bulk

Delete multiple tabs in Google Sheets at once, hide and unhide in bulk, rename with find and replace, colour and sort tabs A–Z with the free Sheets Tab Manager.

Google Sheets Tab Manager
Google Sheets
+1

6 chapters · 24 min