Help & Support
Send Feedback
Power Tools
A set of 30+ solutions for daily tasks in Google Sheets.
2,740,247 users
Works with
If bringing your spreadsheets to order in the shortest time possible is your goal, Power Tools is a must-have. It cuts the clicks on repeated tasks and enhances your Google Sheets with features that organize and unify your data.

Among its add-ons you'll find those that remove duplicates, compare and vlookup sheets, import ranges from multiple sheets, merge cells, find and replace data, sum and count colored cells, generate numbers and other records. Text toolkit utilities are also included and let you change case, add and remove strings and characters, trim whitespaces, and split text to columns.

All the tools are divided into 10 different groups based on their main purpose:

➊ Smart toolbar offers some one-click actions. The main ones are:
- Advanced find and replace. Search in values, formulas, links, errors, and notes
- Sum and Count colored cells (other functions included)
- Change text case: capitalize first or all letters, apply sentence and lowercase, toggle text

Other toolbar instruments let you:
- Flip data
- (Un)freeze top rows and left columns
- Unpivot tables
- Unmerge all or selected cells
- Auto calculate all numbers

➋ Dedupe and Compare data:
- Find and remove duplicates in any combination of columns in your sheet
- Compare two columns or sheets to find duplicates
- Highlight duplicates or uniques, copy or move them to another location
- Identify dupes in a status column

➌ Merge and Combine sheets:
- Merge cells in rows, columns, or the entire range and keep all records
- Merge two Google sheets by key columns: vlookup data from another table, considering text case and ignoring blanks
- Combine duplicate rows and merge unique data referring to the same record
- Combine data from multiple sheets into one based on column headers

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

➎ Remove unwanted data:
- Get rid of any characters or strings in the range
- Remove line breaks, commas, and any characters or strings in the range
- Remove characters by position, or when they follow or precede certain text
- Delete leading and trailing spaces
- Reduce spaces between words to one
- Remove HTML entities, non-printing characters, and delimiters
- Delete all empty or unused rows and columns

➏ Split toolset:
- Separate values by any character or string
- Split text by position 
- Separate first and last name in Google Sheets, extract titles and other name parts into individual 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:
- Toggle between relative and absolute cell references
- Convert formulas to values
- Autosum columns and automatically add other functions to all selected columns
- Add new calculations to all Google Sheets formulas at once

➒ Clear contents in Google Sheets 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 Google Sheets range to JSON or XML

Power Tools keeps the history of the recent operations at hand so you could quickly re-apply actions to a different range. You can also favor the most frequent features to have access to them at any time. 
Or save the entire sets of options to find duplicates or merge two tables in a click.

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

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
January 24, 2020
It's Really Helpful tools
Submit reply
A User of Power Tools
January 20, 2020
Very easy to work with. I like it.
Submit reply
A User of Power Tools
January 19, 2020
Works as intended
Submit reply
A User of Power Tools
January 19, 2020
Superb to work with.....
Submit reply
A User of Power Tools
January 17, 2020
Thank you for the feedback to improve my Power Tools add-on! I LOOOOOVE this tool: It has made me more efficient! If you don't have it-- GET it!
Submit reply
A User of Power Tools
January 16, 2020
I use multiple features of this tool every week: changing case, merging cells, splitting cells, removing spaces. Thank you Power Tools for making my life easier!
Submit reply
A User of Power Tools
January 10, 2020
No sort by color feature
Submit reply
A user of Power Tools
January 13, 2020
Thank you very much for your feedback! Could you please describe your task in details? Do you have colour scales or all the different colours? How would you like to sort them: from the darkest to the lightest or any other particular order? The screenshots of your source data and the result you'd like to get would help a lot (use the Ablebits link at the top of this page to email us). Looking forward to hearing from you.
A User of Power Tools
December 30, 2019
I needed to be able to add cells by fill colour and this isn't available as standard with Google Sheets. This add on does the job perfectly and the support is fantastic. Well done Ablebits - you are great!! :)
Submit reply
A User of Power Tools
December 28, 2019
The De-duplicate function is buggy. Often does not work at all, especially when comparing two sheets.
Submit reply
A user of Power Tools
January 8, 2020
Hello, Thank you for your feedback. Please use the Ablebits link at the top of this page to email our support team with a sample of your data. We will investigate the problem. Thank you.
A User of Power Tools
December 27, 2019
Great tool, I use it all the time for deduping.
Submit reply
1-10 of 102
Additional information
Clear search
Close search
Google apps
Main menu