How to lock sheet in google sheet

Have you ever wondered if your online documents are secure? Even if you save them in your Google Drive, adding extra protection to those with more sensitive data is always a good idea. To address this issue, we recently spoke about how you can lock data in Google Sheets by giving or restricting editing permissions to other users. However, you may also deal with sensitive or confidential information that you wish to restrict from users outside your team. With the help of the third-party tool Skipser, you can password-protect your Google Sheets to keep your documents extra safe.

This article will first show you how to secure data on your Google Sheet by setting up a password; it will then describe the necessary steps to encrypt and decrypt the data. Lastly, it will stress the importance of updating your password to ensure that you fully control the data shared on your Google Drive.

How to password-protect a Google Sheet?

Google Sheets does not provide any feature to protect or encrypt your data within the spreadsheet, and the only available security measure is your Google account email ID and password. Considering that it is too risky to rely only on this, we have found a solution that will allow you to create that secure and encrypted system for yourself and your business.

Let’s begin:

1. 1. Go to Skipser.com and perform a site search for “password protect”.

1. 2. Then, scroll down to find the “How to Password Protect” article.

1. 3. You can also directly download it from here, save it on your Google Drive, rename it as you wish, and enter the data you want to protect or set a password to*. Make sure you enter the data from the third row onwards.

*As the image above shows, the Protect File tab is already visible, so you can skip the following steps and move on to the next section on How to encrypt your data in a Google Sheet. If you do not see the Protect File tab, keep reading.

1. 4. Navigate to the “Tools” tab and click on “Script Editor.” A script should come out in a new window or tab.

1. 5. In this new window, select “File,” then “Manage Versions,” and finally "Save a new version.” You can leave all fields blank, and a new row for version 1 will show up. You simply need to click on "OK.”
2. 6. Now select "Publish” and “Deploy as webapp.” Then, click on the "Deploy" button.
3. 7. You should see a confirmation indicating that the app has been deployed as a web app.
4. 8. You should now be able to see a “Protect File” tab in your Google Sheet. Click on this tab and then click on “Initialize.”

1. 9. Finally, click “Continue” to give permissions to run the script attached.

Your Google Sheet is now ready to keep storing data safely and securely - a one-time procedure to not have to worry about doing it again. Simply don’t forget to keep the first two rows intact!

How to Password-Protect an Excel File?

If you work with important data in Excel, you probably want an extra layer of protection. Here's how to password protect an Excel file

READ MORE

How to encrypt your data in Google Sheets?

Now that your Google Sheet is password-protected, here is how to encrypt the data so that only users that have the password can view the information:

1. 1. Click on the “Protect File” tab and then “Encrypt File.”

1. 2. Create a password that you will share with your selected users.

1. 3. As you can see, this has encrypted the data by scrambling the contents within each cell. Nobody will read it unless they have the password* you created.

*The password set up in this section is NOT your Google account password - it is the password to be used for all further encrypt/decrypt requests.

How to change the password of an encrypted file?

We often share passwords with colleagues or team members that either cease to work on the same project or the nature of the data we share becomes highly confidential. Don’t worry, similar to how it was created, users can easily change the password of the encrypted file:

1. 1. Go to the “Protect File” tab and click on “Change Password.”

1. 2. Enter the old password and try to make the new one as different as possible.

Like any other online platform that stores sensitive data, it’s good to update your password frequently. However, this can become a cumbersome task for which we often end up creating passwords that are too simple or common so that they’re easy to remember.

In the era of digital attacks and the need for cybersecurity, here are a few points by Google Account Help to take into consideration when creating a password - whether you are a single user or an administrator in charge of a team:

1. 1. Make your password unique.
2. 2. Make your password longer but memorable.
3. 3. Avoid using personal information or common words.

How to decrypt your data in Google Sheets?

We have already seen how you can encrypt your Google Sheet; however, you may want to read the information or delegate a task that would require sharing the password so it can be decrypted.

Here is how:

1. 1. Go to the "Protect File” tab and select “Decrypt File.” Once again, you will be asked to enter the password.

1. 2. Once entered, you can now read the cell contents and edit as you wish*.

*Make sure you don't edit or make changes to the encrypted document. If you do so, the decryption process won't retrieve the original content. Remember that the attached script is your local copy and runs entirely within your Google account. Nobody else has access to anything, including the password you set.

How to access an encrypted sheet on your phone?

The encryption and decryption of data in Google Sheets work well when using a computer device. However, most of us work on our phones, especially when it comes to urgent or last-minute tasks. If you are using your phone right now, you won’t get the "Protect File" tab on your spreadsheet. Therefore, follow these steps if you want to access the encrypted sheet on your phone:

1. 1. Click on the encrypt/decrypt URL in the first row, as shown in step 3 of this article.
2. 2. The URL is created and added once you click on “Deploy,” as shown in Step 6 of the first section of this article.
3. 3. Once the URL fully loads, a window is shown to enter your password to encrypt or decrypt the document.
4. 4. Once encrypted/decrypted, you can select "Go back." A clickable link will now show, which will load the encrypted/decrypted Google Sheet.

How to protect Google Sheets data with Layer?

Layer adds productivity features to your Google Sheets. Share parts of your spreadsheet, request input, and accept or reject changes to make collaboration seamless and more efficient while keeping full control over your data.

Using Layer, you can:

• Manage Access: Give spreadsheet access to relevant stakeholders on a tab or cell level.
• Review & Track: Consolidate input, and easily track changes.
• Collaborate: Define, assign, and automate tasks and set deadlines.

Sign up for early access and start automating your Google Sheets workflows with Layer!

Conclusion

Although the sensitive or confidential information we usually share is not restricted to Google Sheets, the online platform is definitely a place where most of us store personal and professional documents including sensitive information such as passwords, phone numbers, bank account details, payment details, etc.

Google currently offers many tools to help businesses work online as a team; however, this also means that sensitive or confidential information stored in the cloud is growing exponentially. As we expressed initially, the key question is, are Google Sheets secure? In theory, yes. In practice, no. Nowadays, your Google account password is not enough to guarantee your Google Sheets security.

This article has shown how you can password protect a Google Sheet in a few simple and easy steps, encrypt and decrypt a Google Sheet, and change the password at any time from any device, both computer and mobile phone.

Hady is Content Lead at Layer.

Hady has a passion for tech, marketing, and spreadsheets. Besides his Computer Science degree, he has vast experience in developing, launching, and scaling content marketing processes at SaaS startups.

How do I lock an entire sheet?