Share & collaborate on a spreadsheet

 

On this page

• Share a spreadsheet with specific people
• Share a link to a spreadsheet
• Unshare a spreadsheet
• Comment on a spreadsheet
• Chat with collaborators in a spreadsheet

               

Want advanced Google Workspace features for your business?

Try Google Workspace today!

 

 

Share a spreadsheet with specific people

Note: Sharing options vary by group size:

• Up to 100: You can let up to 100 people with view, edit, or comment permissions work on a Google Docs, Sheets, or Slides file at the same time.
• 100 or more: When 100 people or more are accessing a file, only the owner and some users with editing permissions can edit the file. To let more than 100 people view your file at the same time, publish it as a web page instead.

1. Select the file you want to share.
2. Click Share or Share .
3. Enter the email address or Google group you want to share with.
4. To decide what role people will have on your file, select Viewer, Commenter, or Editor.
5. If your account is eligible, you can add an expiration date for access.
6. Choose to notify people.
   • If you want to notify people that you shared an item with them, check the box next to Notify people. If you notify people, each email address you enter will be included in the email.
   • If you don't want to notify people, uncheck the box.
7. Click Send or Share.

Learn more at the Drive Help Center

Share a link to a spreadsheet

You can choose if your file should be available to anyone or restricted to only the people with access. If you allow access to anyone with the link, your folder won't restrict who can access it.

1. Select the file you want to share.
2. Click Share or Share .
3. Under “General access”, click the Down arrow .
4. Choose who can access the file.

5. To decide what role people will have with your file, select Viewer, Commenter, or Editor.
   • Learn more about how others view, comment, or edit files.
6. Click Done.

Learn more at the Google Docs Editors Help Center

Unshare a spreadsheet

Stop sharing a document you own

1. Find the file or folder in Google Drive, Google Docs, Google Sheets, or Google Slides.
2. Open or select the file or folder.
3. Click Share or Share .
4. Find the person you want to stop sharing with.
5. To the right of their name, click the Down arrow   Remove access.
6. Click Save.

Restrict access to a spreadsheet you own

1. Find the file or folder in Google Drive, Google Docs, Google Sheets, or Google Slides.
2. Open or select the file or folder.
3. Click Share  or Share   Copy link .
4. Under “General access”,  click the Down arrow .
5. Select Restricted.
6. Click Done.

Learn more at the Google Docs Editors Help Center

Comment on a spreadsheet

1. On your computer, open a document, spreadsheet, or presentation.
2. Highlight the text, images, cells, or slides you want to comment on.
3. To add a comment, in the toolbar, click Add comment .
4. Type your comment.
5. Click Comment.

Chat with collaborators in a spreadsheet

1. On your computer, open a document, spreadsheet, or presentation.
2. At the top right, click Show chat . This feature won't be available if you're the only one in the file.
   1. Tip: If there are many collaborators in the file, at the top right, to the right of the avatars, there will be a blue circle showing the number of additional collaborators. Click the blue circle  Join chat .
3. Enter your message in the chat box.
4. When you’re finished, at the top right of the chat window, click Close .

Note: All chats in Google Docs, Sheets, and Slides include anyone viewing the file. The chats aren't saved.

_{Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.}