How to share one tab in Google Sheets

Why Google Sheets can't do this natively

Sharing in Google Sheets happens at the file level, not the tab level. When you click Share and add someone as a viewer or editor, you are granting them access to the Drive file, and a Google Sheets file contains all of its tabs. There is no permission setting anywhere in the product that says "this person can see the Marketing Budget tab and nothing else."

That's the problem in one sentence. Everything below is a way of working around it, and each workaround trades away something different: privacy, editability, formatting, or ongoing maintenance.

Method 1: Hide the other tabs (don't rely on this)

The instinct is to right-click each tab you don't want seen and choose Hide sheet. It takes ten seconds:

1. Right-click the tab you want to conceal at the bottom of the spreadsheet.
2. Choose Hide sheet.
3. Repeat for every tab except the one you're sharing.
4. Share the file as normal.

Why it isn't real privacy: hidden tabs are a display convenience, not a permission. Any editor can click View → Show → Hidden sheets and bring them all back, with no warning and no trace. Viewers get there too, by making their own copy of the file and unhiding it there; Google's own documentation says so plainly. Hidden data is also still readable through formulas, through File → Download, and through the API.

Use hiding to reduce clutter for your own team. Never use it to keep salaries, margins, or another client's numbers away from someone.

Method 2: Protected sheets and ranges

Protection is the feature people reach for next, and it's useful, just not for this.

1. Open Data → Protect sheets and ranges.
2. Click Add a sheet or range and pick the sheet you want to lock.
3. Click Set permissions and restrict editing to yourself.
4. Optionally tick Hide sheet from the sheet's right-click menu as well.

Why it isn't real privacy: protection controls writing, not reading. A collaborator still sees every cell, every formula, and every value in a protected sheet. They just get an error message if they try to change one. It prevents accidents. It does not create confidentiality.

Method 3: IMPORTRANGE into a new spreadsheet

This is the best free method, and the right answer whenever the recipient only needs to look at the data. You create a second spreadsheet that pulls in one tab from the first, and share only the second file.

1. Open the source spreadsheet and copy its URL, or just the file ID, the long string between /d/ and /edit.
2. Create a new, empty spreadsheet. This is the one you will share.
3. In cell A1, enter:
   =IMPORTRANGE("<source-spreadsheet-URL>", "Marketing Budget!A1:Z1000")
   Replace the URL and use the exact name of the tab you want. If the tab name contains spaces, keep it inside the quotes exactly as shown.
4. The cell shows a #REF! error the first time. Click it and press Allow access, which links the two files.
5. Share the new spreadsheet with your collaborator. They see only the imported tab.

What you give up:

• It's one-way. Data flows source → copy. Anything your collaborator types is either impossible (the imported range is read-only) or lives in cells that never travel back to you.
• Formatting doesn't come along. IMPORTRANGE brings values, not colors, conditional formatting, dropdowns, merged cells, or column widths.
• Anyone with access to the copy can see the source link. The formula itself is visible in the cell, which tells a curious recipient the source file exists (they still can't open it without permission).
• Ranges are fixed. Add rows past Z1000 and you'll need to widen the formula by hand.

A related option is File → Share → Publish to web, which can publish a single sheet as a web page. It's read-only and, more importantly, it's public to anyone with the link. Fine for an open dataset, wrong for anything internal.

Method 4: Share a single tab with two-way sync

If the person on the other end needs to actually work in the sheet (a vendor updating stock counts, a department head filling in a budget, a contractor logging hours), you need a real, editable Google Sheets file that contains only that one tab, and you need their edits to come back to your master.

That's what the Share Single Sheet add-on does. It creates a separate spreadsheet holding a copy of the one tab you pick, shares that file with the people you name, and keeps the two in sync in both directions.

What you get: recipients open a normal Google Sheet containing exactly one tab. They edit it the way they edit anything else, with no new tool and no login beyond their Google account. Their changes flow back to your master tab, and your changes flow out to them, with formatting and data validation preserved on both sides. Everything else in your workbook stays where it is: invisible, and out of reach.

What you give up: it's an add-on, so there's an install step and an authorization prompt, and free use is capped by a quota. Sync runs on Google's Apps Script triggers, so propagation is near-immediate on edit with an hourly safety check behind it, not the sub-second co-editing you get inside a single file.

Side-by-side comparison

Frequently asked questions

Which one should you use?

Pick by what the other person needs to do. If they only need to read numbers, IMPORTRANGE is free and good enough. Just accept that formatting won't follow and keep the ranges wide. If they need to type into the sheet, stop trying to bend one file into two permission levels: give them their own file that holds only their tab, and keep it in sync.