Teacher Tech

Paperless Is Not A Pedagogy

Menu
  • Teacher
    • Blog Posts
    • Teacher Tech Facebook Group
  • Google Certified Innovator
    • CoffeeEDU
    • Tour of Google Classroom
    • Back to Classroom
  • Author
    • Alice Keeler Books on Amazon
    • Bulk Order Books
  • Developer
    • Schoolytics
    • Google Developer Expert
    • Add-ons By Alice Keeler
      • Doc to Slides by Alice Keeler
      • Roster Extras by Schoolytics
      • TemplateTab
      • toTabs
      • Form Printer
      • Quiz Helper
      • Dice Slides by Alice Keeler
      • Scheduler by Alice Keeler
      • Document Outline by Alice Keeler
      • Missing From (Google Forms™)
      • Randomize Slides by Alice Keeler
      • Speaker Notes by Alice Keeler
      • sheetPusher
      • Seating Chart Slides
      • Hyperlink Slides Choice Board
      • Add-a-Date
      • QuickShare Screenshot
      • Anyone Can View
      • Drive 20
    • Apps Script Tutorials
    • Templates
  • EdTech Coach
    • Premium Membership
    • Free Newsletter
  • Hire Alice
Menu

Google Sheets: 3 Add-Ons to Try

Posted on July 26, 2015December 26, 2019 by Alice Keeler

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.

Related

Related Alice Keeler Blog Posts:

  1. Multiple Google Forms to One Spreadsheet
  2. Google Forms: Submitting Drawings
  3. Google Forms: Hide the Timestamp
  4. Agenda Doc: Send a Google Form and Create an Agenda

Continue Reading

Next Post:
Google Classroom Chrome Extension
Previous Post:
Google Sheets: Students Send Tab of Work to Teacher

2 thoughts on “Google Sheets: 3 Add-Ons to Try”

  1. Pingback: Google Sheets: 3 Add-Ons to Try | Teacher Tech @al… | EducatorAl's Tweets
  2. Jenna Rodgers, MS.Ed (@mrsJennaRodgers) says:
    July 27, 2015 at 8:39 am

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

    Log in to Reply

Leave a Reply Cancel reply

You must be logged in to post a comment.

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

Alice Keeler is a mom of 5. Current High School math teacher. Developer for Schoolytics.com. Google Certified Innovator, Microsoft Innovative Educator, Google Cloud Innovator Champion, and Google Developer Expert. Founder of #coffeeEDU
Teaching with Google Jamboard
Developer Schoolytics
Schoolytics is FREE for teachers.

Find ALL My Blog Posts


Link to List

Google Classroom Books

Alice Keeler: Mom of 5. Current High School math teacher. Developer for Schoolytics. Founder #coffeeEDU. Google Certified Innovator. Microsoft Innovative Educator. Google Developer Expert. EdTech Specialist.

My Referral Links


Custom Stickers, Die Cut Stickers, Bumper Stickers - Sticker Mule

 

©2022 Teacher Tech | Theme by SuperbThemes