Thank you for subscribing!

It's great to feel loved.

How to Set up a Password Protected Google Sheet

Dec 05, 2019 5 min read

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 password protection feature. Thereby your documents are only protected by your primary google account password.

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.

Table of Contents:

How to Set up a Password Protect Google Sheet

For the very first time, when you choose to password-protect 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 skipser.com 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.

Go back to your spreadsheet and you will see Protect File icon at the top of your spreadsheets' main menu.

Secure visual reports

How to Protect Files on Google Sheet

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

  1. Click on 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 protect file menu.
  4. Then from the drop-down menu, select 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 encrypt 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.

How to Decrypt

  1. To access your data, you will have to click on 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

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

To change the password:

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

To sum up, take a look at the video presentation to see everything visually.

How to Access the Encrypt Spreadsheets on Your Phone

You do not have the Protect File option in the top menu on your mobile Google sheet version. But do not worry, the encrypted URL is in the first row of your spreadsheet. Therefore, when you want to open your sheets on the phone, click on the encrypt/decrypt URL from the first row of your spreadsheet.

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.

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.

Secure visual reports

Mike Bennet
Written by Mike Bennet

To solve the problems of duplications in your workflow, documentation, and data analysis, Google introduced a Google sheet platform that offers a built-in feature to remove duplicates.
Read more...
Mike Bennet
Jun 09, 2020 3 min read
If you’re into digital marketing and CEO, you probably know how much information you have to track and evaluate on a regular basis. Luckily, there’s a free Google sheet analytics add-on that will make it easier for you to access, visualize, understand, share and manipulate data from your Google Analytics in your Google Sheet.
Read more...
Mike Bennet
Feb 03, 2020 5 min read
Add-Ons are third party plugins that add more features in your spreadsheets and provide additional functionality to already powerful Google Sheets.
Read more...
Krystyna Krajevskaja
Jan 31, 2020 6 min read