How to Share a Google Sheet (Viewer, Commenter or Editor)

By Gerard Fernandez · Updated · 2 min read

Sharing a spreadsheet lets other people open it in their browser, always seeing the latest version. You decide whether each person can only look, leave comments, or edit.

Share with specific people

  1. Click the Share button in the top-right corner.
  2. In Add people, groups, spaces and calendar events, type an email address.
  3. Choose a role: Viewer, Commenter or Editor.
  4. Keep Notify people ticked to send them an email with the link, add an optional message, and click Send.
Google Sheets Share dialog with the Add people, groups, spaces, and calendar events box, People with access showing the owner, and General access set to Restricted
Real test: add people at the top; General access at the bottom starts as Restricted. (We replaced our test account's name and email.)

What each role can do

RoleViewCommentEdit cellsShare with others
ViewerYesNoNoNo
CommenterYesYesNoNo
EditorYesYesYesYes, by default (the "Allow editors to change permissions and share" setting)

Under General access, change Restricted to Anyone with the link, pick the role on the right, and click Copy link. Anyone who has the link can open the file, without being invited by email.

Be careful with editor links. "Anyone with the link" plus "Editor" means anyone who gets hold of the link can change or delete your data. For public sharing, Viewer is almost always the right choice.

Stop sharing

  • To remove one person, open Share, click the role next to their name and choose Remove access.
  • To turn off link sharing, set General access back to Restricted.

Frequently asked questions

Can I share only one tab of a spreadsheet?

No, sharing always applies to the whole file. Put the data you want to share in a separate file and pull it in with IMPORTRANGE, or protect the tabs editors shouldn't change.

Can viewers download or copy the sheet?

By default, yes. In the Share dialog, click the gear icon. Under People who can download, copy, print, and access via Gemini, untick Commenters and viewers. Both boxes were ticked by default in our test file.

Settings for the spreadsheet: Allow editors to change permissions and share, and People who can download, copy, print, and access via Gemini with Editors and Commenters and viewers both ticked
Real test: the sharing settings behind the gear icon, with the defaults.