Help & Support
Send Feedback
toTabs
From Google Sheets data, choose a column to filter data by. A tab for each unique field in the column will be created with filtered data.
265,743 users
Works with
Install
Overview
Easily separate data into individual tabs. From the spreadsheet resulting from a Google Form or any spreadsheet of data, select the column in the toTabs sidebar that you wish to filter the spreadsheet by. A new tab for each unique value in that column will be created. Collects NO USER DATA. 

For a survey, sort the customer responses into individual tabs based on their rating. 
For teachers, sort the Google Form quiz results by class period or question response. 
For a spreadsheet of expenses, create a sheet per expense type to filter your expenses into individual lists. 
For product orders, sort the spreadsheet data into tabs by shirt size (for example.)

Updated: 
12/18/19: Bug fix to sort by numbers.
Reviews
A User of toTabs
January 8, 2020
Amazing for data analysis. As you're doing the exploratory step with data this is really helpful to see the patterns that may arise. You can run it again using a different column so now I have a lot of tabs filtering the data many different ways. Love it.
Submit reply
Cancel
AliceKeeler Keeler
January 8, 2020
This add on is for ANYONE. As a math teacher I'm always thinking of teacher applications, but filtering data from a spreadsheet is super useful for anyone looking at data!
Submit reply
Cancel
A User of toTabs
January 4, 2020
This is so helpful for so many things. I teach multiple classes of the same subject. Sorting form data by class period is so helpful. I also use this same add on for personal reasons, like sorting transactions by category. Its also nice to know, no user data is saved and that this was created with love to help teachers.
Submit reply
Cancel
Kathryn Breshears [Silverado HS]
December 30, 2019
This add-on allows me to sort 170 student responses into separate sheets for each class section, all with few easy clicks. No more copying and pasting data to new sheets or deleting responses and unlinking forms. Such a time saver! Thank you, Alice Keeler!!
Submit reply
Cancel
A User of toTabs
December 20, 2019
Super useful!
Submit reply
Cancel
A User of toTabs
December 20, 2019
LOVE IT!!
Submit reply
Cancel
A User of toTabs
December 20, 2019
Alice’s creative genius strikes again! Awesome feature for math Ts & Ss gathering qualitative & quantitative data via Google Forms.
Submit reply
Cancel
A User of toTabs
December 20, 2019
So simple! I just choose the column and press submit. Boom, I have a sheet per value.
Submit reply
Cancel
A User of toTabs
December 19, 2019
Did not work for me. I would have had to edit each cell's formula one by one which defeats the purpose of an add on.
Submit reply
Cancel
AliceKeeler Keeler
December 20, 2019
This simply filters data, usually from a Google Form, into individual tabs. It does not have anything to do with cell formulas. It puts the value into individual sheets. If you have a formula on the original sheet the value of that formula will appear in the filter.
Angela Greene
December 17, 2019
I am thankful that creative solutions are being developed for teachers! Thank you, Alice Keeler. 🤗
Submit reply
Cancel
1-10 of 14
Additional information
Search
Clear search
Close search
Google apps
Main menu