How to share a Google Sheet for editing

Learn how to share a Google Sheet for editing using email invites or shareable links, and control who can edit, comment, or view your data.

Quick answer

Open your spreadsheet, click the Share button in the top-right corner, then enter the email addresses of people you want to invite. Set their permission level to Editor from the dropdown menu, then click Send. Recipients receive an email with a link granting them full editing access to the sheet.

Steps at a glance

  1. Open the spreadsheet you want to share
  2. Click the Share button in the top-right corner
  3. Enter email addresses or a Google group name
  4. Set permission to Editor from the dropdown
  5. Click Send to notify collaborators by email
  6. Or set General access to Anyone with the link, choose Editor, and click Copy link
  7. Share the copied link directly with your team

Interactive demo

Loading demo…

Summary

Google Sheets lets you grant editing access to specific people or anyone with a shareable link, so multiple collaborators can update the same spreadsheet at once. Owners control permission levels for each person, deciding who can edit, comment, or only view the file.

Step-by-step guide

  1. Step 1

    Open the spreadsheet you want to share

    Go to your Google Sheets home screen and open the file you own or already have edit access to. Make sure you're signed into the correct Google account, since sharing permissions are tied to your account.

  2. Step 2

    Click the Share button

    In the top-right corner of the spreadsheet, click the blue Share button. This opens the Share dialog, titled with your file's name, where you manage all access settings.

  3. Step 3

    Enter email addresses

    Click the Add people, groups, spaces, and calendar events box and type the email address of each person you want to invite, or a Google group name.

  4. Step 4

    Set the permission level to Editor

    Click the role dropdown next to the address box and choose Editor instead of Viewer or Commenter. Editor access lets collaborators change cell values, add rows, apply formatting, and even create a chart or filter within the sheet.

  5. Step 5

    Add a message and click Send

    Optionally, type a short note explaining why you're sharing the file. Leave Notify people ticked and click Send to email each person a direct link to the spreadsheet with their assigned editing permissions.

  6. Step 6

    Or share a general access link

    Instead of naming individuals, open the 'Restricted' dropdown under General access and select 'Anyone with the link.' Set the role next to it to Editor so anyone who opens the link can make changes, then click Copy link and paste it into an email or chat message.

  7. Step 7

    Review or update sharing settings anytime

    Reopen the Share dialog whenever you need to add new collaborators, change someone's permission level, or remove access entirely. This is also a good time to double-check data using search before granting broader edit access.

Why this matters

You've built a budget or project tracker and now need teammates to update numbers directly instead of sending you edits over email. Sharing with editor access lets everyone work in the same file in real time, avoiding version conflicts and outdated copies.

Frequently asked questions

  • What's the difference between Editor, Commenter, and Viewer access?

    Editor access lets someone change cell content, add sheets, and adjust formatting. Commenter access allows comments without changing data directly. Viewer access only permits reading the spreadsheet with no ability to modify it.

  • Can I share only part of a spreadsheet instead of the whole file?

    Not directly: sharing always covers the whole file. To stop editors changing certain parts, select a sheet or range, click Data, then choose Protect sheets and ranges and set who can edit it.

  • How do I stop someone from editing a sheet after sharing it?

    Open the Share dialog, find their name in the list, click the dropdown next to it, and select Remove access. This immediately revokes their editing permissions.

  • Can I limit collaborators from downloading or copying the sheet?

    Yes. In the Share dialog, click the settings gear icon and uncheck the options that allow editors and commenters to download, print, or copy the file.

Create interactive demos like this one — free, no coding required.

Start for free →