Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Give Each Student Their Own Tab

Google Sheets: Give Each Student Their Own Tab
Roster to Tab

One of my favorite class activities is to have students all contribute to the same Google Sheets spreadsheet. Each student can have their own tab in the spreadsheet. This gives me one document to access and assess. It allows me, and classmates, to view the work of other students for the purpose of peer evaluation and collaboration.

If you want to assign students to a particular tab you would need to type each students name into the tabs individually. In order to help solve this tedious task I have written a Google Apps Script that will create a tab for each student on your roster.


RosterTab Template

Go to https://alicekeeler.com/rostertab
to make a copy of the template.




On the first sheet paste the roster of your students into column A. Each item in column A will generate a new tab with that same name. Make sure each name is unique. If you have two students with the name “Jose” in your class be sure to include a last initial or something to make each name unique. Two tabs can not be named the same.
Roster of students in Column A



This template should have an additional menu option next to the Help menu.  Click on the RosterTab menu and choose to “Run RosterTab.”
Roster Tab Menu Alice Keeler

Optionally you can use the “Click Here to Create Tabs” button in the spreadsheet.
Screen Shot 2014-12-30 at 8.32.51 PM



If you have additional names you need to add after you have already ran the RosterTab script, DELETE the names that already have a tab. You can NOT have blank cells. Make sure the new list of names starts in cell A2.

Duplicate Names

Spreadsheets do not allow for two tabs to have the same name. If two names in your list are identical the script will append the name with the position of the student in the roster. For example if alice is 1st on the list and 7th on the list the first tab will say “alice” and the 7th tab will say “alice 7.”

Using the Spreadsheet

Suggestion to download a roster of your students names from your gradebook or from Google Classroom. This will avoid the need to type each students name into the spreadsheet.

Once the tabs are created you can delete the roster tab or can utilize the roster list for record keeping purposes.

This script can also be used for non roster ideas. If you have any list that you would like to convert to tabs this script will work. For example take a list of research topics and run the script to create a tab for each research topic. Have students crowd source information they locate on the different topics. If you want to provide each student with a graphic organizer to fill out on the tab try TemplateTab.

6 thoughts on “Google Sheets: Give Each Student Their Own Tab

  1. Love this idea and it’s potential for the classroom, am trying to make it work on my ipad, but a message appears saying some items not supported- any help with this? It does open in sheets and I am able to add names, just not able to use the roaster tab. Cheers

  2. I’m love to have my students fill out a Form that send everyone’s data to a spreadsheet with a tab for each student. Can you help me do this?

Leave a Reply

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

© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Regular price is $249. Save $150 and pay only $99 for the 2024/2025 school year!

Monthly installments is only $12 a month.

Exclusive Teacher Tech Content! 
Exclusive Online Courses
Premium Add-ons for Google Workspace
Office Hours with Alice
Weekly Check In Support
Exclusive Webinars
And more! 

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