Encrypting content on a google spreadsheet [closed]

Question

I have a spreadsheet that contains passwords so I can access them from anywhere. I make sure I always access it using https. However, I'm concerned that someone may steal my gmail password and access it so I wanted to add another security layer. I wanted to encrypt the passwords/on the page using a formula that encrypts each value using a master password.

That is, I would have a field on the spreadsheet where I'd have to type a master password so that the passwords display correctly, otherwise they would display as garbage

Basically this is the idea

I would need two formulas:

Encrypt(pwd, masterpassword)

This formula would return the value that I would have to type into each of the password fields.

Cell Where the master password is

A1 = "MastrPWD";

Say I need to add a password of my xmail account which is set to "PAZZWD"

I would run the formula

Encrypt("PAZZWD", "MastrPWD")

which would return an encrypted value, say "BDUE45"

So in the line where I store my xmail pwd, I would set the formula of that line to be

B3 = Decrypt(A1, "BDUE45")

Then, I'd clear the field where my master password is set (A1), and even if somebody got access to my account, they still wouldn't be able to see the passwords unless they knew what to type into that master password field.

Hope this makes sense and somebody can help me

Answer 1

The problem is that even with a master password in place, it won't help one bit.

Google spreadsheet has build-in revisions, so as soon as you enter your password it will be stored as a revision. And if someone would access your spreadsheet they can simply look in the revision history to see what your master password is.

Answer 2

Not quite an answer to your question, but a work-around:

Google now offers two-factor authentication. If you enable it for your account it makes your password spreadsheet more secure.