A spreadsheet can have many tabs. After creating your spreadsheet workbook you may want to split out each sheet into individual spreadsheets. You can individually send each sheet to a new sheet manually. Another option is to use the premium feature in TemplateTab.
TemplateTab Add-on by Alice Keeler
This Add-on for Google Sheets collects NO user data! NO PII. One of the features of TemplateTab is the ability to send each tab of the spreadsheet to its own individual spreadsheet. This converts the formulas into static values and creates a new spreadsheet per tab, sending a copy of the sheet to the new spreadsheet.
While not the main purpose of the TemplateTab Add-on, this premium feature can be used with any Google Sheets spreadsheet.
A New Spreadsheet for Each Tab in Your Spreadsheet
To manually move each tab in a Google Sheets spreadsheet to a new spreadsheet you will want to click on the tiny triangle on the tab and choose “New spreadsheet.”
TemplateTab increases the efficiency at which you can perform this action.
Steps for Copying All the Sheets to New Individual Spreadsheets
- Open any Google Sheets spreadsheet with multiple tabs.
- Use the Extensions menu to locate the TemplateTab Add-on and show advanced features.
- Scroll to the bottom of the sidebar for the premium features.
- You will need to be a premium AliceKeeler member.
- Click on the “Export Tabs” button.
- Use the weekly passcode from the premium membership weekly email.
- Wait for sheets to be generated
- Check Google Drive for the exported sheets or view the newly created “Exported Sheets” tab in your spreadsheet with a link to each spreadsheet.
Extensions Menu
Find all of Alice Keeler’s Add-ons at alicekeeler.com/codedbyalice. If you have installed TemplateTab you will see it listed under the Extensions menu. Exporting the individual tabs to individual sheets is under the Advanced Features option.
Export Tabs – Premium Feature
The exporting of the individual sheets to new spreadsheets is a premium feature. You will need to scroll to the bottom of the advanced features sidebar to locate the “Export Tabs” button. If you are not already a premium member you can subscribe at alicekeeler.com/membership.
Subscribing to the premium membership not only gains you access to premium features in AliceKeeler Add-ons, but supports Alice Keeler in the ability to create resources. You also gain access to technical support, office hours, premium webinars, access to past recordings, premium resources, and more.
How to Export Individual Sheets in a Google Sheets Spreadsheet
Exporting your Google Sheets can be done manually or by using the TemplateTab Add-on. Either way, you will want to consider the formulas in your spreadsheet. If your formulas link to other sheets in the spreadsheet, these formulas will be broken.
High Five – FigJam Whiteboard Tool
High Five in FigJam is going to be your new favorite way to collaborate. FigJam is a FREE digital whiteboarding tool
Teachers, Get Your Google Drive Sorted!
There are new ways to show folders in Google Drive. Use this new feature to help you access your files more quickly.
From Anxiety to Enjoyment: How Play Can Change the Relationship with Math
Incorporating play in math education is not just a fanciful idea; it’s a transformative approach that has tangible benefits for both teachers and students. Play fosters an environment of exploration and curiosity, helping to dispel the myth that math is a dry, unapproachable subject. Through games and interactive activities, students are encouraged to develop critical thinking and problem-solving skills. This playful methodology aligns perfectly with fostering a growth mindset, breaking down barriers of anxiety and opening up new avenues for intellectual development. Ultimately, integrating play in math education can lead to deeper understanding, improved engagement, and a lifelong love of learning.
Try This: Search the Google Docs Menus
New features in Google Docs, Workspace, speed up using docs significantly. The trick is to get into the habit searching the Google Docs menus. Search the Google Docs Menus by using the new search icon, it’s more powerful than you think.
Um No ChatGPT – You Are NOT Thinking
I was making a Harry Potter themed Quizizz and was sharply reminded that ChatGPT does NOT think. Use AI but be careful trusting the output of AI. ChatGPT is not thinking
9 Ways Book Creator Can Be Used in Math
MATH! You will love using Book Creator in Math. Creativity, Collaboration, Critical Thinking, Communication, Peer Evaluation, Authentic Audience, Multi-Media, and more! No matter what grade level you teach, Book Creator is great for your classroom.
You must log in to post a comment.