Google Sheets™ add-on · share rows and tabs
ShareLane — Share Only Their Rows of a Google Sheet
Everyone sees their part. Nobody sees the rest.
Google Sheets™ can only share a whole file. ShareLane gives each person their own view-only copy, with the header and only their rows, or one tab for a list of people. Press Update now and changed rows, new people and people who left are all taken care of; with Pro, every hour or every day. The copies live in your own Google Drive™.
- One share for up to 3 people free
- View-only, download off by default
- No BiLingoPlus server in between
Illustration, not a screenshot.
How it works
From one sheet to everyone’s own copy in three steps
Set up a share once. After that it is one click, or no click at all with automatic updates.
1Open it from the Extensions menu
In a Google Sheets spreadsheet: Extensions → ShareLane → Open ShareLane. The panel opens on the right.
- Payroll ▾Each person gets only their rowsEveryone gets the whole tabEmail ▾
2Pick the tab, and whose rows they are
Choose the tab and the column that holds each row’s email address. Or share the whole tab with a list of people.
Who gets whatAnn Lee · 2 rows
Ben Ortiz · 1 rowUpdate nowUp to date for 2 people. 2 copies changed. Shared with 2 new people.
3Preview, then Update now
Preview shows who gets how many rows before anything is shared. Update now makes each copy in your Drive and shares it, view-only.
Only their rows
A separate file per person, not a hidden tab
Hiding, protecting or filtering a tab does not keep it from people who can open the file. A copy that holds only their rows does.
Row 1Shared from you@example.com with ShareLane — updated Nov 12, 2026 at 9:00 AM (America/New_York). Edits here are not sent back.Row 2The header, bold and frozenThenAnn’s rows only, with your number formats
The layout every copy has in ShareLane 1.0. Formulas arrive as their results.
- Nothing else is copiedNo other rows, no other tabs and, with Pro, only the columns you tick. Formulas arrive as values, so nothing in a copy can reach back into your file.
- View-only, download offPeople can view, or with Pro comment. Download, print and copy are turned off for them by default. Nobody gets edit access.
- Out of the sheet, out of the copyWhen someone’s email is no longer in the tab, the next update removes their access. The file stays in your Drive.
Features
Made for sheets that many people need a piece of
Kept up to date, not copied once
Update now rewrites only the copies whose rows changed, shares with new people and removes access from people who left. With Pro it runs by itself every hour or every day, while the spreadsheet is closed.
Updates every day at 7 AMUp to date for 24 people. 3 copies changed.
Nov 12 · 7 AMRemoved access for 1 person.
Only the columns they should see (Pro)
Tick the columns people may see and leave out the pay of others, internal notes or cost prices. Columns keep their order from your sheet.
Names or emails, your choice
A column of email addresses works on the free plan; a cell with several addresses gives the row to each. With Pro, a column of names works too: list the names, type each person’s email once.
Ann Lee, ann@example.comStore 12, manager@example.com, owner@example.comAnd more
- By rows, or one shared copy of a whole tab
- Preview who gets what before anything is shared
- Values with your number formats and column widths
- A copy deleted from your Drive is made again
- Your note in Google Drive’s sharing email
- Up to 10,000 rows per tab
- Stop sharing: everyone’s access removed in one click
- A ShareLane log tab of every update and access change (Pro)
Compared
Ways to show each person only their part of a sheet
Scroll the table sideways →
| Way | Only their rows | Stays up to date | Access removed when they leave | Cost |
|---|---|---|---|---|
| Share the whole file | No, every tab and row | Yes, it is the same file | Only if you remove them by hand | Free |
| Hide tabs, protect ranges, filter views | No: editors can unhide, and a copy or download holds everything | Yes | Only by hand | Free |
| A file per person with IMPORTRANGE | Yes, if the filter is right | Yes, by formula | Only by hand | Free, plus a file and a formula per person |
| Your own Apps Script with a timer | Yes, once you write and test it | If your code updates the same files | Only if you write it | Free, plus your time |
| ShareLane | Yes, and only the columns you tick (Pro) | Update now, or every hour or day (Pro) | Yes, at the next update | Free · Pro $4.99/month or $39/year |
Each way, step by step, with a script you can copy: how to share only certain rows or one tab of a Google Sheet.
Pricing
One share is free. Pro keeps them all current.
Start free. Upgrade from the ShareLane panel when you want automatic updates, more people or column choice.
Pro · automatic updates
or $39 a year · cancel anytime
- Automatic updates every hour or every day
- Up to 20 shares and 100 people per share
- Choose the columns people see
- Names matched to emails, comment access and a log tab
- Everything in Free
Free
One share per spreadsheet, updated whenever you press Update now.
- By rows (an email column) or the whole tab
- Up to 3 people
- View-only, download, print and copy off
- Preview and Update now
Pro is bought inside the add-onPaddle is our Merchant of Record14-day refund on any charge
Privacy & permissions
Your rows go only to the people you choose
| Reads | The tab you share: its values, number formats and column widths, and row 1 for the column names. And only the spreadsheet you set ShareLane up in, plus the copies it made. Google words its spreadsheet permission as “all your Google Sheets spreadsheets”, because ShareLane writes into its copies and automatic updates (Pro) run while everything is closed. ShareLane opens no other spreadsheet. |
|---|---|
| Sends | Copies go into a folder of your own Google Drive and are shared, view-only, with the people you named; Google Drive emails them the link. Nothing is sent to BiLingoPlus. The add-on asks Paddle whether your email has an active Pro subscription. |
| Permissions | spreadsheets · drive.file · script.external_request · script.scriptapp · script.container.ui · userinfo.email |
Google’s drive.file permission reaches only the files ShareLane created: it cannot see the rest of your Drive. No Gmail™ permission. No ads, no selling of data and no AI reading your sheets.
Made by BiLingoPlus LLC, Wyoming · support from the people who build itQuestions
Questions about sharing parts of a sheet
Can’t I just share one tab in Google Sheets?
No. Sharing in Google Sheets is for the whole file: anyone you share it with can reach every tab. Hiding or protecting a tab does not keep its data from them, and a copy or download of the file shows it all. The safe way is a separate file that holds only what that person may see, which is what ShareLane makes and keeps up to date.
What do people receive?
An email from Google Drive saying you shared a spreadsheet with them, with your note if you wrote one. The file is called after the share and the person, such as “Payroll — Ann Lee”. It is view-only, and row 1 says who shared it and when it was last updated.
Can they see other people’s rows, or the columns I left out?
No. Their copy holds only their rows and, with Pro, only the columns you ticked. Nothing else from your spreadsheet is copied into it, and formulas arrive as their results, so nothing in the copy reaches back into your file.
What happens when I change my sheet?
Press Update now, or let Pro do it every hour or every day. Copies whose rows changed are rewritten and the others are left alone. Deleted rows disappear. Someone who is no longer in the sheet loses access; the file stays in your Drive.
Can people edit their copy and send changes back?
No. Copies are view-only, or comment-only with Pro, and nothing flows back into your sheet. ShareLane is for showing people their part, not for collecting their input.
Do the people need ShareLane or a paid plan?
No. They need a Google account to open a file shared with them, like any shared spreadsheet. Only you install ShareLane.
Is ShareLane free?
One share per spreadsheet, for up to 3 people, is free, updated whenever you press Update now. Pro, for automatic updates, up to 20 shares and 100 people per share, column choice, names matched to emails and comment access, is $4.99 a month or $39 a year, bought from the ShareLane panel.
What can ShareLane see in my Google account?
The spreadsheet you set it up in, the copies it made and your email address. Google’s screen says it can see, edit, create and delete all your Google Sheets spreadsheets, because it writes into its copies and automatic updates open files while they are closed; ShareLane itself opens no other spreadsheet. Its Drive permission reaches only files ShareLane created, so it cannot see your other files.
Guides
Guides for sharing parts of a sheet
Guide
How to share only certain rows or one tab of a Google Sheet
What Google Sheets can do by itself, IMPORTRANGE, a script you can copy, and an add-on — and what each one leaves to you.
Read the guide →Help
ShareLane setup and troubleshooting
Shares by rows or whole tab, columns, access, updates and the permissions Google asks for.
Open the help →Help
How updates work
Changed rows, new people, people who left, deleted copies and big shares finished in parts.
Open the help →
Get ShareLane
Their rows, in their own file, up to date.
- One share for up to 3 people free
- View-only, download off by default
- No BiLingoPlus server in between
More tools from BiLingoPlus
Other tools from the same studio
-
Translate Slides with AI
Translate a whole deck into 100+ languages
Google Slides™Free + Premium100 slides free every month · Premium from $9.99/mo billed yearly
-
GridScoop
Export web tables and data grids to Excel & CSV
ChromeFree + Pro300 rows a day free · Pro $15/year
-
Cardwright
Turn highlighted text into flashcards for Anki
ChromeFree + ProFree for 25 cards and 3 decks · Pro $4.99 once
Google Sheets™, Google Drive™, Gmail™ and Google Workspace™ are trademarks of Google LLC. ShareLane is an independent add-on, not made or endorsed by Google.