view<\/strong>. There are many different situations in which you would benefit from using all four permissions when dealing with Google Sheets.<\/p>\nLet\u2019s say I\u2019m the owner of a Google Sheets file that\u2019s dedicated to our sales data from this quarter. I\u2019d need some of my Sales team members to edit in order to add the sales information to the spreadsheet. I\u2019d want members of other departments like Finance to comment on the data to provide insights into how these sales compare to our previous quarter.<\/p>\n
Finally, I might want to give our CFO view access in order to take a quick look over the file and make sure that they approve of our work.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/GS-permissions.png” alt=”Google Sheets permissions 0″ title_text=”GS permissions” align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
1. Ownership<\/h4>\n
The Ownership<\/b> level in Google Sheets is given to the person who created the file by default. With this permission level, you can do almost anything in the file, including viewing the content, adding or modifying comments, deleting comments, or even deleting the entire spreadsheet. There is only one person who has the ownership permission level, and you cannot assign this permission to anyone else.<\/p>\n
In order to confirm whether you have ownership, open your spreadsheet and head to File > Share<\/b>. The pop-up should clearly indicate whether you have ownership with the title \u201cOwner\u201d next to your name.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/GS-permissions-1.png” alt=”Google Sheets permissions 1 Ownership” title_text=”GS permissions 1″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
2. Edit<\/h4>\n
The Edit<\/b> permission in Google Sheets allows you to modify the content within the spreadsheet. This includes adding content, editing content, or even deleting content. You can also add or reply to comments. Finally, you can also choose to share the Google Sheet with others.<\/p>\n
Let\u2019s say I grant edit access to some of my Sales team members. This means that they can edit any of the data in the \u2018Total sales\u2019 column, or even add data for an entirely new department. They can also comment on cells containing data they aren\u2019t confident is up-to-date, or choose to share the spreadsheet with another Sales team member.<\/p>\n
To grant Edit<\/b> access to someone, head to File > Share<\/b>. Search for their name or email address in the search field, and click on their profile when it appears. Then, in the dropdown to the right of this search field, click on the Editor<\/b> permission status. Finally, add a customized message if you wish, and finish by clicking Send<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/GS-permissions-2.png” alt=”Google Sheets permissions 2 Edit access” title_text=”GS permissions 2″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
3. Comment<\/h4>\n
The Comment<\/b> permission level slightly reduces the amount of freedom a user has within Google Sheets. At this level, you can only view the Sheet and add comments through the commenting feature. You can also reply to other people\u2019s comments. If you want to share the file with someone else, you must send a request to the original owner of the Sheet, who will then grant access.<\/p>\n
In my use case, I may grant Comment<\/b> permissions to people outside of my department who may have some suggestions or interesting insights that may relate to my data. For example, if I granted this permission level to the Finance department, they could add comments that included the insights from the last sales quarter, which would be useful to help compare our results. They may also request to share the spreadsheet with another one of their Finance members who has specific insights that would benefit our spreadsheet.<\/p>\n
In order to grant the Comment<\/b> permission level to people, head to File > Share<\/b>. Then add the user\u2019s name, and click the dropdown menu in the top right corner and select Comment<\/b>. Again, you can add a customized comment and finish by clicking Send<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/GS-permissions-3.png” alt=”Google Sheets permissions 3. Comment only” title_text=”GS permissions 3″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
4. View<\/h4>\n
The View<\/b> permission is the lowest level of permission in Google Sheets. It only grants the user the ability to view the document. They cannot edit, comment, or share the file. They can, however, request the owner to grant them permissions as necessary.<\/p>\n
The View<\/b> permission level in my use case is perfect for members outside my organization who need to access the Google Sheet, or perhaps members within my company who only need to oversee the operation. For example, I may grant View permission to the CFO, so that they know exactly what we are doing without having anything to add to it.<\/p>\n
Much like the previous permissions, access the permission pop-up by heading to File > Share<\/b> within your spreadsheet. Add users via their name or email, then select the View<\/b> permission level. Finish by adding a customized message (optional), and pressing Send<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/GS-permissions-4.png” alt=”Google Sheets permissions 4. View access” title_text=”GS permissions 4″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
How do I set permissions in Google Sheets?<\/h3>\n
Granting different permission levels in Google Sheets is easy; simply open your spreadsheet, and head to File > Share<\/b>, and add your team members.<\/p>\n
From this blog post, you should now be able to understand the differences in permission levels within Sheets and know how to implement them into your own operations. If you would like to learn more about how to make the most of Google Sheets, why not take a look at our post on How to find and replace in Google Sheets?<\/a><\/p>\nAlternatively, check out our related blog posts below!<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ background_color=”#f9f9ff” custom_margin=”40px||40px||false|false” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Google Sheets is one of the most popular tools used by businesses today thanks to its most valuable feature – its collaborative ability. With Google Sheets, not only can you share your files with anyone you wish, but you can also grant specific permissions. This allows you to control exactly how much responsibility your team […]<\/p>\n","protected":false},"author":41,"featured_media":38336,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Google Sheets is built around one central pillar - collaboration. This cloud-based application is at the forefront leading this innovation to make it as simple and as ubiquitous as possible. One just needs to have a browser to access the Google Sheets, as it is both device and location independent. And what's more? We have various kinds of Google Sheets permissions<\/strong><\/em>, each having its own specific purpose. We will explore those options in this article.\nTypes of Google Sheets permissions<\/h3>\nBy virtue of creating or sharing the files, the users of Google Sheets will have one of the following four Google Sheets permissions<\/strong><\/em>.\n\n \t- Ownership<\/li>\n \t
- Edit<\/li>\n \t
- Comment<\/li>\n \t
- View<\/li>\n<\/ul>\n
Permission level # 1: Ownership<\/h4>\nAnybody who creates a new Google Sheets file using their own account, enjoys this permission level by default. With this privilege, we can do pretty much everything with the file.\u00a0We can view the contents, add or modify comments, edit the contents or even delete the spreadsheet if needed.\n\nTo confirm, we can click on Share<\/strong> button and then click on the Advanced<\/strong> option. The Sharing settings window clearly displays that the user who created this spreadsheet (Fred) is the owner.\n\nExample<\/strong> ![\"Google](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/sharing1.png\")
\nPermission level # 2: Edit<\/h4>\nIn situations where we want other people to be able to modify the content on the spreadsheet we created, we choose to grant Edit<\/strong> permission. With this privilege, users will be able to view and modify the content, in addition to being able to add comments to the cells. Lastly, they will also be able to share the file with other users.\n\nTo grant this permission, we click on the Share<\/strong> button. On the Share with others<\/strong> window that pops up, we add the email(s) of users whom we'd like to share the file with. Now, click on the drop-down button adjacent to the People<\/strong> field, and ensure it is Can edit<\/strong> (shows the pencil icon). Clicking on Send<\/strong>\u00a0will accordingly grant Edit<\/strong> access permission level to the user(s).\n\nExample<\/strong> ![\"Google](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/sharing2.png\")
\nPermission level # 3: Comment<\/h4>\nLet us consider a scenario. We created a spreadsheet on which we need another user to review. But we do not want him\/her to accidentally modify the content. We can make use of the\u00a0Comment<\/strong> permission level. With this privilege, users will be able to view the file and add comments to the cells. They won't be able to share the file to other users directly. Instead, they will be able to request the owner who may grant permissions as needed.\n\nTo enable a user with Comment<\/strong>\u00a0Google Sheets permission level, we click on the Share<\/strong> button. On the pop-up window, we add the email(s) of users whom we'd like to share the file with. Now, click on the drop-down button adjacent to the People<\/strong> field, and ensure it is Can comment<\/strong> (shows the message icon). Clicking on Send<\/strong>\u00a0will accordingly grant Comment<\/b>\u00a0privilege to the user(s).\n\nExample<\/strong> ![\"Google](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/sharing3.png\")
\nPermission level # 4: View<\/h4>\nIf we need the users to only have a look at the data in the spreadsheets, View permission level is sufficient. In this case, users will not be able to do any of the activities the users with other permission levels are capable of doing.\u00a0Users won't be able to directly share the file with other users. Instead, they will be able to request the owner to grant permissions as necessary.\n\nThe procedure to grant View<\/strong> Google Sheets permission level is very similar to that of the previous steps. Except, we choose the Can view<\/strong> option (the eye icon) in the drop down.\n\nExample<\/strong> ![\"Google](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/sharing4.png\")
","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-7231","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/7231","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=7231"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/7231\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/38336"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=7231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=7231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=7231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/run-automatically-connect-sheet-icons.webp\")
<\/p>\n![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\")
<\/p>\n