A set of 40+ solutions for daily tasks in Google Sheets.
Listing updated:January 2, 2024
Independent security verification
Works with:
8M+
Overview
If bringing your spreadsheets to order in the shortest time possible is your goal, Power Tools is a must-have. It cuts the clicks on repeated tasks and enhances your Google Sheets with features that organize and unify your data.

Among its add-ons you'll find those that remove duplicates, compare and vlookup sheets, import ranges from multiple sheets, merge cells, find and replace data, sum and count colored cells, generate numbers and other records. Text toolkit utilities are also included and let you change case, add and remove strings and characters, trim whitespaces, and split text to columns.

All the tools are divided into 10 different groups based on their main purpose:

➊ Smart toolbar offers some one-click actions. The main ones are:
- Advanced Find and Replace. Search in values, formulas, links, errors, and notes
- Sum and Count colored cells (other functions included)
- Sort rows by font or fill colors
- Change text case. Capitalize first or all letters, apply sentence and lowercase, toggle text
- Sheets Manager. Handle multiple sheets in one go: (un)hide, (un)protect, copy, move, change color, reorder, delete.

Other toolbar instruments let you:
- Remove empty rows and columns
- Flip data
- (Un)freeze top rows and left columns
- Unpivot tables
- Unmerge all or selected cells
- Auto calculate all numbers

➋ Dedupe and Compare data:
- Find and remove duplicates in any combination of columns in your sheet
- Compare two columns or sheets to find duplicates
- Compare sheets cell by cell for differences
- Highlight duplicates or uniques, copy or move them to another location
- Identify dupes in a status column
- Combine duplicate rows and merge unique data referring to the same record

➌ Merge and Combine sheets:
- Merge cells in rows, columns, or the entire range and keep all records
- Merge multiple Google sheets by key columns: vlookup data from other table considering text case and ignoring blanks
- Combine duplicate rows and merge unique data referring to the same record
- Combine data from multiple sheets into one based on column headers
- Consolidate data from several sheets into one summary report

➍ Work with text:
- Capitalize each word or cell, change case to uppercase or lowercase, toggle and polish text
- Manage multiple substrings at the same time: remove, replace, extract, add
- Add text by position:
    1. At the beginning or at the end of the selected cells
    2. Before or after certain text
    3. At any other position you need
- Remove unwanted data:
    1. Get rid of any characters or strings in the range
    2. Remove line breaks, commas, and any characters or strings in the range
    3. Remove characters by position, or when they follow or precede certain text
    4. Delete leading and trailing spaces
    5. Reduce spaces between words to one
    6. Remove HTML entities and tags, non-printing characters, and delimiters
- Split cells in different ways:
    1. By any characters
    2. By capital letters
    3. By strings
    4. By position
    5. Separate names by name units
- Extract text from different positions:
    1. Before/after/between certain text
    2. From the beginning / the end / or the exact position
    3. Extract numbers, links, email addresses
- Replace accented characters with regular, smart quotes with straight ones, turn codes to symbols and back

➎ Process data with one-step tools:
- V-lookup multiple matches based on multiple criteria
- Sum and count cells by their color
- Sort whole rows or only the selected range by the fill/font colors
- Find and replace in values, formulas, links, errors, and notes
- Handle several Google sheets in one go with ease
- Fill empty cells with values from adjacent cells and autofill formulas

➏ Split toolset:
- Separate values by any character or strings
- Split text by position 
- Separate first and last name in Google Sheets, extract titles and other name parts into individual columns
- Split one table into multiple sheets by columns or N rows
- Split 'Date time' cells into cells with the date and time units 

➐ Randomize:
- Shuffle values in rows, columns, or the entire range
- Generate random numbers, dates, booleans, custom lists, or strings 

➑ Try out the formula tools:
- Toggle between relative and absolute cell references
- Convert formulas to values
- Autosum columns and automatically add other functions to all selected columns
- Add new calculations to all Google Sheets formulas at once

➒ Clear contents in Google Sheets by type:
- Erase any combination of data types from the selected range: formatting, numbers, dates, booleans, notes, text, formulas, hyperlinks, or validation
- Delete all empty or unused rows and columns

➓ Convert data format:
- Convert text-formatted numbers and dates to numeric and date format
- Change number sign
- Export Google Sheets range to JSON or XML
- Convert Japanese chars between Hiragana and Katakana systems

Power Tools keeps the history of the recent operations at hand so you could quickly re-apply actions to a different range. You can also favor the most frequent features to have access to them at any time. 
Or save the entire sets of options to find duplicates or merge two tables in a click.

30 DAYS OF FREE USE
Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions about the add-on, please post them here:
https://www.ablebits.com/docs/google-sheets-power-tools/
We'll be happy to assist!

Power Tools is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW:
***** V1.17 (17 August 2023) *****
★ New features ★
- Compare multiple sheets for duplicates. We enhanced our long-existing 'Compare two sheets' so it could compare multiple sheets at a time.
- Compare Columns. A one-step tool for when you need to compare just 2 columns on one sheet. 
- Substring Batch Toolkit. Manipulate multiple substrings at once: add, remove, extract, replace.
- Sheets Manager: copy or move the same sheet(s) to multiple existing spreadsheets at once.
- Clear: delete empty cells and shift data up or left.

Improved:
- Sort by Color: can now skip empty cells so only cells with values are sorted.
- Random Generator: generate only unique strings using the corresponding setting in the related group.
- UX and UI improvements.

Fixed:
- Advanced Find and Replace: couldn't replace and export the data from the sheets with 2 numbers at the beginning of their names.
- Clear: errored sometimes due to the incorrect data processing order.
- Combine Sheets: cut zeros and leading spaces from the names of the combined sheets on the 'Connect files to IMPORTRANGE' sheet.
- Extract: didn't extract URLs if the first row in the selected range was empty.
- Function by Color: returned '1' when the actual results were still loading.
- Sheets Manager: stopped processing multiple sheets if at least one of them couldn't be processed.
- Shuffle:
    1. Removed links created by the 'Insert link' option.
    2. Removed alternating colors from the processed range.
- Split Names:
    1. Didn't recognize 'De' as part of the last name unless written in lowercase.
    2. Didn't recognize 'Daisy' as a first name.
- Split Sheet: didn't split to multiple separate spreadsheets if it resulted in 1K+ rows in one of the files.

***** V1.16 (16 March 2023) *****
★ New features ★
- Compare Sheets Cell by Cell. Compare cells in each row between multiple Google sheets for differences.
- Sort by Color. Sort the selected sheet or the whole sheet by fill or font colors.
- Function by Color: calculate by all fill/font colors in the selected range.
- Merge Sheets: insert additional matching rows. If there are several matching rows for the same key value, the add-on will not only update the first record but also add those extra matching rows right afterward or at the end of the entire table.
- Split Sheet: a new way to split – by the required number of rows.

Improved:
- Merge Sheets: 
    1. You can now merge multiple lookup sheets with your main sheet in one go.
    2. If your lookup sheet has notes, the add-on pulls them along with the values into corresponding cells.
- Combine Sheets: when you add sheets to the result using a formula, they are now being added to the end of the whole table.
- Advanced Find and Replace: further performance improvements made it possible to export more found records than before.
- Text: all text tools now process multiple non-adjacent ranges.
- Multiple VLOOKUP Matches:
    1. It's now possible to copy-paste a list of words into the add-on so they turn to multiple conditions.
    2. Text operators (starts/ends with, contains/ doesn't contain) now recognize cell references so you can refer to cell values instead of entering them directly into the add-on.
    3. Performance improvements for previewing and pasting 5k+ found records.
- Split Sheet: now treats matching records written in different text cases as the same.
- Convert:
    1. Now recognizes more number formats, including custom ones.
    2. Converts numbers in parentheses to negative numbers. 
- It's now possible to look for the files in the folder with Starred items of your Drive.
- The limit for total cells in a spreadsheet is expanded to 10 million cells.
- UX and UI improvements.

***** V1.15 (11 March 2022) *****
★ New features ★
- Fill Blank Cells. Replace empty cells in your selection with records from nearby cells or with your custom values.
- Sheets Manager. Now you can find the required sheet swiftly by typing its name in the search field right in the add-on.
- Remove Text. Choose to ignore cells without text & cells with formulas when removing spaces & delimiters in order to avoid data corruption.

***** V1.14 (18 October 2021) *****
★ New features ★
- Sheets Manager add-on. Handle multiple sheets in one go: (un)hide, (un)protect, copy, move, change color, reorder, delete.
- Combine Sheets. Quickly add more files to the existing result with a corresponding new option. No need to combine all sheets all over again. Just select the new sheets you want to add to the result and the result itself. Select the previously combined data as the one to update and the add-on will do the rest.
- Function by Color. Two new functions are available in your Google Sheets:
=CELLCOLOR()
=VALUESBYCOLORALL()
Use them to process colors in your own formulas, e.g. SUMIFS, IF, etc.
- Split Text. Now you can split text not only into multiple columns but also into rows.
- Extract Text. Extract all matching records from a cell into one or separate cells.
- Change Case. A new setting is available: lower & Capitalize. It will not only - - Capitalize Each Word in a cell but also lower all other letters.

***** V1.13 (5 May 2021) *****
★ New features ★ 
- Consolidate Sheets. Plus add-on to combine data with a formula! Have the result for SUM and COUNT returned as a formula to consolidate all existing and future records from the selected sheets. The formula is always connected to your original files: the resulting calculations will consider all changes and new values automatically.
- Scenarios are finally available for the following add-ons: Merge Sheets, Remove Duplicate Rows, Combine Duplicate Rows, Compare Sheets.
- Advanced Find & Replace:
    1. Now you can delete rows with found values.
    2. Preserve text formatting. If there are multiple text strings in a cell formatted in different ways, this option will let you keep all formatting upon replacing values.
- Text:
    1. Extract. Extract text, numbers, hyperlinks, URLs and email addresses from any part of the selected text.
    2. Match case. Decide when to consider the text case with the corresponding checkbox in the 'Add', 'Remove' and 'Split' tools.
    3. Replace symbols. Single smart quotes (‘’) are replaced with single straight quotes ('') as well.
- Remove Duplicate Rows, Compare Sheets, Quick Dedupe. New action with found values is available – delete entire rows from the sheet.
- Compare Sheets. If sheets of interest are in separate spreadsheets, you can add them for comparison from Drive straight from the add-on.
- Multiple VLOOKUP Matches. You can now look for cells that 'start with' or 'end with' particular characters or strings.
- Split Sheet. A new way to split – to multiple new spreadsheets.
- Convert. A compliment for users who work with Japanese texts: convert characters to Hiragana and full-width or half-width Katakana.
- Clear. The 'Clear validation' option will remove 'Data validation' from the selection leaving only values in cells.

***** V1.12 *****
★ New features ★
- Combine Sheets. One more way to combine data – with a formula! Have the add-on build a formula to join all existing and future records from the chosen sheets together. The formula is always connected to your original files. Hence, all source changes, all new cells, rows and columns will appear in the combined table automatically.
- Split Text. Two new options were introduced by your request:
    1. Split values by capital letter.
    2. Replace source data with the first result column.
- Add Text by Position. Add text to non-blank cells only using the 'Skip empty cells' checkbox.
- Text:
    1. Remove html tags. This feature removes all opening and closing HTML elements (e.g. <strong>, <br>, </li> ) from the text.
    2. Replace smart quotes (“”) with straight quotes ("").
- Clear. Remove empty/unused rows/columns from all sheets at once.
- Convert number sign. An extra setting lets you 'reverse all number signs' in the selected range at once.

***** V1.11 *****
★ New features ★
- Split Date & Time. Separate cells containing 'Date time' values into columns with only 'Date' units and 'Time' units.
- A couple of new options were introduced into Function by Color:
    1. Fill your result cells with colors of the pattern cell used for calculations.
    2. Quickly check and change formula colors and calculation ways with the 'Edit selected formula' option.

***** V1.10 *****
★ New features ★
- Multiple VLOOKUP Matches. Do a quick vlookup across multiple columns and find all matches from all directions based on numerous criteria.
- Consolidate Sheets. Summarize records from several spreadsheets based on their position or common headers.
- Quick Dedupe. This one-step tool will instantly find and eliminate duplicates in your table. It colors and deletes, copies and moves dupes to a new sheet, as well as marks them in a status column.
- Split Sheet. Split one table into multiple sheets by columns.
- Merge Sheets: you can not only update your existing main table but also merge tables in a new spreadsheet.
- Auto-start is now available. Pin the button at the very bottom of the add-on and it will run automatically in each spreadsheet.
Additional information
PricingFree of charge trial
Developer
Privacy policy
Terms of service
Power Tools will ask for the permissions shown below. Learn more
Power Tools will need access to your Google account
This will allow Power Tools to :
See, edit, create, and delete all of your Google Drive files
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
View and manage data associated with the application
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Randy W. Harris
March 13, 2024
I built custom dashboards for the multi-unit supervisors in our company, and Ablebits is foundational in their use. Prior to using this plug-in, I was doing most tasks manually. Now we are fully automated and our leaders love it! I upgraded to Power Tools from Function by Color and we're excited to unpack their usefulness. And also important is the support. Darya and the team always respond quickly and professionally. Highest recommendation!
Is this review helpful?
Yes
No
Profile Picture
Breanne Cassidy
December 22, 2023
I have to run reports pretty regularly from several data sources. Power Tools helped reduce the manual effort required to compare the data sheets. It's saved me a lot of time in my day. When I have questions or issues, the Support team is quick to respond.
Is this review helpful?
Yes
No
Profile Picture
Zalma Ahedo Villanueva
November 6, 2023
Excellent tools, doing the magic as espected to accomplish our work faster and precisely, totally recommend. Also a great and quick support by customer service center, ongratulations to all of you.
Is this review helpful?
Yes
No
Profile Picture
Lorraine English
October 27, 2023
The "Power Tools" add-in for Excel is an invaluable asset for anyone working extensively with spreadsheets. This suite of tools revolutionizes Excel's capabilities, offering an array of features that streamline tasks and enhance data analysis. From data cleaning and formatting to advanced analysis, its user-friendly interface and powerful functions make it a must-have for anyone seeking efficiency and accuracy in their Excel work. Overall, Power Tools significantly elevates the Excel experience, making it an indispensable tool for professionals and enthusiasts alike.
Is this review helpful?
Yes
No
Profile Picture
Karen Taylor
November 3, 2023
Power Tools are one of the basics in my job! I cannot live without them, super helpful in cleaning and organizing batches of data. I use them in my daily activities, definitely a must-have!! If you need help the support team will answer and help you right away!
Is this review helpful?
Yes
No
Profile Picture
Justin Kidd
February 22, 2024
This extension is a must if you plan to do serious spreading in Google Sheets. I noticed every time there was something I couldn't do in vanilla sheets Power Tools was in the search results with an answer. Keep more of your hair and get this app. 10/10
Is this review helpful?
Yes
No
Profile Picture
Steven Stiriti
January 4, 2024
This tool makes it so much easier to merge files and anything else that you would normally need to write a formula for. I have had a couple instances where I needed help from their support team and they replied so promptly and helped me resolve my issues painlessly which is so unusual in the tech space. I have a lifetime subscription for a reason. Thanks!
Is this review helpful?
Yes
No
Profile Picture
Dillon Andrew
August 23, 2023
I use the power tool suite daily. Helps me do things that would otherwise take hours or cost me to hire a VA. This tool is an absolute lifesaver for me and the few times it's been buggy or unresponsive for me the team has been quick and kind to get me moving again! In some cases worked thru very difficult tech trial and error processes to work thru it with me and better their product. Very impressed!
Is this review helpful?
Yes
No
Profile Picture
Cheyenne Granger
January 2, 2024
What an amazing extension! This tool has saved me literal hours every week when I pull reports for company meetings. When I had an issue getting the system to work due to a bug with Google, they were quick to respond with a work-around I could easily do myself (though the team at Ablebits did offer to implement the fix on my report themselves!). I can't imagine going back to the old way of running my reports. Even my boss swears by this!
Is this review helpful?
Yes
No
Profile Picture
Charles Matthews
March 12, 2024
Great addon, works well & support was prompt to respond & eager to help.
Is this review helpful?
Yes
No
1-10 of 220
Search
Clear search
Close search
Google apps
Main menu