Within the same spreadsheet, duplicate a sheet for each tab name or student name listed. Export sheets to individual sheets.
Listing updated:July 28, 2024
Works with:
33M+
Overview
Within the same spreadsheet, create a copy of a template or graphic organizer for each tab name or student name on a roster/class list. Ability to export individual tabs in a spreadsheet to new individual spreadsheets.

On the first sheet in any spreadsheet, create a list of tab names or student names in column A. Use Setup in the TemplateTab menu to assist. 

The 2nd sheet should be a template or graphic organizer that you want duplicated multiple times within the same spreadsheet. 

TemplateTab makes it significantly faster to duplicate a sheet multiple times within a spreadsheet and to assign specific names to each tab. 

Run TemplateTab to loop through each tab name or student name listed on the first sheet to create a copy of the second sheet in the spreadsheet. Each duplicated sheet will be named the next tab name on the list in column A. 

📆 TemplateTab now supports using dates as tab names in column A. 

🚛 EXPORT TO INDIVIDUAL SPREADSHEETS
Upgraded Feature: For $5 per year, upgrade TemplateTab to be able to export the individual tabs to separate individual sheets. 
⭐️Option 1: (Export Tabs) Export static tabs that do not update.
⭐️Option 2: (Export Dynamic Sheets) Make the exported sheets DYNAMIC, changes in the sheets are reflected in the exported sheets.
⭐️Option 3: (Reverse Dynamic Sheets) Create a spreadsheet per sheet that are linked back to the main sheet. Edits in the exported sheet are reflected back in the main sheet. 

Reuse Template: Use the sidebar menu to copy the template/graphic organizer to a new spreadsheet. In the new spreadsheet, create a new list of tab names in column A and run TemplateTab.

Teaching Suggestion: This Add-on was originally created with educators in mind to increase collaboration and reduce digital paperwork. Teachers can setup a spreadsheet using TemplateTab and paste their student roster/class list into column A. On the 2nd sheet design a graphic organizer to allow students to complete a classroom task. Run TemplateTab to put each students name on a copy of the template, within the same spreadsheet. Share the spreadsheet with the students, giving them edit access. Each student locates their name on the assigned tab to complete their work. 

Teach Multiple Classes: TemplateTab creator Alice Keeler is a high school teacher. Needing to use a graphic organizer with multiple classes you have the ability to copy the spreadsheet with the template multiple times. Use the option under advanced features. 

Want Help with TemplateTab? Become a premium Teacher Tech member. http://alicekeeler.com/membership Access the premium features of TemplateTab and other AliceKeeler Add-ons as part of your premium membership. 



This Add-on is created by a credentialed teacher, Alice Keeler, and collects no user data. Collects no PII. It is COPPA and FERPA compliant. Safe for schools and classrooms! Check out more of her Add-ons at http://alicekeeler.com/codedbyalice
Additional information
PricingFree of charge with paid features
Developer
Privacy policy
Terms of service
TemplateTab by Alice Keeler will ask for the permissions shown below. Learn more
TemplateTab by Alice Keeler will need access to your Google account
This will allow TemplateTab by Alice Keeler to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Kelly Cruce
March 9, 2023
As always, an awesome add-on from Alice! This saves me from opening 120 documents while reviewing student. So convenient to have everything in one place :) Thank you!
Is this review helpful?
Yes
No
Profile Picture
LindsayWilcox Learning
July 13, 2022
This is a great add-on! As a teacher, I have documents that I want to copy and customize for individual students (like a rubric). This add-on lets me make named, digital copies all in one file with just the press of a button. I love Alice's work!
Is this review helpful?
Yes
No
Profile Picture
Laura Parenti
May 21, 2021
Everything I have ever used that has been coded by Alice Keeler has saved me a ton of time. I honestly don’t know how she does everything she has going on between teaching, teaching other teachers, raising a family, and coding all of these valuable scripts. Download this add on, and while you’re at it, check out her blog and premium membership where she has online office hours multiple times per week where you can ask her anything or attend one with a specific focus and dig deeper into that topic, weekly check-ins (which she always responds to with helpful advice or resources), and she even created Google form versions of her member’s final exams for the classes they teach! It’s unheard of how much she does for her members.
Is this review helpful?
Yes
No
Profile Picture
Bob Smith
April 23, 2022
This a great time saver and makes my job so much easier!!
Is this review helpful?
Yes
No
Profile Picture
Chris Isheim
May 24, 2021
I use Template Tab as well as well as quite a few other of her add-ons! They help the paperwork part of teaching manageable. Check out the other add-ons she has available or sign up for a membership.. she offers great feedback and solutions!
Is this review helpful?
Yes
No
Profile Picture
A User of TemplateTab by Alice Keeler
January 1, 2020
Alice is amazing and I’m proud to use her templates to make my job easier. It almost feels like I’m cheating when she does so much incredible work for us!
Is this review helpful?
Yes
No
Profile Picture
Tasha Froelich
January 7, 2022
I use this app more than I thought that I would. Alice makes digital learning tools easy to use.
Is this review helpful?
Yes
No
Profile Picture
Kevin O'Donnell
December 23, 2019
I've been using Alice Keeler's template tab for a very long time and glad to see it's finally in the G Suite marketplace A consistently makes tools that make the life of a teacher that much easier Because of her already even learned how to code some Google apps script myself and modified her templates to meet my needs Fist bump to Alice Keeler!
Is this review helpful?
Yes
No
Profile Picture
Alison Charlton
January 7, 2022
Really useful gor google classroom
Is this review helpful?
Yes
No
Profile Picture
Ashley Gibbons
January 6, 2022
I love it!
Is this review helpful?
Yes
No
1-10 of 25
Search
Clear search
Close search
Google apps
Main menu