Power Tools is a set of 30+ smart features that you miss most in Google Sheets. The add-on not only reduces the number of mouse clicks on some routine operations in spreadsheets, but also offers solutions for common yet complex tedious tasks. Each tool here is designed to make data processing easy for you. Give the collection a try, and you will do the following without effort:
Your efficiency comes down to the time you spend on simple daily operations such as find and replace data, count or sum values by their color, change case, unpivot tables, unmerge and flip cells, freeze panes. Each button you'll find on the toolbar is there to cut down the clicks on these repetitive tasks.
From blanks to duplicates, Power Tools equips Google Sheets with simple ways to clear your data of any redundant values. The package includes 3 add-ons that remove duplicates and find unique records. Whether you're trying to compare two columns or tables, or scan one sheet, the tools process thousands of records in no time.
Forget about complex VLOOKUP or INDEX/MATCH functions with these 4 add-ons at your disposal. Quickly match and merge two tables, combine multiple sheets together, consolidate values from duplicate rows, or concatenate records from multiple cells. You won't lose the original data or column order and will be able to benefit from additional options.
Text constitutes an important part of each spreadsheet, and Power Tools will quickly make it look presentable. Use the add-on to normalize text in the entire selection and replace characters, symbols, and codes. Here you will find the solutions to deal with missing and excess spaces or add words to any position within a cell.
The tools in the Remove group instantly delete substrings and characters you specify before, after, or between the words in the selected cells. If any excess spaces crept in with your data, you will trim them all in a couple of mouse clicks as well. The Clear group, in its turn, will free your selection of any type of data.
Arranging values into columns the desired way can be a challenge. Power Tools provides clever instruments to split text in Google Sheets. There's no need to insert a column with formulas anymore: just select the values and pick standard delimiters or the place at which to pull them apart. If you work with lists of people's names, you’ll get them in separate columns of titles, salutations, and other units in a matter of seconds.
Ever needed to adjust lots of formulas in your spreadsheet? It's possible with Power Tools in one click. Convert your formulas to relatives, absolutes, or even to their values and add extra calculations to all of them at once. If incorrect formatting breaks your calculations as well, Power Tools will return your text-formatted numbers to their original state.
Two powerful add-ons from this group are irreplaceable when it comes to generating random strings of various data. Use your own lists of values or pick from predefined ones to create strong passwords or working shift plans. You can also shuffle existing records and entire rows or columns randomly.
This product is a HUGE time saver! It works flawlessly every time. Being able to merge rows, split and merge columns, etc. has saved me perhaps a week of work on a project. I highly recommend this for anyone who uses Google Sheets often.
This makes managing big data simpler than ever! Thanks team AbleBits!
Grateful for this intuitive tool! I use these features on a regular basis. Couldn't do my job without it.
If I added up the time this little add-on saves me and multiplied it by my hourly rate, It would be a very large number. Worth every penny and then some. It is kinda funny how painful some tasks are once you are aware of an easier way. HANDS DOWN, one of the most useful chrome extensions ever purchased.
Love this addon! for me this is by far the most used addon for sheets.
For me this add-on has saved me a ton of time I would have otherwise spent formatting spreadsheets & trying to make them look pretty
We love this program, customer service was great.
Very useful tool for crunching complex sets of data. I love it for bookkeeping and accounting type work. Export data as csv from QuickBooks, dump it into a Google Sheet, and put Power Tools to work to refine the data.
This has been a game changer for manipulating data and tables. Hoping that it keeps getting developed.
Amazing add-on. If you are a serious user of sheets, this will likely be of use to you.
Super helpful for combining rows of text data. Couldn't find anything else that met my needs the way this product does. Thanks.
I adore this addon. I use it every single day.
Excellent data preparation tool. I wrangle data almost all day every day. And the data sources are almost always a train wreck. This utility is a fantastic addition to tools like Tableau Prep. In addition, the staff are very helpful and responsive - they fixed a licensing glitch within a day.
The BEST !!
Great addition to power up Google Sheets
Extremely helpful instead of hacking together scripts for mundane tasks such as combining rows. Well made and easy to use.
Does what it should, without any problems - never has crashed on me ;-)
I couldn't do without this add on now that I have it. If you're doing a whole bunch of data and cleaning is part of the problem, you cannot do without this. More importantly, a whole bunch of text analysis that you would otherwise not put in excel because of the sheer effort, is regularly doable with Able bits.
So far, this has been a dream come true for changing text. I haven't pushed its limits in other areas, but it if you are using Sheets as a source for mail merges and form letters, this is a very useful tool.
Excellent addon. Very useful tool
Great add-on. Saves hours of time wrestling with obscure formulas. The split functions are great when someone sends you poorly formatted data.
as the name suggests they are Power Tools
Much needed tools for working in GS, thanks ablebits!
Awesome and very helpful
Extremely useful. I am very happy with it.
This add-on bring great tools to the hand of working in sheets!
Excellent collection. Without a rival!
Totally worth getting this plugin. I got the lifetime version since I knew this would be worth using for my lifetime. :)
I use this for EVERYTHING! Don't know how I would manage without.