Split Sheet for Google Sheets

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
Split Sheet for Google Sheets

With Split Sheet you will

  • Split one Google sheet to multiple sheets Divide your summary table into several sheets containing common information.
  • Process columns with or without headers Split the table on Google Sheets even if there are no column labels.
  • Divide Google sheet based on records from key columns Group data by values from one or more columns of interest.
  • Control where to place the result Have the tool create the outcome sheets in the current or a new spreadsheet.

How to split Google sheet to multiple sheets

Find <em>Split Sheet</em> in Power Tools
Find Split Sheet in Power Tools
Select your table and all key columns to divide by, and choose where to place the result
Select your table and all key columns to divide by, and choose where to place the result
Have all new individual sheets created in the current (or a new) Google spreadsheet
Have all new individual sheets created in the current (or a new) Google spreadsheet
Split Google sheet by values in the selected column
Split Google sheet by values in the selected column

License benefits

Our customers get

Unconditional
30-day money-back guarantee
Free support
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Split Sheet and what do I need it for?

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. :)

Doesn't Google provide a free way to divide Google sheets?

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.

How do I split Google sheet into multiple sheets?

  1. Run Split Sheet from the corresponding group in Power Tools.
  2. If your table has headers, check the corresponding option.
  3. Select key columns — those you want to split the data by.
  4. Decide where to place the result.
  5. Click Split.

See a more detailed description here.

What if I need my original sheet as well? Am I supposed to combine everything back?

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.

Will the add-on work if I don't label columns?

Yes. Use a special option to let the tool know if there are headers in your table.

Can I decide where to have all those sheets with split data?

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.

Choose your plan

12-month

  • 12-month access with all updates
$15.00
Buy now

Lifetime

  • Get all new features and updates for free ever!
$39.95
Buy now

System requirements

Operating Systems

  • Microsoft: Windows 7 and up
  • Mac: Yosemite 10.10 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close