Google Sheets / Getting Started with Google Sheets
Share sheets
When you create a Google sheet, or import a spreadsheet into My Drive, only you will be able to access the sheet. You can share a sheet with everyone in your organisation, or with specific people only. Alternatively, you can remove all restrictions to the sheet, allowing anyone on the Internet to access it. You can revoke sharing permissions at any time so that only you can access the sheet again.
Share a sheet
To share a sheet:
Click on the Share button near the top-right corner of the screen
To share the sheet with specific people only, click in the Add people and groups box and enter the name or email address of each person you want to share the file with, separating each email address with a comma
Choose whether all people added will be able to edit or to view the sheet
An email notification of the share will be sent, providing the invitees with a link to access the sheet - you can type an optional message in the Message box
Click on Send
If you have sent an email notification, the invitee will receive a message in their Inbox, which will contain a link to the shared sheet.
Sharing links
By default, only people you specifically add to Share dialog box will be able to view or edit the sheet.
If you want everyone in the organisation to be able to edit or view the sheet:
Click on the Share button
Click on the Change link along the bottom of the dialog box to change the general access to the sheet
Choose who you would like to be able to access the sheet i.e. everyone at your organisation or anyone with the link
Click on Done
If you set the sheet to be accessible to anyone with the link, you will see when another person opens your sheet, but they will show as anonymous.
In the following screenshot, three people are accessing the sheet - two without signing in, and one from your organisation.
Note that you can only see the photo and name of both internal and external users that have been specifically named in the Share dialog box. For external users, you will only see their details if they have a Google account.
Set an expiration date for a shared sheet
When you share a sheet with colleagues, you can now set an expiration date for the share. If your colleague attempts to access the sheet after the expiration date, their access will be denied. Note that you can only set an expiration date for colleagues that you give view or comment access to in a sheet. If you allow colleagues to edit your sheet, you will not be able to set an expiration date.
Once the person has permission to view or comment on your sheet, you can set the expiration date as follows:
Click on the Share button to view the sharing settings
In the list of people that have access to the sheet, click on the permission next to the perso you wish to change
Choose Give temporary access
Click on the Access expires box
Choose a date for the access to expire
Click on Save
To cancel an expiration date, click on the Share button, then on the Remove expiry link next to the person you wish to allow to continue accessing the sheet.
Disable downloading, printing and copying
When you share a Google sheet, the people you share the sheet with will be able to print, download and make a copy of that sheet, even if they are only given viewing rights to the file. Information Rights Management in Google Workspace allows you to restrict these actions on a shared sheet, meaning that colleagues with view-only access to your sheet will not be able to make copies onto their own Drive, print the sheet or download a local copy.
To restrict the access on a shared sheet:
Click on the Share button near the top-right corner of the screen
Click on the Settings cog near the top-right corner of the Share dialog box
Choose whether editors can change permissions and share the sheet with others
Choose whether viewers and commentors can download, print and copy the sheet
Click on Back to return to the Share dialog box
Click on Done
Change the owner of a sheet
There may be times you need to change the owner of a sheet - if a member of the team leaves the project, or roles change and you wish someone else to take main responsibility for a sheet.
To assign someone else ownership of a sheet that you created:
Click on the Share button near the top-right corner of the screen
Click on the drop-down arrow on the current access status of the person you wish to make the owner of the sheet
Choose Make owner
Click on Yes to confirm that you want to change the owner of the sheet
Click on Done
Once you assign someone else as the owner, you will be given Edit access to the sheet. If you no longer need to access the sheet, click on the X next to your name in the Share window to remove your name from the access list.