How To Password Protect Google Sheet {Simple Method}

Are you looking for the easier way to how you could password protect Google sheet? Quite Obvious.

We all like to protect the data in the easiest way we can. No wonder, there are plenty of data which we store online, as we want to access the information on the go.

We all do that, instead of writing the information on a piece of paper and carrying with us, those are ancient days.

And that is completely fine, as it is online and the account is password protected so no one else would be able to access it.

Do you think so?

But the important thing on which we need to put some light over here, the Gmail, Google sheet, etc. Where we have all the important information and can be accessed if the Gmail Account is compromised or hacked.

In this scenario, Google Docs Security is one of the priority. Isn’ it? If yes let us dive in and see how to protect Google Sheet in simple steps?

Why Password Protect Google Sheet

Assigning a password to the file, or even encrypt that data will definitely solve out the problem and make the Google Docs more secure, does it sounds cool..!! Lets us get int and see how to encrypt a google sheet.

Encryption is something which we should always do with sensitive data. So that even if the un trusted person accesses your devices, they will not be able to read the data without a password.

As after encryption, it won’t be readable at all. Excited…then let us get into the process of encrypting Google Sheet.

Also Read: How To Send an Encrypted Email

Here is the quick video, to help your password protecting Google Sheet.

How to Encrypt Google a Spreadsheet: Unlock sheet with a password

As by default, we do not have such option to Encrypt the data, but thanks to who have made it possible. Let us see how.

Step 1. Login to your Google Drive Account and Open a Spreadsheet.

Note: As mentioned above here by default you won’t be able to see any encryption option in Google Docs. The menu will be looking like the below image.
Google Sheet Menu

Now though we want to encrypt Google Spreadsheet, so we need some obvious option or some script which adds some extra protection to the sheet.

So click on this, and make a copy of it, as you want to be the owner of the spreadsheet which we want to protect.

Note: This adds a code in the script editor and allows one more menu to get added, to encrypt Google spreadsheet and make it password protect files.

Step 2. Click on the first link URL to Encrypt/Decrypt – This will open in the new tab and run a script. And you will one see an additional option in the menu Protect File in your spreadsheet. If you don’t, then reload the spreadsheet.

Step 3. Now input your data in the sheet(Or copy and paste here the existing one) which you want to protect, and

Click on Protect File  – Encrypt file – And then Click on Continue, to Authorize it.

Encrypt file

Click on Allow and grant the permission and script to access your Gmail account.

request permission

A small pop-up will be asking for the password which you want to assign for that spreadsheet to encrypt it. Assign a strong password and make sure you remember it.

Once done you will be able to see your data like the below image which won’t be readable at all. So now your data is entirely encrypted.

Decrypt the Google Spreadsheet

Step 3. If you want to see the data back again, then again go back to Protect File menu and click on Decrypt File and enter the same password which you have entered while encrypting the Google Spreadsheet.

Google sheet encrypted password

Once entered the password you will be able to see your protected data back again as shown in the below image.

Yay ..wasn’t that simple…!!!

data decrypted google sheet

How cool is that as we have a password to your account as well as the password for some critical spreadsheets. In this way, we can be sure that our data is 100% protected in all the devices.

Wondering How Secure Is Google Docs or Google Sheets?

Does the question arise?

Off-course its safe, but why not to add some extra protection like put a password on a file or encrypt google spreadsheet, don’t you think so?

Because there is always a loophole, just assume, Google Docs where we store such data and that account is signed in on your mobile or any other device.

Unfortunately, if it got lost or got into the hands of some untrusted person and who might be accessing the information from it,

So, in this case, our data is safe?.. of course not…! Data protection is always a priority for anyone..!

Data protection is always a priority for anyone..!

4 thoughts on “How To Password Protect Google Sheet {Simple Method}”

  1. How can I use this to protect different sheet? I’m not able to copy the script directly to new sheet and there doesn’t seem to be any option to use this script to protect other sheets

    Can you help on that?

  2. I have followed the steps but the option ‘Protect File” is not visible on the copied spreadsheet menu – any suggestions?

    Thank you!

Leave a Comment


Subscribe To QuestionCage

Glad to see your Visit at QuestionCage!

One more step to connect ahead "Subscribe to Us" and get the updates to your inbox directly.

You have Successfully Subscribed to QuestionCage!

QuestionCage Logo Main

Better Security for your WordPress Blog

Get rid of all the Malware injections and stay away from vulnerabilities. Spend a few minutes and sleep tight. 

You have Successfully Subscribed!