5

Is there a way to secure a Google Sheets?

3

Your spreadsheets are already all password protected, in that one must log in with their google account (and thus password) to view the spreadsheet. You can control who may access the spreadsheet by clicking on the "share" button in the upper right and editing what permissions users with access to the spreadsheet are given.

  • The only problem is people who dont have gmail accouts need to be able to edit the spreadsheet. – Anders Nov 15 '10 at 20:07
  • Ah. Unfortunately, there isn't any way to control access unless you either make it open to everybody or else they sign up for a google account. One doesn't need a gmail account specifically though; you can sign up for a google account with your existing email. – nhinkle Nov 15 '10 at 20:51
  • 1
    You can make it accessible only by people who have a link. This security through obscurity: the link is very long and very hard to guess. – Bryce Jun 27 '14 at 21:55
0

Yes, you can use the google script from here to have a password-protected spreadsheet. It gives you two options - encrypt and decrypt. You can set a password and if the password is wrong, all you will see is obfuscated text.

http://www.skipser.com/p/2/p/password-protect-google-drive-document.html

https://www.questioncage.com/how-to-password-protect-google-sheet/

nhingle's answer is correct, but most people are logged into Google 24 hours a day on phones and PCs. That means if somebody has access to these momentarily, they have full access to google docs as well.

  • People able to run scripts from a custom menu have editor access and people having editor access have access to the spreadsheet version history so this isn't secure. – Rubén Apr 4 '18 at 19:13
  • 1
    @user0 did you perhaps copy the link from the other post here? That was spam. You might want to revert it here – Suraj Rao Jul 18 at 13:16

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.