How To Password Protect Spreadsheets In Google Drive

Passwords have protected our computers, phones, and files for a long time. Just about any device can be locked with a password, and files. folders, and drives, can be encrypted with no hassle using tools built for the purpose. What’s less common is a way to encrypt files selectively in the cloud. You can always encrypt them before you upload them to services like Dropbox or Box, etc but for services like Google Drive that allow you to view files online, the encrypted files become inaccessible. This method details how you can password-protect a spreadsheet you’ve uploaded to Google Drive, while retaining the ability decrypt it right from your browser in order to view or edit it.

Start by creating a copy of this spreadsheet in your Google Drive. The sheet is what you will use to add the data you want to protect. A limitation of this method is that doesn’t allow you to password-protect an existing file; you will always need to create a copy of the spreadsheet linked above and then enter your data into it. It’s not exactly an ideal solution, but it works. The steps that follow here need only be performed once. After you’ve copied the spreadsheet, go to Tools > Script editor.

This will open a script in a new tab. Go to File > Manage Versions. You don’t have to enter anything in the options that follow; just wiz through it all. Don’t close the script though. Once the version has been created, go to Publish > Deploy as web app.

manage versions

Click ‘Deploy when the ‘Deploy as web app’ popup appears; you need not make any changes here either. You will receive a confirmation message that the app has been deployed.

deployed as web app

Return to the spreadsheet you copied, and you’ll see that a ‘Protect File’ option has been added to the menu. Click it, select ‘Initialize’ and grant it permission to run when it prompts you. You can now start editing the spreadsheet. Add the data that you want to protect, go to the Protect File menuu, and select ‘Encrypt File’. Give the script permission to run. initialize

The first time you encrypt a file, it will ask you enter a password. Once the script has worked its magic, the text entered in the spreadsheet will scramble. You can decrypt it by going to Protect File > Decrypt File and entering your password. (On a side note, 123456 is not a secure password, so use a more suitable one.)

set password

So long as you’re viewing the files in your desktop browser, you shouldn’t have any trouble decrypting them. On a smartphone though, things will be a little different. To decrypt the file, click the Encrypt/Decrypt URL given in it. You will be taken to a webpage where you can enter the password in order to unlock your file.

[via Lifehacker]

قالب وردپرس

About Kelli Smith

Kelli Smith
Kelli runs customer support and creates content for Skillcrush, a digital skills training and education platform with friendly instructors, an active student community, and laser focus on helping you achieve your career goals with technology. She has an MBA and successfully ran an international company and her own freelancing business before pursuing her passion for tech by taking advanced web development classes. Kelli loves listening to tech podcasts at 2x speed, looking for cute Corgi photos online and teaching and performing country line dancing—as a true Texan living in Finland would do. Say hi on Twitter.

Leave a Reply

Your email address will not be published. Required fields are marked *