Is there a way to secure a Google Sheets?

2 Answers 2


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
    Commented Nov 15, 2010 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
    Commented Nov 15, 2010 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
    Commented Jun 27, 2014 at 21:55

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.

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. Commented Apr 4, 2018 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
    Commented Jul 18, 2019 at 13:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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