3

Given some Google Sheet I'm aware of the Share button in the top right corner. However, the default settings allow anyone with the share url to edit the sheet.

Is it possible to set permissions so the file is read-only?

5

When you pull up the share menu - click the little drop down an choose "view"

enter image description here

ALso if you want to disable copying and downloading, click on "advanced" on the bottom right and check the 2 boxes at the bottom

enter image description here

  • Is it possible to add the users to the list through google REST API's ? – astre Apr 3 '18 at 4:59
  • Is there a way to share the link with read only access? I want to make a sheet publicly available, but with read only access for anyone but me. – kiml42 Aug 15 at 15:22
  • @kiml42 yes the permission is called view only – Aurielle Perlmann Aug 15 at 20:32
0

You can set the permissions for link access in a similar way to the previous answer.
From the sharing popup - click advanced. This adds a row for public access, set to off by default. You can click it to access the Link Sharing popup in which you can set it to be publicly accessible to those with the link. Once you've turned link sharing on a drop-down appears to select what public users can do - either view only, view and comment or full edit access.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.