Power Tools for Google Sheets
Your professional toolset for daily work with spreadsheet data
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:
- Find duplicates or uniques
- Change text case
- Count and sum by colors
- Match and merge data
- Combine duplicates
- Add text by position
- Find specific data
- Remove substring or characters
- Compare sheets
- Split text
- Modify formulas
- Randomize data
- Microsoft: Windows 7 and up
- Mac: Yosemite 10.10 and up
- Chrome, Firefox, Safari (Mac only)
Smart Toolbar
Quick features for the most common tasks
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.
- Advanced search in formulas, links, notes, errors
- Sum or count cells by their color
- Change text case
- Unpivot table
- Instant calculations with 12 functions
- Freeze top rows and left columns
- Flip range
- Unmerge selected cells
Compare and Dedupe
Get rid of duplicates or find uniques in your spreadsheets
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.
- Find duplicate or unique rows
- Find duplicate or unique cells within the range
- Compare 2 tables by selected columns
- Identify different rows between 2 tables
- Mark found records with color
- Identify results in a status column
- Clear found values or delete entire rows
- Copy or move results to a preferred location
Merge and Consolidate
4 different ways to combine your data
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.
- Match and merge records from two sheets
- Pull missing information from a lookup table
- Copy data from multiple spreadsheets into one
- Combine tables based on column headers
- Merge and combine values from multiple cells
- Set any delimiter for joined entries
- Combine duplicate rows
- Consolidate data from repeated rows
Text Tools
Manage text quick and easy
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.
- Change or toggle case
- Insert text by position
- Remove all extra spaces
- Polish entire text selection in one click
- Add lost spaces after punctuation marks
- Replace codes with symbols and vice versa
Remove and Clear
Eliminate all extra characters
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.
- Remove substrings or characters
- Eliminate chars by their position
- Remove extra spaces and delimiters
- Get rid of blank rows and columns
- Clear all text, numbers, and dates
- Delete links, notes, or formatting
Split Text
Divide one cell into multiple cells
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.
- Split data by any character, string, or by position
- Split names into separate columns
- Recognize name parts like first, last, middle names
- Separate titles, salutations, and name suffixes
Convert and Modify
Must-have tools for daily routine with formulas
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.
- AutoSUM, COUNT, etc. all selected columns or rows with 12 most common functions
- Modify formulas in multiple cells at once
- Convert formulas to values
- Convert relative cell references to absolute ones and vice versa
- Switch positive numbers to negative and back
- Export data to JSON or XML
Randomize Data
Generate values and change their order randomly
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.
- Generate random numbers and Booleans
- Fill the range with random dates
- Randomize values from your custom list
- Create strong passwords
- Shuffle all cells, rows, or columns
- Mix up cells in each row or column
Over 1,000,000 happy users!
Join us and lighten your work in Google Sheets with our clever add-ons
Power Tools components
Smart Toolbar
- Advanced Find and Replace
- Count and Sum by Color
- Change Case
- Freeze Panes
- Remove Blank Rows and Columns
Dedupe & Compare
Merge & Combine
Split
Process Data
Text Tools
- Remove Substrings
- Remove Excess Spaces
- Remove Characters by Position
- Split by Characters
- Split by Position
Clear
Randomize
Formulas
Convert
6 reasons to get Power Tools right now
Find out what other benefits you can enjoy
- More than 20 powerful tools Enjoy the time you spend in Google Sheets by using add-ons from Power Tools and making even the most challenging tasks easy.
- Work from multiple PCs Since the add-on works in Google Sheets, you can access it from any PC by simply logging in to your Google account.
- One license key for multiple accounts Order more than one subscription for your employees with volume discounts and get one license key to unlock the add-on for each user.
- Unconditional 30-day money-back guarantee If for some reason you decide to give up the add-on and turn your subscription off, just email us and we'll return your money.
- Free support Our customers always get quick and quality assistance on any type of question or issue, e.g. installation, licensing, or technical.
- Quick return on investment Multiple feedback from our users prove that Power Tools enhances productivity, saving you and your companies lots of time and money.
Professional service from the Ablebits team
Personal assistance from our friendly and knowledgeable Google Sheets experts
Ablebits Docs
Have a look at online help pagesSystem requirements
Operating Systems- Microsoft: Windows 7 and up
- Mac: Yosemite 10.10 and up
- Chrome OS™
Browsers- Chrome™
- Firefox
- Safari (Mac only)
