How to Share only Specific Sheet/Single Tab in Google Spreadsheet?

Last Updated: September 7, 2017
google sheet share from multisheet

Google docs are the best free alternative to Microsoft Office. Moreover, Google Docs provides the flexibility of being a web-based app; there is no need to install on your local PC. Google offers Google Sheets to replace Microsoft Excel, and there are more web based applications from Google to replace Microsoft Word,  PowerPoint, and similar office tools.

Google lets you create, work and share these office documents with your teammates or office mates with a valid Gmail account. The beauty of this web application is more than one member can work on this document at a time; an ideal solution to draft your school project with your team.

By default, Google allows sharing Google Docs or Google sheet to other users with a valid Gmail ID. You can limit their access to the document in the different level like view/comment/edit etc. Google Spread Sheet may have multiple sheets, and there is no easy solution to share these individual sheets with your team members. We are going to discuss a solution to share only a particular sheet from a multiple sheets Google Spread Sheet.

Related: Best 12 G Suite Products Helped my Business to Perform Well.

This workaround is very useful for schools, a small-scale business where they want to share individual sheets with particular people. The solution is a bit tricky, but works well and easy to implement. Let’s take a two sheet Google Spread Sheet as an example and will show you how to share only the sheet named “Summary” with one of the team members.

Step 1: Protect Google Spread Sheet (primary) to limit access to specific people

This step is very important since we are going to use a link to share the primary document with an another user. Google documents can view in public or viewable to anybody with a share link. You can change this access and limit only to certain members that you sheet multiple tab

Open the required Google spreadsheet (we say primary sheet) and click on the Share button on the right top corner of the document. Now click on Advanced from the “Share with others” window. Now you will be on ShareSettings window, click on “Change” link. Chose “Off – Specific people” from the next Link sharing window and click on Save button.

google sheet accessThis step is critical since you are going to expose the share link with your team and you have to make sure they won’t be able to access your entire spreadsheet with this shared link.

Related: 12 Best Google Voice Features you Never Heard Before

Step 2: Get Google Sheet Share Link

Once you complete the above step, now you will be back on “Sharing settings” window and you can copy the link from the share window. Keep this link saved in notepad or somewhere for future use. If you miss this link, you can always come back to this screen and get the share link.

google sheet tab share linkTo get the Google Sheet share link from the main screen, click on Share > Advanced > Link to share. Alternatively, you can get the same link from File Menu > Share > Advanced > Link to share.

Step 3: Create a new Google Spreadsheet (secondary) to share with your team members

Now you need to create a new spreadsheet to share with the user. This is the sheet you are going to share with your team. Just go to Google Sheet application window and create a new spreadsheet with a valid name. There is no need to type any data inside of this sheet at this point.

Step 4: Import Google Individual spreadsheet to new Google Sheet

Well, in this step we are going to import the required individual Google sheet from the primary document to new Google Spread Sheet (secondary) that you created in Step 3. We are going to use a function called “IMPORTRANGE”  The syntax is:-

IMPORTRANGE (spreadsheet key, range_string)

google sheet import tab command

We chose row A1 to type Spread Sheet heading and used row A2 to insert the function. The import function is like this;

=IMPORTRANGE(“sheet (primary) share link”,”share sheet name!share range start column: share range end column

google sheet import range

In our example, we inserted the following URL and press Enter once you complete. In this function, the URL is the same that we got in Step 2, Summary is the tab or sheet name from Primary Google Spread Sheet, and A & F are the cell ranges that you want to share. Don’t forget to insert the ‘!’ after sheet name and ‘:’ between row letters in the function.


Now you will see on A2 “#REF! and hover your cursor on top of it and click Allow Access. The secondary sheet will import the values now from primary Google Spread Sheet specified tab/sheet.

google sheet tab request accessThis trick will import only the values from the primary sheet. You have to take care the styling and renaming of the secondary sheet as per your requirement.

Step 5: Provide your members’ limited access to new Google sheet

You have to define the limited access to your team members. Click on Share button > Share with others window > Enter Gmail address of your team member > Change the access from “Can edit” to “Can comment”. This step protects new Google spreadsheet users from altering the share link that may expose more information than you intend to share.

google sheet share secureNow you are done with the Google Spreadsheet tab sharing. Whenever you make any changes in the Primary Google Spreadsheet tab, the secondary sheet values will automatically update with primary table values.

google sheet Tab Shared

You can use this workaround to share individual tabs of a Google Spreadsheet with separate members from your team.

You can start 14 days trial with Google App (G Suite) and save 20% per user for the first year as a customer. Please use this Google App Link: 


The only downside is, you have to create separate secondary Google spreadsheets for each member on your team, but this will give you high security and your primary spreadsheet will be isolated and secure from other team members.


  1. What is the difference between your formula and just copying and pasting the data on a new sheet and sharing that new sheet with members?

  2. Hi, The article is good.

    How can I lock a sheet like you have did in the first screenshot. The second sheet is “Transaction” it has locked symbol. How to do that? Can you explain please.

  3. Hi – this is an amazing thing! But what if only certain columns were required which are not in a range say A, C , E only?

  4. As one additional layer of security, you can hide the row that contains your formula. This prevents the team member from being able to see the unique share link.
    To do so:
    -Insert a blank row to the top of your primary document.
    -On your secondary sheet (the one shared with your team member), include that blank row in the range_string.
    -On the secondary sheet, hide that first row that contains your formula. If they only have viewing access, they won’t be able to un-hide the empty row containing the formula.

  5. Hi Steve, need your suggestion here. I have 19 members in my team. I have devised a master sheet for Time motion study that each member needs to fill in. Now, I don’t want one person’s data to be visible to another, except me, for privacy reasons. You think that’s possible ? … I had thought that with your article, I can make 19 secondary replica sheets of my master sheet, and name these sheets as per the team members’s name, and that each person cud see or edit only their respective sheet, which apart from them, only i cud see …. but its not likely , is it ? There’s got to be a way ? …..

    • @Krishna,
      In your case, the quick solution is to create a single sheet for each member with write permission and combine all together in a master sheet with multiple tabs. Since you are giving write permission to the members, this article workaround is not applicable for your requirement.

  6. Can you set up notifications on each sheet so that when new data is entered on the primary, your recipients are notified that changes have been made and they need to look at their sheet?

  7. I don’t want to make any extra sheet. Is it possible to share a tab of same sheet which i am editing

    • @William
      You won’t be able to edit Secondary sheet, this workout is to reflect the changes from Primary Sheet to Secondary file. The edit access od secondary sheet/file should be blocked by default for security.

  8. Thank you for this material. What if Sam copy the link from the ImportRange formula in “Sam Shared” document and just past it in browser?

    • Paul,
      Even if Sam copy and paste the URL, will not break the accessibility to the file. This URL will prompt the user to provide the credentials to open the sheet, depends on the credential (admin or Sam), the user will redirect to there with the given access.

  9. This is excellent. Incredibly useful and very well explained. Follow up question: Is there a way to show them information on a tab within the same spreadsheet other than the primary tab?

    • Yes, You can share multiple tabs with this method, in each sharing code you have to add each tab name that required to share.

Leave a comment