Google Sheets allows you to share & collaborate with your project team on the same spreadsheets, in real time from multiple devices.
To share a spreadsheet with your project team, click the share button in the upper right hand corner.
Once you click share you have 2 different options for sharing the spreadsheet.
Sharing with specific people using their email addresses:
First you can share the spreadsheet with specific people using their email addresses.
1. To share the spreadsheet with specific people, you can simply add the email addresses of your project team.
2. Next, select the user preferences as to what they do with file such as editing, commenting only, or viewing only.
3. Once you add the user to the spreadsheet file, they will get an email notification granting them access to the spreadsheet.
Publishing to the web & sharing link (not recommended)
The 2nd option for sharing your spreadsheet is to publish your spreadsheet to the web, so anyone with the link will be able to access, view & potentially edit your spreadsheet file. Because of privacy reasons, we do not recommend utilizing the share link option.