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
- Open the spreadsheet you want to share
- Click the Share button in the top-right corner
- Enter email addresses or a Google group name
- Set permission to Editor from the dropdown
- Click Send to notify collaborators by email
- Or set General access to Anyone with the link, choose Editor, and click Copy link
- Share the copied link directly with your team
Interactive 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
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.
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.
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.
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.
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.
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.
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.
Related guides
Continue with more step-by-step guides for getting work done.
How to create a filter in Google SheetsLearn how to create a filter in Google Sheets to sort, hide, and analyze data quickly using the built-in filter tool on any free account.
How to search in Google SheetsLearn how to search for text, numbers, or formulas in Google Sheets using Ctrl+F to find matches and Ctrl+H to replace them.
How to freeze rows in Google SheetsLearn how to freeze rows in Google Sheets so headers stay visible while scrolling, plus how to adjust or remove frozen rows.
How to shift cells down in Google SheetsRight-click a range and choose Insert cells > Shift down, or press Ctrl+Alt+= (Cmd+Option+= on Mac). Everything below moves down. See the interactive demo.
How to sort a table A–Z in Google SheetsSort a table in Google Sheets A to Z or by several columns without scrambling rows. Keep the header in place, or sort with a formula instead.
How to subtract in Google SheetsLearn how to subtract numbers, cells, and dates in Google Sheets using formulas, the MINUS function, and cell references.
Create interactive demos like this one — free, no coding required.
Start for free →