Have you ever wondered if your online documents are safe? Even if you save them in Google Drive. This article from MiniTool will first show you how to protect data on Google Sheets by setting a password. Besides, you can know how to encrypt and decrypt data in Google sheet.
Protecting your Google Sheets allows you to avoid making unprecedented changes to existing data. In addition to protecting your sheets, you can customize who can adjust editing permissions. Now, we will teach you how to password protect Google Sheet to make it more secure.
How to Password Protect Google Sheet
Here is how to password protect Google Sheet. Follow the guide below:
Step 1: Go to Skipser.com and search for password protect.
Step 2: Then, scroll down to find the How to Password Protect article.
Step 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.
Step 4: Go to the Tools tab and click Script Editor.
Step 5: Next, select File > Manage Versions > Save a new version. You can leave all fields blank, and a new row for version 1 will show up. You need to click OK.
Step 6: Now select Publish and Deploy as webapp. Then, click the Deploy button.
Step 7: You should see a confirmation indicating that the app has been deployed as a web app.
Step 8: Click the Protect File tab in your Google Sheet. Then click Initialize.
Step 9: Finally, click Continue to give permissions to run the script attached.
How to Encrypt Your Data in Google Sheet
Then, we will teach you how to encrypt your data in Google Sheet. Follow the instructions below:
Step 1: Click the Protect File tab and then Encrypt File.
Step 2: Create a password that you will share with your selected users.
Step 3: As you can see, this encrypts the data by scrambling the content in each cell. No one will read it unless they have the password* you created.
How to Change Your Password
If you want to change your password, you can follow the steps below:
Step 1: Go back into your Sheet and click Protect file from the top navigation.
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 protected Google Sheet on your phone, you can follow the below steps:
Step 1: Open the sheet on your phone.
Step 2: Click on the encrypt/decrypt URL on the first row of your sheet.
Step 3: You will now need to enter your password.
Final Words
Although Google Sheets are automatically saved to your Google Drive, it is recommended that you add an extra layer of security for important data to important spreadsheets. I hope that this post can be helpful to you.