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.
Listing updated:August 20, 2024
Works with:
1M+
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.)

This Add-on was developed by Alice Keeler. It is free and collects NO user data. No PII. Check out more of her Add-ons at http://alicekeeler.com/codedbyalice

Updated: 
12/18/19: Bug fix to sort by numbers.
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
toTabs will ask for the permissions shown below. Learn more
toTabs will need access to your Google account
This will allow toTabs 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
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
Angela Davis
June 4, 2024
Awesome App
Is this review helpful?
Yes
No
Profile Picture
Cammie Marks
August 3, 2023
I use forms a lot, this makes it so easy to sort responses into individual tabs. Great add-on.
Is this review helpful?
Yes
No
Profile Picture
Jigme Tenzin
October 12, 2022
it didnt work for me. need help, the column list isnt shown
Is this review helpful?
Yes
No
Profile Picture
Tasha Froelich
January 7, 2022
The toTabs app has been a lifesaver/timesaver for me. I love the ease of use in this app. I thought that I would use this app on occasion but I use it all of the time. It pulls data that my students or colleagues enter into a Google Form and sort it into different tabs in the data spreadsheet. It has saved me hours and hours of time.
Is this review helpful?
Yes
No
Profile Picture
Bob Smith
April 23, 2022
LOVE THIS!!!!
Is this review helpful?
Yes
No
Profile Picture
A User of toTabs
May 22, 2020
I really like it, simple and effective. Anyone knows if there is an easy way to make the data available as seperate worksheets, not as tabs?
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
Beth Hamlin
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.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
Matthew Lingafelter
October 21, 2020
We are at times getting #REF! in cell A2 on all the school sheets that we have set toTabs to sort by. Possible reasons: We are running Autocrat on one of the school sheets The original Google Form was changed to include an extra school A new form came in with a new school that doesn't have a tab yet I am puzzled - which of these do you think it may be? Or is there something else... Before this event. I noticed individual sheets having the #REF! when someone tried to edit the school sheet or attempted to add a filter. This new issue is different because all the sheets are showing #REF! simultaneously. Thanks in advance for the help.
Is this review helpful?
Yes
No
1-10 of 29
Search
Clear search
Close search
Google apps
Main menu