Google Sheets Power Tools add-on adds some needed tools to Google Sheets. Once the add-on is installed, you can access it from the Add-ons menu.
Puts the Power into Power Tools add-on
The Power Tools add-on has many tools, here are just a few that I really like:
- Split – This tool splits a cell according to information in the cell. For example, if you have a list of full names, either last name, firstname or first name lastname, split can separate the name into two columns.
- Text – Change case, add characters, etc.
- Remove – Removes unwanted characters from cells
- Data – Merge sheets, remove duplicate data, and more
And so much more! If you are involved with cleaning up data in a spreadsheet, check out the Power Tools add-ons.
I’ve spent many a night working on formulas to split cells, especially names, and now that I have the Power Tools add-on, I don’t have to spend that time. And, what makes it better, is that people that aren’t comfortable with formulas can now do a lot of the things I did, on their own.
It looks like some features will be locked away in a Pro version, but as of right now, all pro features are unlocked for use. There isn’t much information about the Pro version of the Power Tools add-on that I could find.
AbleBits has more information available on their Google Sheets Power Tools add-on page. If you are a Microsoft Office user, they also offer add-ons for Microsoft Excel, Word, and Outlook that may be of interest.