How to split Google Sheet into multiple sheets

Written by
Holly Meikle

Google Sheets is a great tool to not only store huge amounts of data in various spreadsheets but also to share and collaborate on files with others. This is great when you want to share an entire spreadsheet of data with someone, but what about when you only want to share specific amounts of data from your file?

There are many instances where we might want to share only limited amounts of information from a spreadsheet. For example, controlling access to sensitive data with a select number of team members, clients, or customers. The only current solution in Google Sheets is to manually copy and paste this select data into another spreadsheet, but this is extremely time-consuming and inefficient.

Sheetgo offers a new solution for these situations – automatically splitting your data from Google Sheets into multiple sheets. Through the add-on, you can transfer specific data from one file to another, all automatically. Let’s explore the feature in more detail and a step-by-step on how to split data in Google Sheets using the Sheetgo add-on.

Why split your data automatically?

Automatically splitting your data and sending it to multiple sheets dramatically saves you a lot of time and manual effort. Automation within processes like this helps to achieve an overall more productive and efficient system.

However, the Sheetgo add-on also offers additional benefits. Here are just a few:

  • Automated system: Sheetgo creates an automated workflow that takes care of your process from start to finish.
  • Maintain data privacy: You can filter down the data you want to transfer, thus making sure you maintain privacy over confidential data.
  • Avoid human error: As Sheetgo automatically transfers the data for you, there’s no need for manual copy and pasting of data. This not only saves you time but also eliminates any risk of human error.
  • Control over sharing: You have complete control of where you send your data to – whether it’s to a new or existing file, within or outside of your organization.
  • Avoid excessive emails and miscommunication: Easily share the workflow with your team members to avoid excessive communication.

Now that we understand the distribution feature and how it can help us to effectively transfer specific data from one Google Sheets to another, let’s go through a step-by-step on how you can use the add-on.

How to split Google Sheets into multiple sheets automatically

In order to demonstrate how to use the Sheetgo add-on to split your Google Sheets data, let’s imagine that I am the manager of my sales team with a master spreadsheet containing each team member’s performance in the last year.

I need to extract the data of each member to send over as their end-of-year performance report. As this contains personal performance insights, the data is confidential and shouldn’t be shared with the wrong team members.

split google sheets 0

Using the Sheetgo add-on, I am able to split the performance for each corresponding sales member in order to create 6 separate spreadsheets which I can then send out.

1. Sign-up and install the Sheetgo add-on

In order to access the Sheetgo add-on and its multiple features, you first need to sign up to Sheetgo to create an account.

Sheetgo add-on

The button takes you to the Google Workspace Marketplace where you can install the add-on.

Alternatively, open your Google Sheets application and navigate to Extensions > Get add-ons, search for Sheetgo and click Install.

2. Connect your sheet

Open up the Google Sheets file that contains the data you wish to split and transfer to another sheet.

Inside this file, open up the Sheetgo add-on by clicking Add-ons > Sheetgo > Start.

split google sheets 1

As you want to export data from this open spreadsheet, under the Export data section, click Select data.

split google sheets 2

Select the tab where your data is located.

Once finished, press Continue.

split google sheets 3

3. Split your Google Sheets data

Under the Send data section, click Multiple spreadsheets in a folder.

This will allow you to split and distribute your data to multiple files.

split google sheets 4
Here, you can choose whether to send your data to a new or existing folder. You can also change the destination of the root folder from Google Drive to other cloud storage solutions, such as Dropbox or OneDrive.

Now it’s also time to choose how to split your data. Choose the column containing the data that will determine the split of the data. For example, as I want to split the data according to each sales team member, I should choose Column A labelled Name. Sheetgo automatically creates a new spreadsheet for each category of data. So, I should have a separate spreadsheet for Tabina, Umeko, Brynn, Minnie, Tailor and Geoffrey, each containing their own sales performance.

split google sheets 5

Once you’re happy with your destination folder, the source column, you can also alter the name of your destination tab to your liking.

Once everything is completed, press Finish and save.

4. Schedule automatic transfers

You can now schedule automatic transfers for your new workflow so that your split data is always updated within your new destination file.

First, click on the Automate button.

split google sheets 6
Slide the button Update automatically to trigger automatic transfers. Now you can automate transfers to your needs, including weekly, daily, and hourly transfers.

Once you’re happy with the schedule, click Save.

split google sheets 7

5. Data split complete!

And there you go! You have successfully split the data within your Google Sheets file and transferred specific data to new spreadsheets in a new folder in your chosen storage space.

Here is the outcome of splitting the sales performance data. As you can see, I now have a new Google Sheets folder containing multiple spreadsheets on the performance data corresponding to each sales team member.

split google sheets 8

New way to split data

Sheetgo has a new release coming very soon for its users. In this latest version, splitting data is even easier. There will be a Split feature that will allow you to send selected data from one spreadsheet to up to 80 other spreadsheets. It allows you to send specific information to specific spreadsheets, using any type of file as your source.

Head to our support page to find out more information about the Sheetgo split feature coming soon.

How to transfer specific data in Google Sheets

With the Sheetgo add-on, you can automatically split and transfer data from one Google Sheets to another in just a few clicks of a button!

If you would like to learn more about managing your spreadsheets using the Sheetgo add-on, check out our article on How to connect Google Sheets automatically.

Alternatively, discover our related blog posts below!

Editor’s note: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.

You may also like…