ysskrishna logoysskrishna

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

Back to 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.