toTabs - Google Workspace Marketplace

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.

By:

Listing updated:May 17, 2022

Works with:

969,673

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.

Updated: 
12/18/19: Bug fix to sort by numbers.

Additional information

PricingNot available

Developer

Trader status unspecified

Support

ReportFlag as inappropriate

Reviews

Language:

Sort by:

Google doesn't verify reviews or ratings. Learn more about reviews

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

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

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

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

Aida Issayeva

August 4, 2021

simply great

Is this review helpful?

Yes

A User of toTabs

December 20, 2019

Super useful!

Is this review helpful?

Yes

SIA Gragons

January 29, 2022

Perfekti!

Is this review helpful?

Yes

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.

Is this review helpful?

Yes

A User of toTabs

December 20, 2019

LOVE IT!!

Is this review helpful?

Yes

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

1-10 of 25

Clear search

Close search

Google apps

Main menu