Power Tools: 30+ add-ons for Google Sheets

Power Tools is a collection of 30+ add-ons for Google Sheets. They help speed up most of your daily tasks, both complex and simple, enhancing your performance and saving your time. Get help with cleaning up and organizing data in your Google Sheets. Pick the group below to learn the tools it has to offer.

Start Power Tools

Start the add-on from Add-ons > Power Tools > Start or pick the tool group you need right from the menu:
Use Google Sheets menu to start the add-on.

Tip. You can make Power Tools open its sidebar in each spreadsheet automatically by pinning the button at its very bottom:
The button designed to auto-start Power Tools.
Please bear in mind that this doesn't open any specific add-on. It simply opens Power Tools so you could proceed with the desired add-on right away.
Tip. Select the range of cells you want to process in your sheet before running the add-on or any time before clicking any action button.

Choose the action

Power Tools: 30+ add-ons for Google Sheets.

  1. Smart Toolbar is a set of one-click tools for the most common tasks:
    • Advanced Find and Replace to search, substitute, or export values, formulas, notes, hyperlinks, and errors in any selected sheets.
    • Freeze to lock top rows and left columns in your tables.
    • Function by Color to sum, count, and calculate in other ways different cells based on their colors.
    • Calculate to quickly insert formulas with the most popular functions for multiple data ranges.
    • Change Case to switch between different capitalizations of the text.
    • Remove to get rid of all blank and/or unused rows and columns on the sheet.
    • Unpivot Table to transform your cross-tab table and get columns as row values instead.
    • Unmerge to divide combined cells into multiple separate cells.
    • Flip to exchange records between columns, rows, or cells.

    One-click utilities of the Smart Toolbar.

  2. Dedupe & Compare group contains add-ons that scan your data for duplicates, uniques, and their 1st occurrences. It's up to you to decide whether to color, remove, copy, or move what's been found. Use 5 add-ons to:

    Dedupe & Compare in Power Tools.

  3. Merge & Combine group is equipped with 5 utilities to bring data together:
    • Merge Values transfers values within rows, columns, or a range of cells and separates them with a delimiter of your choice.
    • Merge Sheets matches data in common columns of two spreadsheets and updates one table with the corresponding records from another.
    • Combine Duplicate Rows searches for duplicate entries in the columns you select, merges corresponding uniques and calculates subtotals.
    • Combine Sheets joins data from multiple sheets into one sheet preserving column headers.
    • Consolidate Sheets also joins data from multiple sheets into one but also calculates all numbers using the most common aggregate functions.

    Merge & Combine in Power Tools.

  4. Split data from one cell into multiple cells by delimiters, strings, or position. If you work with dates, use Split Date & Time to separate date and time units from one another. Split names to get each name part separately. Or split one sheet into multiple sheets by column values.

    Split in Power Tools.

  5. Process your data using 3 powerful one-step add-ons:

    Process data in Power Tools.

  6. With the Text group you can alter text in different ways:
    • Add text to cells by position.
    • Change case and replace special characters; polish all text by removing extra spaces, adding lost spaces after punctuation marks, and turning text into Sentence case — all in one click and with the help of the Modify tool.
    • Use the options from the Remove group to get rid of unwanted characters and their substrings, excess spaces and delimiters.
    • Split cells by different chars or positions.
    • Divide full names to its name units.
    • Text in Power Tools.

  7. The Clear tool will remove different types of values from your spreadsheet, from dates and notes, to formatting and hyperlinks. It also removes blank or unused rows and columns.
  8. Randomize features 2 helpful add-ons:
    • Random Generator to generate strong passwords or strings by mask or character sets, create lists of random dates and numbers, or use your own lists of values to mix up.
    • Shuffle to rearrange records in rows or columns in no particular order.

    Randomize in Power Tools.

  9. Tweak multiple formulas in your spreadsheet in a blink of an eye: convert relative cell references to absolute ones or even their values. Alter all selected formulas according to the pattern you set or auto apply 12 most common functions to all selected columns.
  10. Last but not least, you will convert text to numbers or dates, change the number sign, and export the data to JSON or XML formats.


I used power tools to create this formula: =COUNTA(valuesByColor("#ffffff", "#000000", '10121685 PENDING RELEASE'!V7:V12))

and it's definitely returning incorrect results. Can you please advise why?


Hello, Zandrea,
Thank you for reporting this problem to us.
Please email us to support@ablebits.com with the screenshot of your source data and the result you're getting.
We'll do our best to help.



On March 12, 2018, I paid my yearly subscription in full for USD $29.99 (reference Number: YK5GRV) and today (October 6, 2018), the Power Tools is asking me to either buy now or enter a key. Why?

What is going on?


Hello, Howard,
We've got your message in our support email inbox and will reply to it as soon as possible.
Thank you for your time and understanding.


Hi ,

We purchased a lifetime subscription on 05.24.18 but today, 11.09.18, we were told that our TRIAL period has expired and being prompted to purchase.

Please advise.


Hi, Lex,
So sorry to hear you've encountered this difficulty with the add-on.
We’ve got your email in our support Inbox and will answer it as soon as possible.
If you have any other questions regarding your orders, please send them to our support email: support@ablebits.com.

Thank you.

Nathan Merwitz says:
November 18, 2018 at 1:45 am

If I click the add-on tab, I can see the Help button on Power Tools, but I cannot see the Start button.

How do I see the Start button?


Hello, Nathan,

Thank you for contacting us. I'm sorry you are having a difficulty of this kind.

Reloading the spreadsheet should help and the "Start" option should appear in the menu.
If this doesn't help, please email us to support@ablebits.com with your browser version and operating system you use.

We'll do our best to assist you.


o power tools é pago? usei apenas uma vez.


Thank you for your question, Abner.

Our Power Tools offers a 30-day trial period. Once it expires, you are to either order a subscription or uninstall the add-on.
Should you have any other questions, feel free to contact us at support@ablebits.com.



I've just add on the Power Tools for testing with my Google Sheet. I need to remove the empty row but nothing happen. What should I do? Thanks


Hi Warang,

If you need to get rid of blank lines within the data, make sure to select the option Remove all empty rows.
In case you're trying to delete all blanks after your table, pick to Remove unused rows instead.

If nothing still helps, please send us the screenshot of your data to support@ablebits.com.
We'll do our best to help.

Alleyne Warner says:
February 13, 2019 at 11:43 pm

Hey guys,

Do you have something that will keep a Google Sheet sorted on a specific Column?

I'm seeing some formula stuff that does this but I'm lazy and want to point and click 🙂

Thanks in advance!



Hello Alleyne,

Unfortunately, we do not have such an add-on in our Power Tools. However, it looks like the standard Sort Range option available in Google Sheets or the =SORT function may be helpful.

Please let us know if there is anything we can help you with.


hello, I am having some problems merging sheets. i have been following the same instructions but when I changed the document only a few cells would be updated. I deleted all formulas, checked the content, deleted all duplicated but nothing worked. Any suggestions?


Hello Sarra,

Thank you for contacting us.

Since we need some details on the issue to be able to help you, our support team will email you shortly.
Thank you for your understanding.

Pete Fisher says:
May 17, 2019 at 2:22 pm

If I purchase a lifetime subscription and I have two Google accounts used for different personal business, can I use the same product key to activate Power Tools on both?

Katerina Bespalaya says:
May 17, 2019 at 2:54 pm

Hello Pete,

Thank you for your question.

Please note that each subscription is account-based, meaning it can be activated under one Google account at a time. If you want to use the add-on under two accounts, then you need to get two subscriptions. To obtain multiple subscriptions with one payment, simply change the number of required licenses on the purchase order page.

Alternatively, you can transfer the subscription from one account to another when it is necessary: https://www.ablebits.com/docs/gsuite-add-ons-licensing/#transfer-subscription

Please let us know if you have any other questions.


Hi ,

We purchased a lifetime subscription on 05.18.19 but today, we were told that our TRIAL period has expired and being prompted to purchase.

Please advise.


Hi Giang,

You see, there's an issue on the side of Google that occurs when you are logged in under more than one account. This may force the tool to lose your key. Unfortunately, we can't control or bypass this issue, so I kindly ask you to sign out and log back in only under the subscribed account.
Then please try to unlock the tool again using your activation key.

If this doesn't help, please email us to support@ablebits.com. Thank you.


Hello, is there a way to get Power Tools to run automatically when a new row of data is added?


Hello Amanda,

I'm afraid not.
All tools should be run each time you want to process the data. Some one-click operations (except the wizard-based add-ons from Merge & Combine, Dedupe & Compare, and Randomize) can be started quickly from the Recent/Favorite tools tabs at the bottom of Power Tools.


I need to generate 2500 unique 3 string uppercase alphanumeric codes. Can not duplicate even in a different order (example: M8V, V8M). Only using A-Z and 1-6. Is there a code for this? Thank you.


Thank you for your question, Melany.

Please have a look at our Random Generator add-on. Using it, you can generate random strings of different length and patterns. To set the pattern, you need to use the option called By mask. You'll find more details about it on this help page.


I see that I can mark my favorite actions with a star to have quick access to them in Favorite Tools bin at the bottom of the sidebar, but I don't know where I would add a star to do that. I also don't see any tools listed in the Recent Tools bin. How can I take advantage of those?


Hello Ben,
Thank you for your comment.

I'm sorry, but only simple one-step operations can be added to the list of Recent and Favorites tools. You see, merging sheets or removing duplicates, for example, involves 4 or 5 steps that have different settings depending on the spreadsheet where you run the add-on. Thus only one-click tools can be found in the Recent tools list where you can mark them with a star and add to your Favorites list.



Please inform me, if I can merge duplicates by last date inserted?



Hi Spela,

If you are interested in our Combine Duplicate Rows add-on, it merges duplicate rows by a key column(s). So if you have a column with the "last inserted" dates, you may choose it as one of your key columns and the tool will combine the rows based on these dates.

Please check out the tool's manual as well, I believe you'll find it helpful: https://www.ablebits.com/docs/google-sheets-combine-duplicate-rows/


Hey !

Your tool look great,
I need to do one thing,
Copy and paste a column to another one, but keep the original text of the second column and have the both text...
You can split...but join ???

merci !


Hi Stéphane,

Thank you for your comment. I've just replied to you via email. Please check your Inbox.

Sarah Vertrees says:
June 30, 2020 at 3:50 am

I thought this add-on would do freeze panes but I don't see it


Hello Sarah,

Power Tools indeed has the Freeze panes tool. You can run it by clicking the second icon on the smart toolbar at the top of the Power Tools pane: https://www.ablebits.com/docs/google-sheets-smart-toolbar/#freeze-rows-columns

If you have any questions or need further assistance, please let us know.


Want to be able to show other 2 R600,00 paid by client in rows under merge and combine. The Total is correctly calculated.

****** 30/05/2020
****** 02/06/2020
R800,00 20/07/2020
R600,00 29/07/2020 R2600,00


Hi Etienne,

I have just replied to you by email. Please check your Spam/Junk/Trash folders if you don't see it in your Inbox.

emerson hernandez says:
August 28, 2020 at 5:18 pm

quiero convertir de mayusculas a ninusculas y ya no me deja


Hello Emerson,

Thank you for your comment. Please describe the problem in more detail. If you get any error message, please take a screenshot and send it to support@ablebits.com


Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.