ASAP Utilities
Read all reviews for ASAP Utilities →
One of my must-haves…
ASAP Utilities is one of my must-have tools, as useful in Excel as a Gerber multi-tool away from the keyboard! I pay for both personal and professional licenses. When I teach anything related to Excel, ASAP Utilities is one of those secret weapon recommendations I give for dealing with loads of data. It helps to clean up data so quickly. I'm not just talking about crunching numbers. Have you ever thought "This is just too much. I need this data broken up - a new worksheet tab for each category in this column would be great." It can do that. Need to redirect hundreds of short link URLs to a new domain name? I used Rebrandly and/or bl.ink + ASAP Utilities to get the job done. I even used it in a document retention project -- it provided a detailed listing of all the files in certain folders & subfolders on a network share, so the subject matter experts could review, assign, etc in Excel instead of Windows Explorer. Could I do those things with scripts? Yep, but I pay more by the hour for that for one bit of code than I do for a reusable ASAP Utilities license.