If you have ever clicked the plus icon to create a new tab and renamed the tab multiple times you know how tedious this can be when using a spreadsheet. I wrote a script that allows you to take a list and create a tab for each item in the list. I previously posted the RosterTab script for Google Sheets. I have updated the script to give you the option to delete the original list.
List to Tabs
The original RosterTab creates and names a tab for each item in column A. I have added ListToTabs to the RosterTab menu. This allows you take your list and create a tab for each item in the list. Since you were utilizing ListToTabs to save time in creating and naming tabs the sheet that contains the list is not needed. After creating the tabs, ListToTabs deletes the first sheet.
Template
To utilize either ListToTabs or RosterTab start with the RosterTab template:
https://alicekeeler.com/rostertab
Type or paste a list of names or items in Column A of the first sheet. At the top, next to the Help menu, is the RosterTab menu. Choose ListToTabs to create sheets for each item in the list and to delete the list. Use the RosterTab option to keep the list.
TemplateTab
If you would like to have a template on each of the sheets rather than creating blank sheets try out TemplateTab.
9 responses to “Google Sheets: Create Tabs Quickly”
Also available for MS Excel using asap-utilities: http://www.asap-utilities.com/blog/index.php/2013/01/15/tip-quickly-create-many-sheets-or-sheet-copies/
Lovin’ this. Would you be willing to work with me to make some tweaks to get it to fit our Standards Based grading practices in our district?
Sorry, I am not available to make custom solutions. I would encourage you to learn Google Apps Script and modify the code yourself. It is a lot easier than you think and I have some tutorials on my website.
Hey Alice!
I’m using a QR code that links to a google form for my bathroom passes this year. The google form has a place for their name, and where the student is going (select one). I figured this way, I can easily look back to see how many times in a day/week/month a student leaves the room- and I love that it will have a time stamp!
Here’s what I’m wondering (and I’m sure you have a template, I just don’t know which one to use)… is it possible for me to have a tab for each student at the bottom of my Google Sheet? I’d love the option to just be able to show parents their child’s “out of the room” log for how often they have emergencies 😉
IF SO, should I make the first question (their name) a drop-down question so they can select their name?
Thanks for any help!
Sure use the RowCall Add On
They have to type in their name EXACTLY the same each time though.
rowCall add on is no longer available. Use toTabs add-on (I coded it myself) https://gsuite.google.com/u/0/marketplace/app/totabs/185460175215?hl=en&pann=sheets_addon_widget
You can also have a 2nd form for students to “sign in” or a radio button that they choose “sign in” or “sign out”. The 2nd form can populate to the same spreadsheet in a different tab.
Hi Alice,
The RosterTab2 script that makes tabs for each student and then emails the tab link automatically is great!! BUT, the link that’s sent allows the student to see the entire file, not just their own tab. Is there a way to make it so each student can see ONLY their own tab?
I wan’t to be able to run my gradebook in the first tab and then use the IMPORTRANGE function to take each student’s individual line to their tab. Obviously, I don’t want students to be able to see their own tab or the main tab with the whole gradebook.
Thanks for any advice
RosterTab is a collaborative spreadsheet, they are SUPPOSED to be able to see each other’s tabs.