In this article:

How to Share Only One Sheet in Google Sheets [2024 Update]

In this article we will show you how to share individual spreadsheets from the same workbook in Google Sheets. We cover how to do this with an add-on, with IMPORTRANGE and by copying and pasting.

Share a Single Sheet by Copying your Sheet to a New Workbook

A simple and efficient way to share a single sheet in Google Sheets is to use the copy paste method. This method involves copying sheet data to a new sheet. This will allow the recipient to make changes to the data once shared.

It is important to remember that as this method involves creating a new sheet so any changes made in one sheet will not be reflected in the other.

For the purpose of this demonstration example worksheets were created. Access these and follow along by clicking the links below:

Worksheet Main: 

https://docs.google.com/spreadsheets/d/1rV-EJJFJS69u2W6Ds5rkQadx5QCrnd4TG8qjEdlsXH8/edit?usp=sharing

IMPORTRANGE Worksheet 2:

https://docs.google.com/spreadsheets/d/1JLz8sCDrPeRswaLDNeP_UHBsjnMMrs3TS5DbUSaMB6A/edit?usp=sharing

1. Select all cells in the sheet you want to share

Click any cell in the sheet to share and press Ctrl (Cmd on Mac) + A to select all cells. Alternatively click the grey box next to the labels for row 1 and column A.

In the example below we can see all the cells in sheet2 have been highlighted.

Share only one sheet in google sheets: Select an empty cell

2. Press Ctrl (Cmd on Mac) + C to copy the selected data

With the data highlighted press the keyboard shortcut Ctrl + C (Cmd + C on Mac). This will copy the entire data in the sheet.

Alternatively from the file menu click Edit and from the displayed menu select Copy.

Can you share one sheet in google sheets: Copy data

3. Create a new Spreadsheet

From the file menu select File followed by New > Spreadsheet. A new spreadsheet will be created. 

How to share one sheet in google sheets: Create worksheet

4. Press Ctrl (Cmd on Mac) + V to paste the data into the new spreadsheet

Click on cell A1 in the new spreadsheet and use the paste keyboard shortcut. Press the Ctrl + V keys (Cmd + v for Mac) to paste the data into the new spreadsheet.

As can be seen in the example below, our data from sheet2 has now been copied to Sheet1 of the new spreadsheet including the original formatting. 

Can you share just one sheet in google sheets: Select all

5. Click the green "Share" button to display the share options

Located at the right-hand side of the display is the green Share button. Click this to display the share options menu.

How to share only one sheet in google sheets: Share

6. Change the Sharing options and Access permissions

From the section labelled General access expand the dropdown menu currently displaying Restricted and select Anyone with the link

On the right hand side of the General access section a new dropdown will display which allows you to change the access permissions. Here are the following options:

Viewer: Selecting this will allow the recipient to view the data only, they will not be able to leave comments or make any changes to the data.

Commenter: This option will allow the recipient of the link to view and comment on the data. They won't be able to make any edits.

Editor: Anybody with the link will be granted full edit access. They can view, comment or edit the data.

In our example we will select the Editor option.

Share only one sheet in google sheets: Access permissions

7. Select "Copy Link" followed by "Done". Send the link to the intended recipient. 

At the bottom of the share options select the Copy link button followed by the blue Done button. The link is copied and the sharing options menu will close.

Can you share one sheet in google sheets: Copy link then done

A notification will display at the top of the screen stating that the Access permissions have been saved.

Send the link to your intended recipient/s and they now have access to the sheet.

How to share one sheet in google sheets: Results

Share Just One Sheet in Google Sheets (IMPORTRANGE Method)

By using the IMPORTRANGE function in a new spreadsheet we can share a sheet that will display changes made to the original sheet.

This method has a limitation that it cannot support editing to the new workbook as the IMPORTRANGE function will break. Therefore if using this method we need to set the permissions so the recipient can view or comment on the data but not edit it.

For the purpose of this demonstration example spreadsheets were created. Access these and follow along by clicking the links below:

Worksheet Main: 

https://docs.google.com/spreadsheets/d/1rV-EJJFJS69u2W6Ds5rkQadx5QCrnd4TG8qjEdlsXH8/edit?usp=sharing

IMPORTRANGE Worksheet 2:

https://docs.google.com/spreadsheets/d/1JLz8sCDrPeRswaLDNeP_UHBsjnMMrs3TS5DbUSaMB6A/edit?usp=sharing

1. Select the sheet from the original spreadsheet you want to share and copy the URL address.

Click the tab at the bottom of the screen for the sheet you need to share.\

From the browser's address bar at the top of the display either triple click or drag to highlight the URL and press Ctrl (Cmd on Mac) + C to copy it.

In the below example, we click Sheet2 from Workbook1. The sheet is highlighted. From the top window, we copy the URL which starts with: docs.google.com/spreadsheets….

Can you share just one sheet in google sheets: URL copy

2. Create a new workbook and click cell A1 to select it

Create a new workbook and select cell A1 in the new workbook.

How to share only one sheet in google sheets: New workbook

3. Input the Formula: =IMPORTRANGE(“URL”, “SheetName!A:Z”)

With cell A1 selected type the formula using the format:

=IMPORTRANGE(“URL”, “SheetName!A:Z”)

Formula breakdown: 

IMPORTRANGE: The IMPORTRANGE function informs Google Sheets that we intend to import a range of data that is in another worksheet.

URL: The URL is commonly known as the website address. This will be the URL of the spreadsheet we copied earlier.

SheetName!: This is the name of the sheet you want to import the data from, this must match the sheet name exactly. In our example this will be: Sheet2!

A:Z: This specifies the range to import. A:Z will import the entire sheet range.

In our example we want to import all of the data from Sheet2, therefore we need to specify the URL copied from the original workbook along with Sheet2, as we are importing the entire range we need to enter A:Z.

In our demonstration below we have entered the formula:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1rV-EJJFJS69u2W6Ds5rkQadx5QCrnd4TG8qjEdlsXH8/edit?usp=sharing","Sheet2!A:Z")

Share only one sheet in google sheets: IMPORTRANGE breakdown

4. Press Enter and click the cell again to allow initial access permissions

With the formula inputted press the Enter key, and the cell will display #REF!

This is because for the first time connecting the sheets, you will need to allow access permissions. To do this click on the cell containing the formula again to see a pop up box.

At the bottom of the pop up box click Allow access.

Can you share one sheet in google sheets: Allow access

5. When the data appears click the green Share button to access the sharing options

The data from the main workbook will now appear in your new workbook.

As we can see below, the data from Sheet2 of the main workbook has been imported. Only the data is imported, the original formatting is not.

How to share one sheet in google sheets: Share button

Now click the green Share button located at the top, right hand side of the sheet to display the sharing options.

Can you share just one sheet in google sheets: Sharing options

6. Set the General access sharing options

In the General access section of the sharing options menu, expand the drop-down menu labeled “Restricted” and change this to “Anyone with the link”. On the right hand of this section, a new dropdown menu will appear. This sets the role of anybody with the link, the options are:

Viewer: This option will allow the recipient of the link view permissions, they will not be able to comment on or edit the data.

Commentor: The link recipient will be able to view and comment on the data but will be unable to edit. Commenting on data will not affect the IMPORTRANGE.

Editor: This option grants the recipient the ability to view and comment on the data. It will also allow them edit access. Because editing any data on this sheet will break the IMPORTRANGE this option is not recommended.

In our example we will set the access role to Viewer as we do not want to allow the recipient editing privileges due to the IMPORTRANGE.

How to share only one sheet in google sheets: Access permissions

7. Click “Copy link” followed by “Done”, the sheet can now be shared

With the sharing permissions changed, click the Copy link button to copy the link to the sheet, then click the blue Done button.

Share only one sheet in google sheets: Copy link and done

The permissions are then updated and you will see a notification confirming this at the top of the display.

Can you share one sheet in google sheets: Results

Share Only One Sheet in Google Sheets (Add-On Method)

You can also share only one sheet via the Sheet Share add-on in Google Sheets. In the demonstration below, we will show how to install and use this helpful add-on.

For the purpose of this demonstration example worksheets were created. Access these and follow along by clicking the links below:

Worksheet Main: 

https://docs.google.com/spreadsheets/d/1rV-EJJFJS69u2W6Ds5rkQadx5QCrnd4TG8qjEdlsXH8/edit?usp=sharing

1. Select Extensions > Add-ons > Get add-ons from the file menu

From the file menu at the top of the display select Extensions. From the dropdown menu click Add-Ons followed by Get add-ons from the side menu.

How to share one sheet in google sheets: Get add-ons

2. Search for the “Sheet Share” add-on

A popup window will now display the Google Workspace Marketplace, in the search bar type “Sheet share”.

Can you share just one sheet in google sheets: Google workplace marketplace

Now press enter, and look for the  Sheet Share - Share Single Sheet add-on provided by Sheet Automation. 

How to share only one sheet in google sheets: Sheet share add-on

3. Install the “Sheet Share” add-on

Click the Sheet Share add-on from the displayed results and click the blue install button located on the top-right of the display.

Share only one sheet in google sheets: Install

At this point you may need to provide permission, select continue, choose your Google account, and select accept. You will then be presented with a success screen showing that Sheet Share add-on has been installed. From the success screen click Done.

Can you share one sheet in google sheets: Install success screen

4. Open the “Sheet Share” add-on by clicking Extensions > Sheet Auto Share > Open

From the file menu at the top of the display select Extension. From the dropdown menu click Sheet Auto Share followed by Open

How to share one sheet in google sheets: Open add-on

The add-on will now open, and a “Sharing” menu will now open at the right-hand side of the screen.

 

Can you share just one sheet in google sheets: Sheet share menu

4. Click “Share” to create a new sharing instance 

From the Sharing menu, select Share. A new menu will display a number of parameters to create a new sheet share. The first thing to do is to name your share. Simply enter this in place of the placeholder text under the Name heading.

In our example below we have named our sheet share ‘LidoShare1’

How to share only one sheet in google sheets: Share name

4. Specify the sheet sharing settings

Click the box below the sheet heading to display the sheet sharing options within the add-on. From this menu select the sheet you want to share from the dropdown menu underneath ‘Select the sheet to share’. 

Now choose the level of protection required for your sheet. In the dropdown menu underneath “Protection” select either “No protection” or “The whole sheet” 

For our example we will choose “No protection” 

Share only one sheet in google sheets: Sheet settings

5. Select the user sharing settings

Click “Save” to return to the sheet share main menu. 

Now access the User settings by select “Click to add user” under the User header of the main Sheet share menu. 

From this menu click the box below the heading “Specify the user to share with” and enter an email address in the text box below. In our example we will enter a test email. 

You can choose the sharing permissions that will be assigned to the person that the sheet will be shared with by expanding the dropdown menu underneath “Permission” select either “Editor” or “Viewer” 

Editor: Allows the recipient edit access permissions, they can view and edit the data on the spreadsheet.

Viewer: Allows the recipient view-only permissions. They will not be able to edit the data but can view it.

For this example we will select Editor, therefore, giving the recipient edit access permissions.

Can you share one sheet in google sheets: User settings menu

6. Save the Share instance and notify the user

With the user settings applied, click the green Save button to be taken back to the main Sheet Share menu. From this menu click Save once more to save and apply the overall share instance.

With the share saved click the three dot menu next to the name of your share from the Sheet Share menu to expand it. Within the three-dot menu, we can send a notification, Open the shared sheet or delete the instance. Select Send notification. This will send all users contained within the share instance an email to notify them. Your single sheet will now be shared.

As we can see below, our share named LidoShare1 has been saved and the users notified.

How to share one sheet in google sheets: Send notification

We hope this article has helped you and given you a better understanding of how to share only one sheet in Google Sheets. You might also like our articles on how to share only one tab in Google Sheets and how to find and replace in Google Sheets.

To optimize your workflow, we recommend reading our guide on how to do mail merge from Google Sheets and trying our app for software reminders.

Schedule a free automation consult
Learn more

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started