All posts
Tutorial

How to share one tab with true two-way editing sync

Not a read-only mirror and not a copy you reconcile by hand. A real, editable Google Sheet holding one tab, where their changes reach you and yours reach them. Here's the whole setup.

· 11 min read
On this page

Most "share one tab" advice stops at read-only. You end up with a mirror your colleague can look at and nothing more, and then they email you their changes and you type them in yourself.

This guide covers the version that actually works: your collaborator gets a real Google Sheet containing one tab, edits it like any other spreadsheet, and their changes appear in your master workbook while yours appear in theirs. Setup, exactly what does and doesn't carry across, how to verify it, and what to do when something looks wrong.

What "true" two-way sync means

The phrase gets attached to things that don't qualify, so here's the bar. Three conditions, all of them:

  1. A real, editable file. The recipient opens an ordinary Google Sheet and types into cells. Not a formula mirror, not a published page, not a PDF.
  2. Genuine isolation. Their file contains that one tab. The rest of your workbook was never sent to them. Not hidden, not protected: absent.
  3. Changes in both directions. What they type reaches you. What you type reaches them. Without anyone re-keying anything.

The thirty-second test: open the shared file, type a word into an empty cell, and look at your master. If the word appears, it's two-way. If the cell rejects your typing or the word never arrives, it's a mirror wearing the label.

IMPORTRANGE fails condition one and three; hiding tabs fails condition two; Publish to web fails one and three. Those trade-offs are covered in the four-method comparison. This page assumes you've decided you need the real thing.

Before you start: prepare the tab

A few minutes here saves a confusing hour later.

  • Check for formulas that point at other tabs. This is the big one. A cell in your shared tab reading =Salaries!C7 has nothing to point at once the tab is on its own, so it lands in the shared copy as an error. Replace cross-tab references with static values, or move the calculation so the shared tab holds only its own results. It's also a privacy check, since a formula naming a confidential tab tells the recipient that tab exists.
  • Decide who owns which columns. Sync can't stop two people typing into the same cell at the same moment. The reliable fix is social: agree that they fill in columns D and E and you handle the rest.
  • Name the tab something meaningful. It becomes the name they see, so "Vendor: Acme" beats "Sheet14".
  • Have their Google account address to hand. Shared sheets are real Drive files, so recipients need Google accounts.

Setting it up

  1. Install Share Single Sheet from the Google Workspace Marketplace and open the spreadsheet holding your tab.
  2. Open Extensions → Share Single Sheet → Open… The sidebar appears on the right.
  3. Create a new share and name it after its audience, such as "Acme: Q4 orders" rather than "share 1". You'll be looking at this list again in three months.
  4. Pick the tab. Choose the sheet to share. Leave protection as No protection for genuine collaboration; set it to The whole sheet if they should read without changing anything.
  5. Add the people. Enter each recipient's Google email and set Editor for two-way editing, or Viewer for read-only. Editor is what makes the sync bidirectional in practice, since a viewer has nothing to send back.
  6. Save. The add-on creates the shared spreadsheet, grants access, and starts syncing. Use the notify action to email everyone their link, or copy it and send it yourself.

One share can hold several tabs and several people, so a working group that needs the same two tabs is one share, not four.

What actually syncs

It's worth being precise, because "it syncs" hides a lot of detail. Both directions behave the same way.

Carried across Not carried
Cell values Conditional formatting rules
Formulas Column widths and row heights
Inserted and deleted rows Merged cells
Inserted and deleted columns Notes and comments
Fills, font colour, size, family, weight, italics, underline Frozen rows
Alignment and text wrapping Charts and images
Number and date formats Protected ranges
Rich text within a cell  
Data validation and dropdowns  

The right-hand column is mostly presentation. If a dropdown or a currency format matters to how the sheet gets filled in, you're fine. If a conditional-formatting rule is doing real work, highlighting overdue rows for instance, re-create it once in the shared file, or replace it with a plain fill that does travel.

Verifying it works

Do this once, before you tell anyone the sheet is ready.

  1. Open your master workbook in one browser window and the shared spreadsheet in another, side by side.
  2. Type a value into an empty cell in the master. Watch it appear in the shared sheet.
  3. Type a different value into an empty cell in the shared sheet. Watch it appear in the master.
  4. Insert a row in one and confirm the other keeps its alignment.
  5. Delete your test values from either side.

Sync runs on change events, so movement is quick but not instantaneous, so give it a moment before concluding anything is broken.

Managing it afterwards

  • Adding someone to an existing share gives them the same file, so they see the tab as it stands rather than a new copy.
  • Removing someone revokes their access to the shared spreadsheet. Their local copies, if they made any, are theirs; that's true of any Google Sheets share.
  • Switching a person to viewer stops their edits flowing back without disturbing anyone else on the share.
  • Deleting the share ends the sync and removes access. Your master workbook is untouched, because nothing about it depends on the share existing.
  • Renaming the tab in your master is worth avoiding mid-share; the two sides are matched by sheet name.

What happens if a change is missed

Sync fires on Google's change events, and change events are not a guarantee. A script can hit a quota, a run can fail, an event can arrive while another is still finishing. Any honest sync tool has to answer for that rather than assume it never happens.

Share Single Sheet runs a reconciliation pass on a timer behind the live triggers. It re-checks active shares and repairs drift between the two sides, so a change dropped by a missed event gets picked up on the next pass instead of silently disappearing. Live events do the fast work; the periodic check is the safety net underneath them.

If you're weighing building this yourself, reconciliation is the part that turns a weekend script into a system, alongside the echo guards, the cap on installable triggers, and the daily runtime quota Apps Script applies to them.

Limits worth knowing up front

  • Same cell, same second. If two people edit one cell simultaneously, the later write wins. Separate columns by owner and this never comes up.
  • Recipients need Google accounts. The shared file is a real Google Sheet.
  • Editors can copy and download what they can see, the same as any Google Sheets share. The protection here is that they only ever see the one tab.
  • Cross-tab formulas don't survive the split. Covered above, and the most common cause of a shared sheet looking wrong on day one.
  • Every share consumes part of a trigger budget that Apps Script caps per user. Dozens of simultaneous shares is a different conversation from a handful.

Troubleshooting

Errors in the shared sheet that aren't in the master

Cross-tab formulas. The tab they referenced isn't in the shared file. Replace them with values in the master.

Edits flow one way only

Check the recipient's permission. A viewer can't write, so nothing can come back. Switch them to editor.

Colours moved but a highlight didn't

Manual fills sync; conditional formatting rules don't. Re-create the rule in the shared file if it matters.

Rows look one off after an insert

Give it a moment and re-check, since row inserts sync as their own event. If it persists, an edit landed mid-sync; correct the row and it settles.

The recipient can't open the link

Almost always a different Google account from the address you entered, typically a personal Gmail rather than their work account. Check which one they're signed in as.

Frequently asked questions

Can the recipient see my other tabs?

No. They're given a separate spreadsheet containing only the shared tab. The rest of your workbook isn't hidden from them. It was never in their file at all.

Do dropdowns and data validation still work?

Yes. Data validation carries across, so the rules you set on the master apply when they fill the sheet in.

What if we both edit the same cell?

The later write wins. It's the standard behaviour for syncing between two files rather than co-editing inside one, and the practical answer is to give each side its own columns.

Can I share the same tab with several people?

Yes. Add them all to one share, each as editor or viewer. They work in the same shared file, so they see each other's changes as well as yours.

What happens to the shared sheet if I stop sharing?

Access is revoked and syncing stops. Your master workbook is unaffected, since nothing in it depends on the share.

Does this work with a personal Gmail account?

Yes, on both sides. Apps Script quotas are lower on consumer accounts than on Google Workspace ones, which matters if you're running a great many shares at once.

Keep reading

Set up your first shared tab

One tab, the people you name, edits flowing both ways. Free to start.

Install from Marketplace