App Icon
AliceKeeler
•  725,598
Overview
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.
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
Language:
Sort by:
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
Profile Picture
Lisa Henriksson
September 25, 2020
I want to create tabs based on a column containing dates. When creating the tabs, the dates are updated to a different time zone (GMT -7 instead of GMT+1), so the date in the tabs differ by one day compared to the original date. The created tabs only contain an error message that is probably caused by the date-off-by-one-error.
Is this review helpful?
Yes
No
Profile Picture
Rebecca Nance
September 4, 2020
Reset button doesn't work now.
Is this review helpful?
Yes
No
Profile Picture
Elizabeth Gaines
August 18, 2020
Reset worked a couple times, then completely stopped. It says the data for the forms to delete are unavailable. Have uninstalled and reinstalled multiple times and it will not work. I tried using this in an .csv sheet I downloaded from responses and reuploaded into Google Sheets. It continually says "error" and will not work.
Is this review helpful?
Yes
No
Profile Picture
Steven Crist
July 26, 2020
I am trying to create new tabs based on zip code from a master sheet, and it DOES create the individual tabs, but it doesn't take the entire row of information. Only grabs the first 4 columns which doesn't help at all really.
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
Teddy Mulyana
April 2, 2020
You save the day
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
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!
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
1-10 of 21
Additional information
AliceKeeler
Terms of Service
Search
Clear search
Close search
Google apps
Main menu