How Do I Upload a Password Protected Excel to Google Sheets
Google Drive offers a lot of features for users, simply some of the nuts have always been missing, such equally password protection. If you apply spreadsheets for any sort of important data in Drive, password protecting them can aid improve the overall security of your information. We volition show yous how to countersign protect a spreadsheet in Google Drive.
Making a new re-create of a scripted spreadsheet
The first step is to make a copy of the scripted spreadsheet. This has the original script created by Skipser that you can employ to create a "spider web app" for your Google Drive.
This is hosted on my personal Google Drive, so I tin can vouch for its safety. Click "Yes, brand a copy" to copy it to your Drive account. You do have to be logged in to your Google account for this to work.
Creating your ain "web app" to run spreadsheet script
Initially yous need to ensure you can run the scripts within the protected spreadsheet in your Google Drive account.
1. Click on "Tools," then click "Script editor…."
2. Click "File," then "Manage versions…."
3. Click "Salve New Version."
In that location is no need to describe anything at this point. A new "version" will be updated for your spreadsheet, click "OK" to head back to the Script Editor.
4. Click "Publish," so "Deploy equally web app…."
Again, there's no need to change whatever settings. This but allows the script that lets y'all password protect a spreadsheet to run within the confines of your Google Drive account. Click "Deploy."
5. Click "OK" to confirm the cosmos of the web app script.
Anytime you want to create countersign protected spreadsheet, you will demand to copy the in a higher place link, and rename the spreadsheet. Considering you created the spider web app script, your Google Drive will automatically add information technology to your newly protected spreadsheet.
Encrypting and decrypting your spreadsheet
When you become back to your spreadsheet, you'll meet a new menu option: Protect File. This is what you created when yous deployed the spider web app script.
one. Input any data you want to protect in rows three and down. Any data in rows one and two volition interfere with the spider web app script you created.
2. Click "Protect File," and then "Encrypt File."
The get-go time y'all run the script in Drive, y'all'll be warned about the potential chance of running such scripts.
This occurs any time y'all use a script for the get-go time in Drive, and you must click "OK" to go on to utilize information technology.
3. At present, create a countersign for your spreadsheet.
This can be anything you want, but I advise against using your Google account countersign for security reasons. Click "OK" once you have entered the password.
You will come across the data within your spreadsheet brainstorm to modify as it encrypts itself. This is a very bones encryption, then keep that in mind when you decide what information you want to store this manner on Google Drive.
4. When you need to decrypt your data, click "Protect File" once more, then click "Decrypt File."
You will exist prompted to enter the countersign. Enter the password and click "Submit." This is the only surface area of using this method you may have some bug with. If you receive an error, simply become dorsum and striking "Submit" again to decrypt the data.
If you caput dorsum to "Protect File," you can change the password for your spreadsheet at any time. Keep in mind that if you modify the countersign for the spreadsheet, you will non exist able to modify the content of it without copying a new spreadsheet and starting the process again.
Y'all can also go a webapp URL so that you can access the document directly from the Protect File menu.
You can and so enter the countersign and click "decrypt."
If at any time the Protect File carte disappears, only click the "Script Link" in the spreadsheet to get information technology dorsum.
Conclusion
This seems like an atrocious lot of work to password protect a spreadsheet in Google Bulldoze, yet until Google introduces a more permanent solution, this workaround is your all-time bet. If you know of a different solution, allow us know below in the comments expanse.
Paradigm credit: Master lock with root password
Is this article useful?
Subscribe to our newsletter!
Our latest tutorials delivered directly to your inbox
Source: https://www.maketecheasier.com/password-protect-spreadsheet-in-google-drive/
0 Response to "How Do I Upload a Password Protected Excel to Google Sheets"
Post a Comment