How to share only part of a Google Sheet

By Jake Marsh · Updated

Google Sheets shares whole files: anyone who can open a spreadsheet can see every tab and row in it, even hidden or protected ones. To share only part of a Google Sheet, put each person's rows in a file of their own and share that file with them. Rowsplit does this in one run: split by a column such as Client, choose A separate spreadsheet per value, and under Share each file pick where their email addresses come from.

Why hiding and protecting don't work

What you tryWhat the other person can still do
Hide the tabEditors can unhide it, and a downloaded copy of the file includes it
Protect the rangeSee it; protection only stops edits
A filter viewTurn the filter off
A FILTER formula on another tabOpen the tab with the full data in the same file

Protection is for preventing mistakes, not for keeping data private. Only a separate file keeps rows out of someone's reach.

Two ways to say who gets what

Emails in the data. If each row has the person's email, such as a Rep email column, choose With the emails in a column of that file's rows and pick the column. Each file is shared with every address in its rows.

A lookup tab. If the data has a client name but no email, add a tab with the value in one column and the email in another:

ClientEmail
Hill Farmsowner@hillfarms.example
Hill Farmsbooks@hillfarms.example
Bay Supplyops@baysupply.example

Choose With the emails listed for each value in another tab, pick the Lookup tab, its Value column and its Email column. A value can have several rows, one per person.

Steps

  1. Open Extensions, Rowsplit, Open Rowsplit and click New split.
  2. Pick the tab and Split by, Values in a column, then the column that says whose row it is.
  3. Choose A separate spreadsheet per value under Results go to, and a folder.
  4. Under Share each file, pick the email column or the lookup tab.
  5. Pick what they can do: View, Comment or Edit. View is the safest for reports.
  6. Decide on the share email. Email them a link sends Google's standard share email. Untick it to share quietly.
  7. Tick Remove access Rowsplit gave when someone is no longer listed for that value if access should follow the list, for example when an account moves to another rep.
  8. Click Preview, check who each file goes to, then Save and run.

Keeping it current

Run the split again, or schedule it, and each file is refreshed in place with the latest rows. New people in the email column or lookup tab are added. With the remove option ticked, people who are no longer listed lose the access Rowsplit gave them; access you gave by hand is never touched.

What it costs

Rowsplit is $4.99 a month or $39 a year per Google account. Free trial: 30 days or 50 runs, whichever comes first. No card needed. Every plan and the install link are on the Rowsplit page.

Rowsplit: Split Sheets into Tabs & Files

Split a Google Sheet into tabs or separate spreadsheets by column value, shared and refreshed automatically $4.99 a month or $39 a year per Google account.


Questions

How many people can a file be shared with?

Up to 25 per file.

Can people edit their file and have it flow back to the master?

No. Each run copies from the master to the files. Treat the files as read-only copies and keep edits in the master.

Is the master spreadsheet shared too?

No. Only the files Rowsplit makes are shared, each with its own people. The master stays shared with whoever you shared it with yourself.

What if one person should see two clients' rows?

List their email for both clients in the lookup tab. They get access to both files.


More Rowsplit guides


More Google guides