Search code examples
google-sheetsgoogle-docs

How to change Google Sheet to "Viewing" while having "Editing" access?

For Gdocs, Edit access can be changed to Viewing to avoid unwanted changes.

enter image description here

How can that be done for Gsheets?

Solution

  • There's no button in the UI for it, but there is a "Preview" mode available for Google sheets. To get to it you need to edit the URL.

    The URL of a sheet in normal editing mode ends with something like ...sOmE-lOnG-ID/edit#gid=1234567. Remove the /edit and everything after it, and replace it with /preview. Hit enter to refresh the page.

    It will load a data-only view, no toolbars or anything. Useful to avoid making any changes, though unfortunately there's no commenting feature like Docs has.