Password Protect Google Sheet With These Simple Tricks

Password Protect Google Sheet

If you use your google sheets to add important stuff on the go, you probably want your data to be safe and secured. However, as of now, Google Docs does not have a password protection feature. Thereby your documents are only protected by your primary google account password. In this article, we are going to brief how to Password Protect Google Sheet.

In case you still want to increase security for your files – you can. By encrypting data, you make your data more secure, and if, for some reason, someone accesses your account, they will be unable to read the data without a password you can Password Protect Google Sheet.

How To Set Up A Password Protect Google Sheet

For the very first time, when you choose to Password Protect Google Sheet your files, you will have to set it up. But after that, you can skip the first part and straight go to the next step to encrypt and decrypt your files, and it will take only a few seconds.

If you use a script from tech blog Skipser, it will encrypt all your data in a document and protect it behind a password.

  1. Go to the website.
  2. Go to the Tools option and from there select Script Editor. It will open up a script in a new window.
  3. From there, click on files, then select Manage Versions and click on Save a new version. When you see a new row for version 1, click on ok.
  4. After that, click on Publish.
  5. You will see Deploy as a web app, then click on the Deploy.
  6. The confirmation pops up will appear, select ok. 
  7. At last, when you are finished here, close the window.

Password Protect Google Sheet

How To Protect Files On Google Sheet

Congratulations, you have set up your password to protect Google Sheets; it is easier to encrypt your files from now on.

  1. Click on the protected sheet link, and it will ask you to make a copy of the sheet. Make a copy of your spreadsheet.
  2. Leave the first two rows empty and start adding your data from the third row. Your encrypt URL will appear in the first row of your spreadsheet.
  3. Go up to the main menu bar and click the protect file menu.
  4. Then from the drop-down menu, select the encrypt file option.
  5. The first time it will ask permission to access your Google drive to encrypt your document.
  6. Click ok on Authorization required pop up window, then click accept. The Authorization request will only appear the first time you encrypt your data.
  7. Now go to the main menu and click protect file again.
  8. Then click on the encrypted file option from the menu. A pop-up window will ask you to create a password. Create your password; after that, when you see your data on the sheet, it will be encrypted and thus you can Password Protect Google Sheet.

How To Decrypt

  1. To access your data, you will have to click on the protect file option in the main menu. 
  2. Now select decrypt file option. A pop-up window will appear and ask you to write your password.
  3. When you submit your password, you will be able to see your data. 

After you are finished, you can go to the file option and encrypt your file again.

How To Change The Password Of An Encrypted File

Password Protect Google Sheet

Additionally, whenever you want to, you can change the password of your Google encrypt files.

To change the password:

  1. Go to the Protect File menu.
  2. Select Change Password from the menu options and change the password.

How to Access the Encrypt Spreadsheets on Your Phone

On the URL webpage, you are asked to enter your password. After that, you can click on the go backlink, and from there you can encrypt or decrypt your spreadsheet and Password Protect Google Sheet.

Always remember that you can never be too careful with your data. Make sure to encrypt your Google Sheets before you put anything important in them such as your passwords, bank information, etc. The whole process takes only a few seconds but encrypting data makes Google Sheets more secure.


I hope following these steps will help you to Password Protect Google Sheet. Let us know if you were able to protect your Google sheets.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.