Power Tools for Google Sheets

A complete collection of tools for simpler work with spreadsheet data

Whenever you feel like you are wasting too much energy on monotonous repetitive work, you realize there must be a better solution. Power Tools takes the burden of such problems off your shoulders. Here you'll find the features you miss most.

  • One-click solutions for the most popular tasks: change case, sum by color, and more
  • Merge records, split text with the special tools you get
  • Delete duplicates and any redundant values
  • Discover plenty other time-savers that come with the add-on

Power Tools will streamline all the routine operations in spreadsheets, show your recent actions and keep a list of your favorites so that you can re-apply them to other cells at any time.

Learn how to work with the add-on.

These time-savers will let you manage Google Sheets data like a Pro

Quick fixes for common tasks in one toolbar

Count cells by color with one of quick solutions in the toolbar

Your efficiency comes down to the time you spend on simple daily operations: find and replace data, change case, insert and delete cells. Each button you’ll find in the toolbar is there to cut down the clicks on these common tasks.

Adding a couple of cells to a complex table takes lots of copying and pasting. Now you can effortlessly insert or delete cells and have the data shifted. Swapping values is just as easy.

Find data in any selected sheets

If you have a table of numbers, AutoSum is at your disposal: just click on the function to get calculations for each column. Right next to it is a particularly helpful tool if you color-code your data: sum or count cells by color.

One click on the case you need will capitalize words and respect your acronyms, or shift the selection to upper- or lowercase.

Freeze panes will keep the top rows and left colu mns visible as you scroll through your data.

The only tool that requires more than one click is advanced find and replace. You'll regain the time you take to set up the search criteria once you see a full list of matching records in all selected sheets and get the possibility to export or replace them.

Merge and split with all the tools you need

Split data to columns by characters, position, or name parts

Arranging values into columns the desired way can be a challenge. This add-on provides clever instruments to split text to columns and merge data back in Google Sheets.

You can split data by any characters, strings, or by position. No need to insert a column with formulas: just select the original values and pick standard delimiters, including a line break, strings, or the place at which to divide them. The results will be inserted in a click.

If you work with lists of people, you’ll appreciate the possibility to recognize name parts like first names and salutations and get them in separate columns in a matter of seconds. Split Names is a life-saver if your names are written in different formats.

Merge Values in its turn will join records within rows, columns, or the entire range, and add any delimiter between them. It is also capable of merging cells without losing data.

When you match and update records from two tables, try Merge Sheets that arranges the process into 5 straightforward steps. It allows you to use any columns to find the same records, choose values to update and add, color changes, and benefit from additional options.

Eliminate duplicates and extra characters

Remove any strings or characters in your cells

From blanks to duplicates, Power Tools equips Google Sheets with simple ways to clear your data of any redundant values.

Excess spaces that creep in with the imported data do not let you rely on the calculations you make. The tools in the Remove group instantly delete blanks before, after, or between the words, get rid of empty rows and columns, and erase any characters or strings from the selected cells.

Find duplicate rows in one sheet or compare columns in 5 simple steps

Eliminate any kind of data in the selection: links, notes, numbers, text, or formatting, with the help of Clear tools.

The Data group offers wizards to remove duplicates. Whether you are trying to compare columns or find dupllicate rows in one table, click through 5 simple steps to process thousands of records.

Must-have tools for daily routine

Get a set of helpful text tools for Google Sheets: change case, add text by position, and more

We always associate spreadsheets with numbers, and we tend to forget that numbers need descriptions. When these descriptions require changes, even commonplace adjustments can baffle us in Google Sheets.

Whenever you encounter a simple task of changing case or adding some text to all selected cells, you can find the solution in the Text group. Now you can attach a country code to all cells with phone numbers in one go.

When working in an international environment, you will find it handy to replace all accented letters with their equivalent from the Latin alphabet. If you encounter codes in your text, convert them with the Replace symbols tool.

Incorrect formatting can also be one of those pestering things that break the calculations. Open the "Convert" group to return number format to numbers that are stored as text in your cells, date format to dates, or change the number sign from negative to positive and back.

There is a tool for almost anything: modify formulas and cell references, convert range to XML or JSON, generate random numbers and shuffle data, create passwords, randomize values from your custom list, the number of problems you can solve with Power Tools is endless.

Power Tools - Google Sheets add-on

Screenshots

These time-savers will let you manage Google Sheets data like a Pro
Count cells by color with one of quick solutions in the toolbar
Find data in any selected sheets
Delete blanks in spreadsheets
Remove any strings or characters in your cells
Clear cells by type of data
Get a set of helpful text tools for Google Sheets: change case, add text by position, and more
One click to edit all formulas, convert them to values, AutoSum, and more
Split data to columns by characters, position, or name parts
Find duplicate rows in one sheet or compare columns in 5 simple steps

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish your message on our forum
 

Please remember that we work from 8am to 4pm GMT, this is 4:00am to 12:00pm EST,
1:00am to 9:00am PST, and our public holidays may differ from yours.

50+ professional tools for Excel to do your daily work
 
 
50+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard