Help & Support
Send Feedback
Power Tools
A set of quick solutions for daily tasks in Google Sheets: change case, sum values by color, remove duplicates and extra characters, split text to columns by delimiters or position, and many more.
466,335 users
Works with
Power Tools add-on cuts the clicks on repeated tasks and brings features for  organizing and unifying data in Google Sheets. 

Extra spaces, formulas and data in the wrong format are among many of the issues the add-on deals with:
 - Take advantage of the new smart toolbar with handy assistants: change case, flip values, calculations based on color, unpivot table, unmerge all cells on the sheet in a click.
 - Click once to AutoSum numbers in every row or column; sum and count cells by color.
 - Search all selected sheets for certain values, formulas, notes, and hyperlinks; see a list of found entries, export or replace them in a click.
 - Get "Text to columns" feature: split values in a column by any delimiter,  string, or by position.
 - Automate some routine tasks: add or remove text by position, transform formulas, change formula reference type, export range to XML or JSON.
 - Bring order to your sheet: delete unwanted characters, types of data, and clean up formatting.
 - Get every needed data tool in one place: remove duplicates or bring them to one row, compare and merge sheets, randomize data, and much more.

The add-on keeps history of the recent operations at hand so that you can quickly re-apply a set of actions to a different range. You can also star the most frequent features to have access to your favorites at any time.

When you import data from different sources or share the same spreadsheet with colleagues, it becomes critical to bring it in order in the shortest time possible. Even such simple tasks as deleting all notes from your sheet can waste a lot of time. Power Tools helps you do this in a click. Here is a full list of tasks it performs:

➊ Smart toolbar offers a set of one-click actions
- Advanced find and replace in all selected sheets
- Auto calculations for all numbers in columns or rows
- Sum, Count and other functions by fill and text color
- Flip values in adjacent cells, rows, or columns with or without their format
- Change case
- Freeze or unfreeze top rows and left columns
- Unpivot table
- Unmerge selected or all cells on the sheet

Main tool sets group solutions by type:

➋ Dedupe and Compare data
- Identify duplicate records in any combination of columns on your sheet
- Compare two columns or sheets to find duplicates
- Find and process duplicate cells

➌ Merge and Combine sheets
- Join values in rows, columns, or the entire range and keep cells unmerged 
- Merge sheets by a key column: update data in the main table with information from the lookup table
- Combine duplicate rows and merge unique data referring to the same record
- Combine data from multiple sheets into one

➍ Work with text
- Capitalize each cell or word, change case to uppercase or lowercase, toggle and polish text
- Add your text at the beginning or at the end of the selected cells, before or after certain text, or at any position you like
- Replace accented characters with non-accented, turn codes to symbols and back

➎ Remove unwanted data
- Delete leading and trailing spaces 
- Reduce spaces between words to one
- Remove html entities, non-printing characters, and delimiters
- Get rid of any character or string in the range
- Delete characters by position, or those that follow or precede certain text
- Remove empty or unused rows and columns

➏ Split tool set
- Separate values by any character or string
- Split text by position 
- Extract name parts into separate columns

➐ Randomize
- Shuffle values in rows, columns, or the entire range
- Generate random numbers, dates, booleans, custom lists, or strings

➑ Try out the formula tools
- Switch formula reference type from relative to absolute or vice versa
- Get values instead of the formulas
- Automatically add functions to all selected columns
- Apply new calculations to all formulas at once

❾ Clear data by type
- Erase any combination of data types from the selected range: formatting, numbers, dates, booleans, notes, text, or hyperlinks 

❿ Convert data format
- Convert text-formatted numbers and dates to numeric and date format
- Change number sign
- Export range to JSON or XML

We introduced yearly subscriptions, you can still enjoy a fully-functional trial version of the add-on for 30 days.

What's new?

New features:
  - Find duplicate or unique cells. You can find and process duplicate or unique cells within the selected range. Look for the feature “Remove duplicate cells” in the “Dedupe & Compare” group.
  - Unpivot table.
  - Find and replace: new type to look in - Errors. Now you can perform search in errors.
  - Text: Polish text. Single click and the add-on will delete extra spaces, add spaces after punctuation marks, and apply “Sentence case.” for all cells with text within the selected range.

  - Range selector UX. If you had slow Internet connection or server response, you could get an incorrect range. We've significantly reduced that possibility.
  - UX; the add-on will offer the most possible actions and warn about possible mistakes and lags. Special thanks to Chris Cobian for the idea about the default "Add to the end" action for unique columns in Merge Sheets.
  - Performance. The new version of the add-on processes colored cells faster.
  - Small screens and minor issues UIs.
  - UI for 4K monitors.
  - Randomize: random values generator.
  - Text: replaces Icelandic accented characters.
  - Split names: titles and suffixes detection. In many cases, they are recognized even if their position is incorrect.
  - Split names: new medical suffixes added.
  - Swap: renamed to Flip.

  - Removing Alternating colors.
  - Corrupting main table formatting.
  - Combine rows: the add-on was freezing without the data.
  - Combine sheets: modifying date format after combining.
  - Combine sheets: The message "The entered range is incorrect" kept showing even after the range was corrected.
  - Find and replace: the add-on didn't find links to the range.
  - Find and replace: if you were looking for hyperlinks only, the add-on showed cells with formulas too.
  - Merge sheets: processing cells with dates.
  - Flip: processed only top and bottom rows.
  - Text: replacing “ß", it is now replaced with “ss”.
  - Shuffle: was losing links.
  - Split names: some issues with suffixes.

New features:
  - Combine Sheets. It consolidates data from many spreadsheets into one. 
  - Unmerge cells. It unmerges all merged cells within a selection or on a whole sheet.
  - Change case: tOOGLE cASE

  - UI/UX.
  - Change case: “Capitalize each cell” has turned into a fully functional “Sentence case.”
  - Smart Toolbar.
  - Function by color.

  - Swap: cell format didn’t apply.
  - Find and replace: Server Error during the export of results.
  - Convert text to numbers didn’t work.
  - Split names: work after selecting an entire column
  - Minor bugs

New features:
  - Combine Rows. It combines duplicate rows, merges uniques and calculates subtotals.

  - Merge Sheets performance.
  - UI of Split by position.

  - “Capitalize Each Word” treated apostrophe as a word delimiter.
  - Remove Duplicates didn’t allow to use second column for comparison.
  - Merge Values converted colon to semicolon.
  - Error with “w”.

If you have any questions about the add-on, please post them here:
We'll be happy to assist!
A User of Power Tools
April 10, 2019
This is a paid app - I had it all set up for my Google sheets and now the functions won't work unless I pay for it. Can't Google sheets just include normal functions that Excel has? It's really made me think twice about using Google Drive.
Submit reply
A User of Power Tools
April 2, 2019
Worth every penny given the huge amount of time it saves me.
Submit reply
Douglas Fox
March 4, 2019
Yes, it costs to use but such indispensable extension that makes life so much easier that it is WELL worth every penny it costs!
Submit reply
J. Keith Maxwell
March 3, 2019
Hid the fact in Marketplace that this is a PAID app.
Submit reply
A User of Power Tools
November 3, 2018
Complete my Sheets kick Excel :)
Submit reply
Ankit Agrawal
October 3, 2017
Awesome App!
Submit reply
A User of Power Tools
March 23, 2017
I only downloaded this addon because it claimed to be able to sum and count by color. I tried using it and the function failed!!! You really should validate your functions before advertising your Power Tools
Submit reply
A User of Power Tools
March 17, 2017
I mainly use the Advanced Find and Replace, but I love it...although it now tells me every time I open it that an update is available here, but there is no instruction/button for updating it...
Submit reply
A User of Power Tools
March 12, 2017
Good, help alote. Can this add-on runs automatically when a certain cell is edited?
Submit reply
A user of Power Tools
April 3, 2017
Thank you for your feedback, Jacky! I'm sorry, but the add-on can't run automatically at the moment.
Robert Kalinowski
February 9, 2017
It looks great but I have a issue. Range of 7 cells, 1 red, 1 gray, 1 yellow and 4 clear (white). Count of yellow gives 1, count of white gives 4, but sum of count yellow and white gives ... 10! =COUNT(valuesByColor("#ffffff", "#000000", C13:I13)) + COUNT(valuesByColor("#ffe599", "#000000", C13:I13))
Submit reply
A user of Power Tools
March 6, 2017
Hello Robert, Thank you for your feedback. I'm sorry, but we haven't provided for a way to process more than one color at a time, so you need to enter one formula for each color you want to count. The only way to combine the results now is to have a master formula that will sum up the results by each color. We will consider embedding this possibility in one of the future versions of the add-on.
1-10 of 53
Additional information
Clear search
Close search
Google apps
Main menu