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.

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

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.

%d