Power Tools for Google Sheets: 40+ Data Cleanup Tools in One Sidebar
Power Tools is an Ablebits add-on for Google Sheets that puts more than 40 cleanup and data tools in one sidebar: remove duplicates, merge and combine sheets, split text and names, change case, count cells by color, find and replace across tabs, and more. It runs in the browser on Windows, Mac and Chromebooks, and the 12-month plan costs $49.99 for one Google account, with a 30-day free trial.
If you spend part of every week fixing other people's spreadsheets (exports with doubled rows, names crammed into one column, stray spaces that break your lookups), this is the toolbox that turns those chores into a few clicks instead of a page of formulas.
Quick facts
- Version: 1.19, released January 16, 2026 (the Marketplace listing was last updated September 21, 2026)
- Developer: APPS4GS (Mikalai Mikhuta JDG), which has built Google Workspace add-ons since 2013 and publishes them under the Ablebits name
- Works in: Google Sheets in a web browser, on Windows 10 and up, macOS 10.15.7 Catalina and up, and ChromeOS. Nothing installs on your computer
- Price: $49.99 for 12 months, $15 for 1 month, $99.95 lifetime, each for one Google account
- Trial: 30 days, fully functional, no credit card required
- Guarantee: unconditional 30-day money-back guarantee
- Marketplace rating: 3.6 out of 5 from 2,134 ratings, 8M+ installs
- What we checked: on the order page the 12-month plan was $49.99, the lifetime plan $99.95, the 1-month plan $15.00 and the 250-user corporate lifetime plan $2,995.00; the Google Workspace Marketplace page showed version 1.19, a 3.6-star average from 2,134 ratings and the Drive and Sheets permissions listed below, all on November 8, 2026. We didn't install the add-on or run it on our own sheets.
Before you buy
- One subscription = one Google account. A coworker who uses your shared sheet needs a subscription of their own to run the tools.
- Broad permissions. At install, Power Tools asks to see, edit, create and delete all your Google Drive files and spreadsheets, and to show its own content in a sidebar. Google's Marketplace notes that the app passed an independent security assessment, but check with your Workspace admin if company policy limits add-ons.
- The 12-month plan has to be renewed (or switched to lifetime) to keep using the tools after a year. Auto-renewal can be switched on or off from the key icon in the add-on.
Download Free TrialBuy Now
Overview
Google Sheets covers the basics, but plenty of everyday jobs still mean a helper column full of formulas: finding duplicates across two columns, pulling prices from one table into another, splitting "Dr. Jane A. Smith" into title, first and last name, or summing every cell someone shaded yellow. Power Tools gathers those jobs into one panel that opens on the right side of your spreadsheet from Extensions > Power Tools > Start.
The tools are grouped by job: a Smart Toolbar of one-click actions, Dedupe & Compare, Merge & Combine, Split, Process, Text, Clear, Randomize, Formulas and Convert. Many of them are also sold on their own as standalone add-ons (Remove Duplicates, Merge Sheets, Combine Sheets, Function by Color and others), so Power Tools is effectively the whole Ablebits Google Sheets collection under one subscription.
Version 1.19 rebuilt the add-on for Google's mandatory V8 script engine and added formula-or-value options and sorting to Combine Sheets, a "Remove hidden rows & columns" option in Clear, live updates when splitting a sheet by rows, and saved scenarios for Combine Sheets, Consolidate Sheets and Split Sheet.
Features
Find and remove duplicates without formulas
Power Tools' Dedupe & Compare group finds duplicate or unique rows in any combination of columns, duplicate cells, matches between two columns, and duplicates across several sheets. It can also compare sheets cell by cell for differences, and combine duplicate rows into one while joining or totaling their other values. You decide what happens to the results: highlight them, mark them in a status column, clear or delete them, or copy or move them elsewhere. Options cover skipping empty cells, matching case and whether your table has headers.
Step 3 of 4 in Find duplicate or unique rows: picking First Name and Last Name as the columns to compare in a book list.
Save a cleanup as a scenario and run it again
Power Tools lets you save the settings of a dedupe, merge, combine or split job as a scenario, then rerun it from the Extensions menu next time the same report arrives. Scenarios can be exported and imported, so a teammate with their own subscription can use the same setup, and some tools can run a saved scenario on a schedule.
The scenario outline for "Dedupe book list": sheet, range, columns and the action (fill duplicates with yellow), with the highlighted duplicate rows behind it.
Merge, combine and consolidate sheets
Power Tools includes five ways to bring data together. Merge Sheets matches records by key columns and pulls missing values from lookup tables into your main table, a point-and-click replacement for VLOOKUP or INDEX/MATCH. Combine Sheets stacks many sheets into one by their column headers, Consolidate Sheets does the same while totaling the numbers, Combine Duplicate Rows collapses repeated records, and Merge Values joins cells in a row or column with a delimiter you choose, without losing data.
Count and sum cells by color
Power Tools' Function by Color calculates over cells by their fill or font color with 13 functions (SUM, COUNT, COUNTA, AVERAGE, MAX, MIN and more) and pastes the result as a formula, so color-coded status sheets finally add up. It also adds custom functions such as =CELLCOLOR() and =VALUESBYCOLORALL() for your own formulas, and Sort by Color reorders rows by their colors.
Function by color counting the light blue cells in a State column with COUNTA, with the inserted valuesByColor formula visible in the formula bar.
Search and replace across every sheet at once
Power Tools' Advanced Find and Replace searches values, formulas, notes, hyperlinks and errors in all or selected sheets, lists the hits grouped by sheet, and lets you replace, extract, format or delete them in one go. Version 1.18 added searching by regular expressions and fuzzy characters, and 1.19 added finding blank cells.
The Find and replace pane looking for "Murray" in values and notes across the June, July and August sheets.
Clean, split and reshape text
Power Tools' text tools change case, add text at any position, remove characters, substrings, extra spaces, line breaks and HTML tags, replace accented letters and smart quotes, and extract numbers, links or email addresses from messy cells. The split tools break text by any delimiter or position, split full names into title, first, middle and last name, divide date-time values, and split one sheet into several by column values or every N rows.
Change many formulas at once
Power Tools' Formulas group converts references between relative and absolute, turns formulas into their values, auto-sums selected columns with 12 common functions, and rewrites every selected formula to a pattern you type, such as wrapping each one in a 33% discount. Convert fixes numbers and dates stored as text, flips number signs and exports a range to JSON or XML.
The Formulas pane applying "%formula%-33%" to every Total formula in a price list.
Random data, passwords and shuffling
Power Tools' Random Generator fills a range with random numbers, dates, booleans, values from your own list, or strings built from character sets or a mask (for example ???-??? for session keys), with an option for unique values only. Shuffle mixes cells, rows or whole columns, which is handy for raffles, test data and seating plans.
Random generator building unique session keys with the mask ???-??? next to a column of generated passwords.
Benefits
- Fewer helper columns. The jobs that normally need UNIQUE, COUNTIF, SPLIT, VLOOKUP and REGEXREPLACE chains become dialogs with checkboxes, which also makes the cleanup easy to hand to a colleague who doesn't write formulas.
- Repeatable work. Saved scenarios, a Recent tools list and Favorites mean the weekly export gets the same treatment every time.
- Any computer. Because it lives in your Google account, the same tools are there on a work PC, a home Mac or a Chromebook as soon as you sign in.
Real-World Uses
- Sales and lead lists: merge lists from several sources, remove repeated contacts by email or name, then split full names into first and last for a mail merge.
- Bookkeeping exports: dump a CSV from your accounting software into Sheets, convert text-formatted numbers and dates, trim spaces and consolidate monthly tabs into one summary.
- School and district reports: combine data from many files into one table, then split it back out into one sheet per campus or class.
- Color-coded trackers: count how many tasks are marked green or red without rebuilding the sheet around a status column.
Who It's For, and Who Should Skip It
It's for people who live in Google Sheets: analysts, marketers, office managers, teachers and admins who clean and combine data every week and would rather click than write formulas or Apps Script.
Skip it if:
- you only need one job done, like removing duplicates. A standalone add-on such as Remove Duplicates ($33.60 a year) or Sheets' own Data cleanup > Remove duplicates may be enough.
- you work in Microsoft Excel. This add-on doesn't run there; look at an Excel add-in instead.
- your organization blocks third-party add-ons or won't grant full Drive access to one.
- you're comfortable with formulas or scripts and clean data rarely. The free trial will tell you quickly whether it saves you enough time.
Usage Guide
- Click Download Free Trial to open the add-on's Google Workspace Marketplace page, then click Install and allow the permissions while signed in to the Google account you'll use. (You can also install it from Extensions > Add-ons > Get add-ons inside a spreadsheet.)
- Open a spreadsheet and select the range you want to work on.
- Go to Extensions > Power Tools > Start. The sidebar opens with the toolbar and the tool groups.
- Pick a group (for example Dedupe & Compare), choose a tool and follow its steps. Multi-step tools show "Step 1 of 4" style wizards with Back and Next.
- Before letting a dedupe delete rows, try the highlight or status-column action first, or work on a copy. Save the settings as a scenario if you'll repeat the job.
- During the trial, the key icon at the bottom of the sidebar shows the days left. After buying, click it and paste your activation key. Hover over the Ablebits logo there to see the installed version.
Where It Falls Short
- Several Google accounts in one browser cause trouble. The vendor's known-issues page says that when you're signed in to more than one account, the Next button can stay disabled, the progress arrows spin forever, or drive.google.com refuses to connect. The fix is to sign out of the other accounts.
- Corporate filters can leave the sidebar blank. If a web filter or antivirus blocks the add-on's servers (aapgate.ablebits.com, cdn.apps4gs.com and cdna.apps4gs.com), the tools load empty until IT whitelists them.
- Auto-start is gone. Since the V8 rebuild in version 1.19, the add-on can no longer open automatically with a spreadsheet.
- Some tools have hard limits. Function by Color can't handle more than about 200,000 cells in one formula, doesn't support theme colors and counts visually empty cells; Combine Sheets skips columns with dates in their headers; the Clear tool doesn't remove comments.
- It's still Google Sheets underneath. Results that come back as formulas can't exceed Google's 50,000-character cell limit, and its custom functions can sit on "Loading..." or #NAME when Sheets is slow to load them.
What Users Say
Power Tools is one of the most installed Sheets add-ons, with 8M+ installs on the Google Workspace Marketplace, but its average there is 3.6 out of 5 from 2,134 ratings. The reviews Google shows first are all 5-star, so that average means a sizable share of users rated it low. The vendor's own known-issues page describes the problems most likely to frustrate users: sign-in conflicts when several Google accounts are open, and blank sidebars behind company web filters.
Google Workspace Marketplace reviews
"This set of tools enables me to manipulate data easily and quickly. Tasks that would take a lot of complex AppScript coding are simplified and made easier for everyday users." Kris Plummer, 5 stars
"Far and away THE BEST extension I have used for Google Sheets. It makes manipulating data so much easier. STRONGLY recommend." Michael McKenna, 5 stars
"Love working with Power Tools. It's invaluable in working with our lead lists, and I use it daily. I also appreciate that their support team is always quick to help with questions." Juno Carlson, 5 stars
"I use this app everyday in my work! I am able to merge data from multiple sources and split sheets by campus when the data is ready.. I highly recommend Ablebits Power Tools!" Becky Blair, 5 stars
"Power Tools is a great app! I have used it many times to compare and de-dupe google sheets data. Such a huge timesaver for me!" Leslie Coston, 5 stars
"Great app! I use the compare and de-dupe tool all the time for Google Sheets - major time-saver with great options to sift and indicate the data needed." Steve Cummings, 5 stars
Customer reviews on the Ablebits product page
"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." Chet King
"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." Christopher Felker
"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." Brian Plaster
"Great add-on. Saves hours of time wrestling with obscure formulas. The split functions are great when someone sends you poorly formatted data." Anthony Doyle
"Totally worth getting this plugin. I got the lifetime version since I knew this would be worth using for my lifetime. :)" Rishi Gangoly
The recurring themes
People who keep Power Tools use it daily for the same few jobs: de-duplicating, comparing and merging lists, splitting badly formatted data and fixing text before a mail merge. Several mention quick, helpful support, including a licensing problem fixed within a day. The weak spots are less visible in the quotes than in the 3.6 average: sign-in conflicts with multiple Google accounts, tools that load blank on locked-down networks,.
Comparisons
Power Tools vs the standalone Ablebits add-ons
Remove Duplicates and Merge Sheets are each $33.60 a year on their own, so buying both already costs $67.20, more than Power Tools' $49.99, which also includes Combine Sheets, Function by Color, Split, text tools and the rest. Buy a standalone add-on only if you're sure you'll need just that one job.
Power Tools vs Google Sheets' built-in tools
Sheets can remove exact duplicate rows (Data > Data cleanup), split text to columns, trim whitespace, and do lookups with formulas. Power Tools goes further where those stop: highlighting instead of deleting, comparing across sheets and files, combining duplicate rows, merging tables by key columns without formulas, counting by color, and saving all of it as reusable scenarios.
Editions and Pricing
| Plan | Price | Term | Users |
|---|
| 1-month | $15.00 | 1 month of use and updates | 1 Google account |
| 12-month | $49.99 | 12 months of use and updates | 1 Google account |
| Lifetime | $99.95 | One-time payment, all future updates | 1 Google account |
| Corporate Lifetime | $2,995.00 | One-time payment | 250 users |
The lifetime plan costs about two years of the 12-month plan, so it pays off if you expect to use Power Tools for longer than that. Volume discounts apply automatically on the order page: 20% off for 10-20 subscriptions, 25% for 21-25, 35% for 26-50 and 50% for 51 or more. The Buy Now button below is for the 12-month plan.
FAQs
Does Power Tools for Google Sheets work in Microsoft Excel?
No. Power Tools is a Google Sheets add-on and only runs inside Google Sheets. Ablebits' Excel tools are separate products sold by a different company.
Can I use Power Tools on a Chromebook or a Mac?
Yes. Power Tools runs in the browser, so it works on ChromeOS, macOS 10.15.7 and later, and Windows 10 and later, in the two latest versions of Chrome or Firefox, or Safari on a Mac.
Does Power Tools work in the Google Sheets mobile app?
Power Tools is built as a sidebar add-on for Sheets in a desktop browser, and the vendor lists only desktop operating systems and browsers in its requirements, so plan on using it on a computer.
What happens when the Power Tools 12-month subscription ends?
When the Power Tools 12-month plan ends, you need to renew it or switch to the lifetime plan to keep using the tools. Your spreadsheets and the changes already made to them stay as they are, since the add-on edits your sheets directly.
Can my whole team share one Power Tools subscription?
No. Each Power Tools subscription activates under one Google account at a time. For a team, buy one subscription per user in a single order (volume discounts start at 10), and one common key activates it for each of them. The 250-user corporate lifetime plan covers a larger organization.
Who actually makes Power Tools?
Power Tools is made by APPS4GS, a team that has built Google Workspace add-ons since 2013 and has been a standalone company (Mikalai Mikhuta JDG) since 2019. Its add-ons are published under the Ablebits name by agreement, and their documentation and tutorials are hosted on ablebits.com.
System Requirements
- A Google account with Google Sheets and an internet connection
- Windows 10 or later, macOS 10.15.7 Catalina or later, or ChromeOS
- One of the two most recent versions of Chrome or Firefox, or Safari on a Mac
- Permission to install Marketplace add-ons (Workspace admins can allow or block them)
Conclusion
Power Tools is worth $49.99 a year if you clean, merge or reshape Google Sheets data every week. It replaces a shelf of formulas and scripts with dialogs anyone on the team can use, and it costs less than buying two of Ablebits' standalone add-ons. If you'll use it for more than two years, the $99.95 lifetime plan is the better deal.
The one reason to buy it: dedupe, merge and split jobs become repeatable, saved scenarios instead of a formula puzzle each time. The main reason not to: it asks for full Drive access and is billed per Google account, and its 3.6-star Marketplace average shows that not everyone gets it working smoothly, so test it during the 30-day trial on the account and network you'll actually use.
Download Free TrialBuy Now