Is your Google Sheets documentation safe? This is true even if saved in Google Drive. This article will first explain how to protect data in Google Sheets by setting a password, and how to encrypt and decrypt data in Google Sheets.

Protecting your Google Sheets can avoid accidental changes to existing data and customize editing permissions. Here is how to set password protection for Google Sheet to enhance its security:

How to set password protection for Google Sheet

Please follow these steps:

Step 1: Visit Skipser.com and search for "password protect".

Step 2: Scroll down to find the "How to Set Password Protection" article.

Step 3: You can also download the article directly from here, save it to your Google Drive, rename it as needed, and enter the data you want to protect or set a password*. Make sure to start entering data from the third line.

Step 4: Go to the Tools tab and click Script Editor.

Step 5: Next, select "File>Manage Version>Save New Version". You can leave all fields blank and the system displays new rows for version 1. You need to click OK.

Step 6: Now select “Publish” and “Deploy as a web application”. Then, click the Deployment button.

Step 7: You should see a confirmation message that the app has been deployed as a web application.

Step 8: Click the "Protect Files" tab in your Google Sheet. Then click "Initialize".

Step 9: Finally, click "Continue" to grant permission to run the additional script.

How to Encrypt Data in Google Sheet

Next, we will cover how to encrypt data in Google Sheet. Please follow the instructions below:

Step 1: Click the "Protect Files" tab, and then click "Encrypt Files".

Step 2: Create a password that you will share with the selected user.

Step 3: You can see that this encrypts the data by disturbing the contents in each cell. Unless they have the password you created*, no one can read it.

How to change password

If you want to change your password, you can follow these steps:

Step 1: Go back to your Sheet and click "Protect File" in the top navigation bar.

Step 2: Select "Change Password" from the menu.

Step 3: Enter your new password and click Submit.

How to access protected Google Sheet on your phone

If you want to access a protected Google Sheet on your phone, you can follow these steps:

Step 1: Open Sheet on your phone.

Step 2: Click on the "Encrypt/Decrypt" URL on the first line of Sheet.

Step 3: You now need to enter your password.

Conclusion

While Google Sheets is automatically saved to your Google Drive, it is recommended that you add an extra layer of security to important spreadsheets to protect your important data. Hope this article helps you.

The above is the detailed content of [Full Guide] – How to Password Protect Your Google Sheet/Data? - MiniTool. For more information, please follow other related articles on the PHP Chinese website!