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.
For the 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 the tech blog Skipser, it will encrypt all your data in a document and protect it behind a password.
Go back to your spreadsheet, and you will see Protect File icon at the top of your spreadsheets' main menu.
Make it easy by turning data into secure visual reports with Whatagraph.
Congratulations, you have set up your password-protected Google Sheets; it is easier to encrypt your files from now on.
After you are finished, you can go to the file option and encrypt your file again.
Additionally, whenever you want to, you can change the password of your Google encrypt files.
To change the password:
To sum up, take a look at the video presentation to see everything visually.
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 use password protection and encryption for Google Sheets before putting 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.
Published on Dec 05, 2019
Former data analyst and the head of Whatagraph blog team. A loving owner of two huskies, too.
Enter your email and get curated content straight to your inbox!
Only the best content & no spam.