Sheet Share

Sheet Share is a google sheet add-on that helps you share a single sheet with others.

Google Sheets only allows to share the entirety of the document, when you try to share the sheets with others.

Google Sheet without sharing the rest of it. As simple as it sounds, Google does not have a direct way to do this. That does not mean it is not possible to do–you just need to get creative. Sometimes you want to share one tab of a spreadsheet while keeping the other tabs private. Protecting the cells prevents collaborators from editing particular tabs but they can still view the contents, so it is not a valid solution. The ImportRange function in Google Sheets allows you to create a dynamic copy of particular tabs in a spreadsheet that you can share without worrying about collaborators viewing information in the other tabs.

Google Sheet does not have the option to share a single sheet/tab. So when you share a Google Sheet with someone, the other person can access all the tabs.

Sheet Share add-on make it easy to share these individual sheets with your team members.

Installation

Install the add-on from Google marketplace.

Start add-on by clicking menu Add-ons - Sheet Share - Open… You should see the sidebar showing up shortly.

Getting started

1. Create a new sharing.

2. Select the sheet to share and configure protection

3. Select the user to share with

4. Share the sheet

Once the sharing is saved, it’s ready to share. You can copy the share link and share it to configured users.

Contact