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, like some bank usernames, passwords, our social account login credentials, bank account numbers, PAN No. 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?
Table of Contents
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 untrusted 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 Skipser.com who have made it possible. Let us see how.
Step 1. Login to your Google Drive Account and Open a Spreadsheet.
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.
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.
Click on Allow and grant the permission and script to access your Gmail account.
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.
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…!!!
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..!