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 try | What the other person can still do |
|---|---|
| Hide the tab | Editors can unhide it, and a downloaded copy of the file includes it |
| Protect the range | See it; protection only stops edits |
| A filter view | Turn the filter off |
A FILTER formula on another tab | Open 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:
| Client | |
|---|---|
| Hill Farms | owner@hillfarms.example |
| Hill Farms | books@hillfarms.example |
| Bay Supply | ops@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
- Open Extensions, Rowsplit, Open Rowsplit and click New split.
- Pick the tab and Split by, Values in a column, then the column that says whose row it is.
- Choose A separate spreadsheet per value under Results go to, and a folder.
- Under Share each file, pick the email column or the lookup tab.
- Pick what they can do: View, Comment or Edit. View is the safest for reports.
- Decide on the share email. Email them a link sends Google's standard share email. Untick it to share quietly.
- 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.
- 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
- How to show dotted-line reporting on an org chart from Google Sheets (Rowtree)
- How to create barcodes in Google Sheets (Rowcode)
- How to email each person only their rows from a Google Sheet (Scheduled Sheet Reports)
- How to export more than 1,000 rows from Search Console (Queryledger)