Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: 3 Add-Ons to Try

Google Sheets: 3 Add-Ons to Try

3 Add Ons for Google Sheets

If you use Google Forms your data goes into a spreadsheet. Whether you are using Google Forms or are starting straight from a spreadsheet there are some great spreadsheet Add-Ons that can increase your productivity.

What is an Add-On?

An Add-On is, typically, not created by Google but rather 3rd party programmers. These scripts add extra functionality to your Google Sheets spreadsheets. You can search for and add Add-Ons from the “Add-on” menu in Google Sheets. Here are some of the Add-Ons I have installed.
Alice Keeler Google Sheets Add-Ons

AutoCrat

Anything by Andrew Stillman is going to be good. His Autocrat Add-On script is one of my favorites. It allows you to merge your Google Forms data (or spreadsheet information) to a Google Doc. Even better, the merge can be triggered by submitting a Google Form. This launches a side panel that walks you through the steps to set up the merge. Autocrat Add On for Google Sheets

rowCall

The Add-On script rowCall takes your Google Form data and filters it into tabs. For example, if you have a Google Form that collects homeroom teacher name. A tab will be created for each homeroom teacher and only the students with that home room teacher will appear on that tab. If you have ever wanted to apply multiple filters to sort information onto their own sheet, try out this Add-On.
RowCol Add On

UPDATE: rowCall add-on is no longer available. Use toTabs add-on instead.

Crop Sheet

By default a sheet in Google Sheets has 26 columns and 1000 rows. Sometimes it is nice to make a smaller sheet. Enter in your information to your spreadsheet. Using the Add-On Crop Sheet, the extra rows and columns are eliminated. You can always add more rows and columns but this really helps clean up your sheets.
CropSheet

I created some scripts that will create a lot of tabs at once (https://alicekeeler.com/templatetab). There is a 200 tab limit in Google Sheets and a 2 million cell limit. You will not be able to have 200 tabs if you have the 26 x 1000 grid for the sheets. Cropping the sheet before duplicating sheets will reduce the number of cells in the spreadsheet which helps.

1 thought on “Google Sheets: 3 Add-Ons to Try

  1. LOVE this website! I heard you on a podcast recently, and absolutely fell in love with your enthusiasm and expertise!! Thank you for sharing!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.