This guide shows you how to set up a Google Sheet so several people can view and edit it at the same time. You’ll learn the sharing settings, how to send invitations, and how to manage permissions. You’ll need a Google account and the Google Sheets app or a web browser.
What You’ll Need
- A Google account (free)
- The Google Sheets file you want to share
- Email addresses of the people you want to collaborate with (or a link to share)
Step-by-Step
- Open your Google Sheet. Go to sheets.google.com and open the file you want to share. If you haven’t created it yet, click Blank to start a new spreadsheet.
- Click the Share button. In the top-right corner of the screen, click the blue Share button. A dialog box will appear.
- Add people or get a link. You have two options:
- Add people directly: Type their email addresses in the “Add people and groups” field. You can add multiple emails separated by commas.
- Get a shareable link: Click General access (or “Anyone with the link”) and choose the permission level (Viewer, Commenter, or Editor). Then click Copy link to share it via chat, email, or anywhere else.
- Set the permission level. Next to each person’s email (or for the link), choose the role:
- Viewer: Can only see the sheet, not edit.
- Commenter: Can add comments but not change cell values.
- Editor: Can edit cells, format, and share the sheet (if allowed).
For multiple editors, select Editor.
- Send the invitation. If you added people directly, click Send. They’ll receive an email with a link to the sheet. If you copied the link, share it with your team.
- Check that editing is enabled. After sharing, the sheet is automatically editable by all editors. You can verify by looking at the top of the sheet—you’ll see avatars of people currently viewing or editing.
- Set sharing permissions (optional). To prevent editors from sharing the sheet with others, click Share again, then click the gear icon (Settings). Uncheck Editors can change permissions and share. This is useful for sensitive data.
Common Mistakes
- Forgetting to change permission to “Editor” – People may be able to view but not edit. Always double-check the role.
- Sharing the wrong link – If you share a link with “Viewer” access, they can’t edit. Make sure the link’s access level is set to “Editor” if you want editing.
- Not saving changes – Google Sheets auto-saves, but if you’re offline, changes may not sync. Ensure you’re online when editing.
- Overwriting each other’s work – While multiple editors can work simultaneously, it’s easy to accidentally overwrite a cell. Use comments or chat to coordinate.
Tips
- Use named ranges and data validation to prevent errors when multiple people enter data.
- Turn on version history (File > Version history) to see who changed what and when. You can also revert to earlier versions if needed.
- Use the chat feature (top-right) to discuss changes in real-time without leaving the sheet.
- Set up notifications (Tools > Notification rules) to get emails when someone edits the sheet.
- Protect specific ranges (Data > Protect sheets and ranges) to prevent accidental edits to formulas or critical data.
Troubleshooting
People can’t edit the sheet. Check the sharing settings: click Share and ensure the person’s role is “Editor” or the link access is “Editor”. Also, if the sheet is inside a shared drive, the drive’s permissions may override the sheet’s. Ask the drive owner to adjust.
Changes aren’t saving. Google Sheets saves automatically, but if you’re offline, changes are stored locally and sync when you reconnect. Check your internet connection. Also, if you’re using the mobile app, make sure you’re signed in and have storage space.
Someone is locked out. If the sheet is set to “Restricted” (only people added), they must be added by email. If they’re using a different email, they won’t have access. Re-share with the correct email.
Edits are being overwritten. If two people edit the same cell at the same time, the last save wins. To avoid this, use the chat to claim a section, or use the “Protected ranges” feature to lock certain cells.
Link says “You need permission.” This means the link’s access is set to “Restricted.” Change it to “Anyone with the link” and set to Editor, or add the person’s email directly.
Frequently Asked Questions
Can multiple people edit a Google Sheet at the same time?
Yes, Google Sheets supports real-time collaboration. Up to 100 people can view, and up to 50 can edit simultaneously. Changes appear instantly for others.
How do I share a Google Sheet with someone who doesn’t have a Google account?
They can still view or edit if you set the link to “Anyone with the link” and choose Editor. They’ll be prompted to sign in or create a Google account when they try to edit, but they can view without one.
Can I stop someone from editing after I’ve shared it?
Yes. Go to Share, find the person, change their role to Viewer or Commenter, or remove them entirely. You can also revoke the link access.
How do I see who edited what in a shared sheet?
Use File > Version history > See version history. You’ll see a list of changes with timestamps and the editor’s name. You can also click on a version to see the changes.
What’s the difference between a shared drive and a shared sheet?
A shared drive (formerly Team Drive) is a folder where all files are owned by the drive, not an individual. Sharing the drive gives access to all files inside. A shared sheet is just one file shared with specific people. For multiple editors, either works, but shared drives are better for teams with many files.
Can I make a copy of a shared sheet so I can edit it without affecting the original?
Yes, open the sheet and go to File > Make a copy. This creates a new file in your Google Drive that you own. You can edit it freely without affecting the original.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- Disable Autocorrect on iPhone or iPad: Quick Guide
- Custom Keyboard Shortcuts on Windows 11 & macOS
- Restore Windows 11 Display Scaling to Recommended
- Semiconductor Cycle: How Investors Track It0.0
- Microsoft Store Error 0x80073d12: Fixes That Work
- View Notification Count on iPhone: Full Guide