Now, let’s save and run the script to simplify your spreadsheet. Run Apps Script in Google Sheets . Apps Script comes with several security protections to eliminate the risk of unverified apps.

It’s great to see Google make so many improvements to Sheets. Before all of this, you’d have to manually format data to turn it into a table, a slow-going process.