Technology doesn’t always make our lives easier, so when it saves you a full day of work, that is blog-worthy. The Power Tools Add-on for Google Sheets had me doing cartwheels around the office.

We used Power Tools to prepare some Sheets for our billing office. In years past, we have suffered through hours and sometimes days of tedious formatting in Sheets. Back then, I took the time to learn a few formulas that helped speed things up, but nothing made the process feel easy. Until Power Tools for Google Sheets.

We used Power Tools for Google Sheets to:

• Compile multiple rows into 1
• Merge data from multiple columns
• Remove duplicate rows
• Add spaces
• Insert characters by location
• Change text formatting
• Convert text to number formats
• Clean up data that was imported

While this was possible in Excel, the features weren’t as simple and accessible as they are in Power Tools. Plus, we never lost the real-time collaboration and consistent revision history that we rely on.  What once took a day or more, we finished in an hour. Power Tools & Google Sheets for the win!

Technology is amazing and when it runs this smoothly, it feels like magic.