- Home
- Guides
- Google Workspace
- How to share only one tab in Google Sheets: 2 methods
How to share only one tab in Google Sheets: 2 methods
Google Sheets has no option to share a single tab. Two workarounds let someone see just one sheet: copy it live into a separate spreadsheet you share, or publish only that tab to the web.
By Nur Islam- 2:26 video
- 4 steps
- 33.8K views
Jump to a step (4)
When you share a Google Sheet, the other person can open every tab, including private numbers, notes and other clients' data. People end up copying data into a new file by hand and then keeping two versions up to date.
The video shows two methods. The first creates a new Google Sheet that stays connected to the one tab you want to share, so you share only the new file. The second uses Publish to the web to give a read-only link to a single tab.
What you need
- A Google account with the spreadsheet you want to share from
- Edit access to that spreadsheet
Step by step
0 of 4 done-
01
Method 1: create a new spreadsheet for the tab
Create a new, empty Google Sheet. This is the file you will share. Copy the URL of the original spreadsheet.
-
02
Connect the new sheet to the tab
In cell A1 of the new sheet, pull in the tab with
IMPORTRANGE, for example=IMPORTRANGE("original_spreadsheet_URL","Sheet1!A1:Z1000"), using your tab name and range. SelectAllow accessthe first time. The data stays in sync with the original tab. -
03
Share the new spreadsheet
Select
Shareon the new spreadsheet and add the people who should see the tab. They can open only this file, not the other tabs in the original. -
04
Method 2: publish one tab to the web
In the original spreadsheet go to
File>Share>Publish to web. UnderLink, choose the single tab instead ofEntire Document, pick a format such as Web page, and selectPublish. Copy the link and send it. Anyone with the link can view that tab, read only.
Tips and common problems
- Sharing the original file always gives access to every tab. Use one of these methods instead.
- With IMPORTRANGE, the shared copy updates when the original tab changes, but people cannot edit the original through it.
- Publish to web makes the tab visible to anyone who has the link, so do not use it for confidential data.
Questions
Can you share just one tab in Google Sheets?
Not directly. Sharing gives access to the whole file. Use IMPORTRANGE to copy the tab into a separate spreadsheet you share, or publish only that tab with File > Share > Publish to web.
Does the shared copy update automatically?
Yes. An IMPORTRANGE formula keeps pulling data from the original tab. A published tab also updates when the Automatically republish when changes are made option is on, which it is by default.
