This article explains how to share Google Sheets, the platform’s free online spreadsheet application. Additional information covers how to share Sheets in Google Workspace.

What to Know

  • Open spreadsheet > select Share > add emails > use down arrow to set users’ permissions > add note to invite > Send.To send just the link itself, select Share > Copy Link from Get link box > paste into an email.

How to Share a Google Sheets File

To share a Google Sheets file, add the email addresses of your invitees, include a note, then send the invitation. You can determine whether recipients may just view your spreadsheet, or also comment on, or edit it.

  • Log in to Google Sheets and create or open the spreadsheet you want to share.
  • In the top-right corner of the screen, select Share.
  • In the Share With People and Groups dialog box, add the email addresses of the people you want to invite to view, comment on, or edit your Google Sheets file.
  • Next to the email address field, select the down-arrow and choose one of the three options: Editor, Viewer, or Commenter.
  • Your choice will depend on how much you want recipients to be able to interact with the file. Editor means the recipients can make changes to the file. Commenter means they can’t change anything but can make comments. Viewer means they can only view the file without making any changes or comments.
  • Add a note to accompany the invitation, then select Send.
  • Alternatively, open your Google Sheets file, select Share, and in the Get link box, choose Copy Link. The link is copied to your clipboard, and you can paste it into an email message to send to recipients that way.
  • To stop sharing a Google Sheets file, select Share. In the drop-down menu next to the collaborator’s name, select Remove.

Sharing Sheets in Google Workspace

Google Sheets is also part of Google Workspace, an integrated collaboration environment that merges Gmail, Chat, and Meet. Google Workspace is free to anyone with a Google Account, though there are paid subscriptions that offer additional capabilities and features for organizations.

When you share a Google Sheets file, all invitees must have a Google account before they can view it. Creating a Google account is easy and free. If invitees don’t have an account, a link on the Google login page takes them to the account registration page.​​

Log in to Google Sheets and create or open the spreadsheet you want to share.

In the top-right corner of the screen, select Share.

In the Share With People and Groups dialog box, add the email addresses of the people you want to invite to view, comment on, or edit your Google Sheets file.

Next to the email address field, select the down-arrow and choose one of the three options: Editor, Viewer, or Commenter.

Your choice will depend on how much you want recipients to be able to interact with the file. Editor means the recipients can make changes to the file. Commenter means they can’t change anything but can make comments. Viewer means they can only view the file without making any changes or comments.

Add a note to accompany the invitation, then select Send.

Alternatively, open your Google Sheets file, select Share, and in the Get link box, choose Copy Link. The link is copied to your clipboard, and you can paste it into an email message to send to recipients that way.

To stop sharing a Google Sheets file, select Share. In the drop-down menu next to the collaborator’s name, select Remove.

If you’re using Sheets within Google Workspace, you’ll share a Google Sheets file the same way as you would in the standalone application. Select the file, click Share, then add your recipients and choose their editing or viewing privileges.

Get the Latest Tech News Delivered Every Day