Split one table into multiple sheets by columns
With this add-on, you are literally one step away from splitting your Google sheet into several separate sheets. The tool groups data by common records in one or more selected columns and puts each group to an individual sheet. It's up to you whether to place all resulting sheets next to the source tab or to a brand new spreadsheet.Try it for 30 days for free
This add-on comes in handy whenever you need to divide a table of any size to smaller groups of related data. You just select the columns with important values to split by and choose where you want to get a result: in a current or a new spreadsheet. The tool will split the source table and place each data set to its own separate sheet. And guess what — your original table will remain intact. :)
Well, not really. Standard options offer a workaround only: you must use the QUERY function to pull data from one sheet to another. To be more specific, you will have to create a new sheet and then build a QUERY formula listing all the conditions that should be met in certain columns. Then you are to repeat the same for each new set of data you'd like to get.
With our Split Sheet, you only select the range to process, tick off the columns to consider, and decide where to place the result. That's it. The rest is done for you.
See a more detailed description here.
Not at all. The add-on doesn't alter your original sheet in any way. It simply copies the required records and groups them in new sheets.
Yes. Use a special option to let the tool know if there are headers in your table.
Sure. You can make the add-on paste them to the same file with your source data or to a completely new spreadsheet. In the latter case, the tool will offer you a link to quickly open and review new spreadsheet.