Power Tools for Google Sheets
Your professional toolset for daily work with spreadsheet data
Power Tools is a set of 40+ 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 duplicate rows
- Add text by position
- Remove substrings or characters
- Extract text, numbers, links
- Find and replace specific data
- Split sheets, date & time, text
- Compare sheets
- Filter and extract data
- Randomize data
- Fill blank cells
- Remove extra spaces
- Remove blanks & shift data
- Microsoft: Windows 10 and up
- MacOS: Catalina 10.15.7 and up
- Chrome OS™
- Chrome, Firefox, Safari (Mac only)
Smart Toolbar
Quick features for the most common tasks
Spend less time on such daily operations as find and replace data; copy or delete sheets; count, sum or sort cells by color; change case; remove empty cells, rows or columns; unpivot tables; unmerge and flip cells; freeze panes. Each button on the toolbar will reduce the clicks on these repetitive tasks.
- Advanced search in formulas, links, notes, errors
- Copy, delete, reorder, protect, hide sheets
- Sum, count, sort cells by their colors
- Change text case
- Flip ranges
- Delete blank cells, rows, columns
- Instant calculations with 12 functions
- Freeze top rows and left columns
- Unmerge selected cells
- Unpivot tables
Compare and Dedupe
Get rid of duplicates or find uniques in your spreadsheets
Power Tools offers 7 add-ons that remove duplicates and find unique records in your spreadsheets. Whether you're trying to compare columns or sheets, or deduplicate one table, the tools process thousands of records in no time.
- Find duplicate or unique rows
- Find duplicates automatically – on schedule
- Compare 2 columns
- Compare sheets for duplicates
- Identify differences between your tables
- Highlight duplicates
- Mark results in a status column
- Get the results in a comparison report
- Clear found values or delete entire rows
- Copy or move results to a preferred location
Merge and Consolidate
5 different ways to combine your data
Forget about complex VLOOKUP or INDEX-MATCH functions with these 5 add-ons at your disposal. Quickly match and merge Google sheets, combine multiple sheets by column columns, consolidate multiple sheets, combine duplicate rows, or concatenate records from numerous cells. You'll lose neither the original data nor column order and will benefit from additional options.
- Match and merge records
- Pull missing info from lookup tables
- Save options to scenarios to merge automatically
- Combine tables based on column headers
- Copy data using a formula to auto-update results
- Join values from multiple cells
- Set any delimiter for joined entries
- Combine duplicate rows
- Consolidate data from repeated rows
- Add up records by label or position
Text Tools
Edit text quick and easy
Text is essential to each Google sheet, and Power Tools will make it look presentable. Effortlessly clean, format, and adjust text across your sheets. You will find solutions to deal with excess spaces or add words to any position within a cell.
- Change or toggle case
- Insert text by position
- Remove all extra spaces
- Add lost spaces after punctuation marks
- Polish entire text selection in one click
- Split names
- Split cells by characters or position
- Replace multiple substrings
- Replace codes with symbols and vice versa
- Extract text, numbers, links, email addresses
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 excess spaces creep in with your data, you will trim them all in a few mouse clicks. The Clear group, in its turn, will free your selection of blanks and specific types 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, dates, links, etc.
- Remove empty cells and shift data
Split Data
Divide one cell or sheet into multiple cells or sheets
These clever instruments will split both text and Google sheets. There's no need for formulas anymore: just select the values and pick delimiters or a place at which to pull them apart. Or have date and time units pulled from full Date time records. As for lists of people's names, you’ll get them in separate columns of titles, salutations, and other units. As well as have one Google sheet divided into multiple tables by columns or by rows.
- 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
- Split sheet by values in common columns
- Split Google sheet by any number of rows
- Divide 'Date time' values to 'date' and 'time'
- Pull only 'date' or 'time' from 'Date time' records
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 text-formatted numbers to dates or numbers
- Convert relative cell references to absolute ones and vice versa
- Switch positive numbers to negative and back
- Export data to JSON or XML
- Switch Japanese chars between Hiragana and Katakana
Randomize Data
Generate values and change their order randomly
Two powerful add-ons from this group are irreplaceable for generating random strings of various data. Use your custom 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 8,000,000 happy users!
Join us and lighten your work in Google Sheets with our clever add-ons
Power Tools components
40+ handy tools
Smart Toolbar
Dedupe & Compare
Merge & Combine
Split
Process Data
Text Tools
Clear
Randomize
Formulas
Convert
8 reasons to get Power Tools right now
More benefits you will enjoy
- Unconditional 30-day money-back guarantee If for some reason you decide to give up the add-on and terminate your subscription, just email us and we'll return your money.
- Work from multiple computers: MacOS, Windows, ChromeOS Since the add-on works in Google Sheets, you can access it from any computer that supports Google Sheets by simply logging in to your Google account.
- One activation key for multiple accounts Order more than one subscription for your employees with a volume discount and get one common key to unlock the add-on for each user.
- Quick return on investment Numerous positive feedback from our users proves that Power Tools enhances productivity, saving you and your companies lots of time and money.
- More than 40 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.
- Detailed step-by-step guides & how-to videos Dive into success with our usage tips. A hiccup along the way? Our attentive support team will tackle any questions or issues for your smooth journey.
- Free support Our customers always get quick and quality assistance on any type of question or issue, e.g. installation, licensing, or technical.
- Intuitive usability meets aesthetic interface Crafted with your ease and fulfillment at the forefront, our add-ons deliver smooth and stylish functionality across all browsers and monitor settings.
Professional service from the Ablebits team
Technical assistance and customer care from Google Sheets experts
System requirements
Operating Systems- Microsoft: Windows 10 and up
- MacOS: Catalina 10.15.7 and up
- Chrome OS™
Browsers- Chrome™
- Firefox
- Safari (Mac only)