How to make a spreadsheet (be it Google Sheets or MS Excel) secure?


Recommended Posts

A word document too actually.

 

I was unsure whether to post here due to the 'security' part of the forum title or in the software forum.

 

Very brief backstory - i manage the accounts of 4 other family members including myself and as they don't fully know the ins and outs i need to put something together in the event that i drop dead in 5mins they would be able to make some kind of sense of it all and know what is where and why as well as what they should do (since they're not as 'into' it as me).

 

Now i was looking at storing in Google Drive and sharing these files as read-only BUT on looking in to it the advice is simply for what the data is, just don't do it. I'm not talking usernames & passwords but account numbers yes. Not just Google Drive but anything cloud based the advice was pretty much don't do it, not worth it.

 

So i'm wondering about an alternative. I don't really know what's available out there so to my little mind i can only currently think of using MS Word/Excel, filling in all the info, putting this on a USB stick and then somehow encrypting the stick. If that sounds acceptable then please go ahead & suggest ways to encrypt or encryption programs because that's all new to me.

 

Now we could get ahead of ourselves and say what about if my town gets flooded and where the family live 4 miles away don't. What if the UK suffers the worlds biggest earthquake and what if we're taken over by aliens but the chances are very slim and as far as that goes i'll take my chances.

 

Again if it's a sound idea then i was thinking storing on a USB drive at my house as well as the other house where 3 of the 5 family members live, again encrypted. Any changes then i just simply change it on the stick. The most up to date one will forever be my stick but theirs wont be too far behind and should be the same really.

 

Feedback?

 

Oh and if this would be better suited in the software forum after all then please move it there.

Cloud I think is still a valid option.

 

Why not zip and password protect each file with a different password for each family. You can upload and each family can download but won't be able to access those files. 

 

That way you don't have to worry about USB sticks either.

  On 20/12/2018 at 11:56, dipsylalapo said:

Cloud I think is still a valid option.

 

Why not zip and password protect each file with a different password for each family. You can upload and each family can download but won't be able to access those files. 

 

That way you don't have to worry about USB sticks either.

Expand  

It's not a case of one family member not being able to see another family members info. That's not really a big deal here. It's the protecting the info that's inside.

 

What zip and password setup would you use? Standard Windows zip or something moreso for this kind of thing?

 

  On 20/12/2018 at 12:03, Ready2018 said:

It's very simple to make Excel spreadsheets secure by simply adding encrypting with a password:

 

https://www.digitaltrends.com/computing/how-to-password-protect-an-excel-file/

Expand  

That looks like it might do the job.

 

How can you stop people changing the information within the sheet though? They'll have the password but how do you make it read only?

I get a bit lost with the terminology but within the 1 file there'll be numerous 'pages' (tabs at the bottom) for differing family members.

 

 

And would you protect this file even further than sticking an internal password on it as shown in your link? Or should that be perfectly fine?

This was already discussed like 2 months ago.. You were told then to just encrypt your file - back then you said when you encrypted stuff it didn't work later... So how is it now you are ok with encryption/passwording a file?

  • Like 1
  • Thanks 2
  On 20/12/2018 at 12:32, BudMan said:

This was already discussed like 2 months ago.. You were told then to just encrypt your file - back then you said when you encrypted stuff it didn't work later... So how is it now you are ok with encryption/passwording a file?

Expand  

I trust you that encrypting is for the best and that when passwording a zip file in the past i must have done something wrong. Not sure what but something. Wrong file types maybe, too large maybe, who knows. These will be just small documents though.

  On 20/12/2018 at 14:11, Technique said:

I trust you that encrypting is for the best and that when passwording a zip file in the past i must have done something wrong. Not sure what but something. Wrong file types maybe, too large maybe, who knows. These will be just small documents though.

Expand  

What? It's farily simple. Don't know what you are trying to do...

  On 20/12/2018 at 16:09, Technique said:

Why?

Expand  

Why what?

 

Choose your poison:

 

https://www.youtube.com/results?search_query=how+to+encrypt+a+zip+file

  On 20/12/2018 at 16:38, Mindovermaster said:

Why what?

 

Expand  

Why do you not know what i'm trying to do when i've said what i'm trying to do?

 

Part of my post doesn't show up on your screen?

Although ... since when did WinZip become a to pay for piece of software? :o That was always free years ago. Sure i know there's the trial version but only for 21 days. As i don't plan on dying within the next 21 days then it's not very good.

 

The WinRAR version i have is A) old and B) technically not legit. Ok it's really not legit. And with this kind of thing i can't afford anything going wrong so it needs to be right.

  On 20/12/2018 at 17:10, Technique said:

Why do you not know what i'm trying to do when i've said what i'm trying to do?

 

Part of my post doesn't show up on your screen?

Expand  

We talked about this awhile ago. Then you make a new thread on exactly the same thing.

  On 20/12/2018 at 17:12, Technique said:

Although ... since when did WinZip become a to pay for piece of software? :o That was always free years ago. Sure i know there's the trial version but only for 21 days. As i don't plan on dying within the next 21 days then it's not very good.

 

The WinRAR version i have is A) old and B) technically not legit. Ok it's really not legit. And with this kind of thing i can't afford anything going wrong so it needs to be right.

Expand  

Zip is open source now. Zip should be integrated to Windows 10.

Just gnupg the files FREE... HIGHLY encrypted!

 

https://www.gnupg.org/

 

Way stronger than just a Password you could forget ;)

 

Or just use 7z, allows encryption as well.

 

Been doing this stuff for years.. Here is my oldest key - from 1998

oldestkey.thumb.png.32520689739c67854994137cfab4bc84.png

 

Still can access files encrypted to it...

 

  On 20/12/2018 at 17:28, Mindovermaster said:

 

Zip is open source now. Zip should be integrated to Windows 10.

Expand  

I don't use Windows 10. I'm on Windows 7 until something comes along which i prefer the look of.

 

  On 20/12/2018 at 19:06, BudMan said:

 

Way stronger than just a Password you could forget ;)

 

 

Expand  

That's something i meant to ask about...

 

Excel & Word (i'm using Office 2010 btw) offer the option to put passwords on the documents from within the document itself when you go to the save as. You can 2 layer them with read only and the option to write - a different password for each.

 

How secure is that? And is encrypting really better? Should it be done in addition to the passwording?

 

I imagine once it's been passworded / encrypted / both that it should be perfectly fine in a Google Drive / Dropbox / OneDrive / USB stick?

  On 20/12/2018 at 20:26, Technique said:

Excel & Word (i'm using Office 2010 btw) offer the option to put passwords on the documents from within the document itself when you go to the save as.

Expand  

I believe we told you that before.

 

  On 20/12/2018 at 20:26, Technique said:

How secure is that? And is encrypting really better? Should it be done in addition to the passwording?

Expand  

encrypting is encrypting. No matter how you look at it. Think Budman said "highly encrypted" meaning there is more credentials than just a password.

 

  On 20/12/2018 at 20:26, Technique said:

I imagine once it's been passworded / encrypted / both that it should be perfectly fine in a Google Drive / Dropbox / OneDrive / USB stick?

Expand  

Yeah, store wherever you want. Once you put a password, it can not be opened but by the person who knows the password.

 

Right from Wikipedia: 

 

  Quote

In cryptography, encryption is the process of encoding a message or information in such a way that only authorized parties can access it and those who are not authorized cannot. 

Expand  

 

So from what you say then, there is little difference between passwording and encrypting.

 

Passwords: "it can only be opened by the person who knows the password".

Encrypting: "encryption makes the file so that only authorized people can view it as it should be".

 

Either way only those with the green light get to see what the file is about.

 

So on that note is it even worth doing the extra level of encrypting?

Encryption with a password is only going to be as strong as the password.. Doesn't matter if its AES-256, if your password is p@55word ;)

 

With encryption with a cert, like with gnupg.. You not going to decrypt it without having the cert to decrypt it with... So for example - is private key

 

-----BEGIN PGP PRIVATE KEY BLOCK-----

lQPGBFwb6vcBCADBPqwln4DGlUXYZMH5eD2S5MwT3Z0oqu10o4uisM05bAd9iUpX
SO7L647Nc7SYzj+bhEXuEqfh8quhCxHmO44L5+aChHnTm3r/kfkrfQsmOoMpGYXZ
2SNJgRvA1yjAUQcxTns8dpTSGLwuj+h/NIEYPEMQ5j5SAhWIq/j3DXrflyNyBgbo
MSCGi9XLbCHKmnJ9WViyTrmctYSEFTzcuiRw0ySZBSB1fgFDj3ZOxyKthg8n1hXc
73vpP6wQEI2UYEJTRUOwMXIV5WFvPDLhYAFusKTCvzYudFr+rx9giPkZuJ2tM7ra
c+tOYEB3GIg+g6K5eIXio9ZakRwGBjhvm5JbABEBAAH+BwMCMEHS6TmB8Ci6uM3c
zTs4CBc6gh7xXQQ+k5lKlVoIo4jodFl60+Hxa+A5EKUtUHnjuVdPbuXhkuF2Xqf8
Z4Cg8AWK9Nt0+q433/N5ogEB+dLp+VCk3+nTCcYAw1tVJBUsl2tRFOGuPrnDHykv
FHX0niYp9aFGPh78A0EPwuggreTsqzWPY0J1JjIh494UXXGYYgtYen4dVqklRuFw
NMRCc1ZfGGaevVW5AJZ2l3I5haFO9tVWi66/At0O4xy/XKlUJ/5V43ZHsEPXcBBx
ugBZp/hXUDE7vcWe4ugfikquVdO8gFiLT0EOcyrUAqUzIMohIWvvRFTBsX0rMwwy
euAntMxbFxNw5Siupa+0BFuLa58jypRI3LGg0QqW59bGdDyrOXhf8YlWy/0qocHY
anWTYCcRSF+cc0lMduvjh70D+7FRXu3vN3Zd1VqqOr8N+HIl5jX36rlFbhBCKsez
vvgc6q29TZ8I8h46dTJ9vytZVnJO94eBUeSZEmmwTwFKhYCRE/j4zcLtmiXaHWfv
7uRsIsuUR509MmsG0WXu40LKdUksy0r431cIcozyZ41hRgabldjOdHC/wq25qUtq
G0e3GiSwGEPF6V3G1TDGr9IPCPDUNduKm6d94tHQdQFLHO6j07LbJ3SnuUUzKrCm
wgp/9j2a2CZzlXJQfX5wThlgb9ycMX1nl89vs+yI5uTD6SWx3wdL9eJoEYemCKkE
+JLPd4NrwxebIZzNMaWqROjK2innhNGTkGpdNwksp3DD4RPUDDCBpmndxGmUgTgF
cHcVbWhfnmKXLryphMG8vLkHPTs6EQQyOVQT7wXUfNTn3TQM7xybXJZl2/tbanWI
gbyMXpX3c5xTmfMvW7CQjVimHZM5DhHeIYan6m3OMVeXi6waoP26SQZDdas2MEZx
ELFtWTPx/RtltAZCdWRtYW6JAVQEEwEIAD4WIQRaPFlt1cmQc4CRhv6w8JQuz89I
sgUCXBvq9wIbAwUJA8OmKQULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRCw8JQu
z89IsqEqB/95vwQE2iuzRg1W+r1qpI8AauOaDoYcNlDbNOZIA4NlDyEZOlQSoyzO
/dAU5dP2AS1T3ZsAF+4P4tXhvQ0N93mF4mFz9Z81snOfaVOGc5fMzdTkuEGovAZt
PlMROmNhbJb4OlQ6Gz4Pxzvetk45MzzZlEyb6FJiZVy67c+4/+a5wQV4NZSdD/80
JEGRkPxn1vEbYXPvk48ck5zZuwb38F+PSOG9SOme5wkEGxLaldwVxZ29NkeKfWeb
ad7/VeN4nnF5EKwZ/PkuGPcHDCfwteWurb89Mn+zxZ6bHAlQUGWFGRPuGAMc0gxj
5wbLIZ1JopKZiViil3e7xSgC410zEfHSnQPGBFwb6vcBCADxIbjXwvNTt90OS23j
hDcjkbt0Ey8LCxfue2hXUB8a9ID5LN3lwOpMUxbvHzhckZaP5rbnF2c4YPxrt5qJ
g7ffVY5d8pGaCWYmoJkXq6XfrcD9xIOiVY7X4f6s8BcVLvW6KYoLDCK89obwLaDK
poFSMwATRTEJrP5PaP53xb6vJhSq4xhpPv09f2TgeIJuI2ZImvq2Q5vjE9ujUE7V
zxhCq8u1nkrrxKxFueBNU2bkdrALHzGuWg99mqZi/vvwqdkFkv2eaB/vKR4eUYuh
Jmnw7R4aA4ynv34IdBhcGf36RXD3JZIbSlbTiAIEHp+1ETRojyFDO99mpp+p2qHx
1fk5ABEBAAH+BwMCNhLEOWGz10C6tqhG3etCxxnhrmVXuGWgEvEMu/mDqOHwhnSd
u2EARPizLKxYEy3/9wSso1NfpC7+Ma0ffuuHWN+8S3cSxahEpUiyUQAieG2NXXpW
LvLqf1DVHrNCwhsbTzt13y7g/YBxI8DK4pD6nlZg3zpKRqojyIRZix+nGUfVOQq4
CUOvmAN0eHzdT/zRETBSbkDGFbXmYJ/JFC7+m3IiMMso+68nLFrsMFws2aoP5+xs
SZFqZl7ydEwITJMnazxyjb8v4KY7c2G1u3mZ7iNKgYjtxeZU+q3XLNJzOKUhZZYT
x8cymhLRwqIZ+yNz0RgbWCU+O3X/L4txd0A/pK9BSm8kgRc/X/syZNvMEQsaC2/8
TTYSogdQx/w3ITwfcqoS0joPttYMyGql0EU1YSN1VbqG95ara9+5JIQTSzay27VG
fBxD5Ziq39tHn7TJb9CxEDI4xF2VMF7VLBRQODW6xs+RG5c3eTf2uunLj18DsNuZ
HAFhmyx9LSSrt+9HVXoIoWSYwn6DL/qM2UuufvzTqODs1djeJbMv+d3FOGDxdGBW
s+qpF1EXjD77UR416nktYLFFvUJM2JW98TplPdgj3UUow5Jf9i28ZhFrqxIpvWmB
0ta9ypWB7Y3pooWJcjure73gj/mG95bGm6iKCm0YFPuAL0u2CQdjMpzTykWALTYJ
LtQOPSMB8hng1KrRphYx46omCwPw6FYVJp+HFYkjKB3aobzj5q9/Ij06CHHYyJBX
cDE9g2XfGGuK1zOdXu4GSycL7cQ7fYXdn107yxYQ+S+jgBK0d/9/xVeVMlGxX5ZB
JXJ+/OG3/aqS8nzW6CWiD7K154UnYgbtsXB3lTqGK6mmXUFlippmqNbLuFMuzV8Y
+v/bgktgw0ZvdeDd70Q7FXrdqJBqPKFRp1aCLoQWtv4oiQE8BBgBCAAmFiEEWjxZ
bdXJkHOAkYb+sPCULs/PSLIFAlwb6vcCGwwFCQPDpikACgkQsPCULs/PSLJkHAgA
v0tx4SxXx5q8MJkcR7ChXnBrPR4XA3mCy50LveYkfAS4GD8ig0/VSxO1WvaCj+51
GhtW5vJ6aSChNWxiIPfuICWJVoIU9ExrUEnlnKtizYcYFbegLqPOCi7UQah6uRKg
avJDPySpMuvC7/2DIjtWbeT620aiFv8W3NtKuiWzF4ISquOGtZlLdzJy9fBDl1d+
3GgeH4SZswJXIEEllHiB7E1KdsTrswv5DdnXgbX5zQdaiRwP9xurilT0NT1F1HYc
da+P7p6uw1iqS8Vw2ogvb7ZUaTzaEfiH3wse/02Ta294Y8pdyJylb590uHlvVpmR
gBwa2YHOxlbKkzoToYsNlg==
=5MjH
-----END PGP PRIVATE KEY BLOCK-----

You need that - and then that is even protected by a password.. So even if you got that file, you would also need to know what the password is..

Passwording is ONE way of encrypting. There are different types of encryption.

 

You wanted to password protect it. AKA, encrypt it.

 

You are asking your own understanding.

  On 20/12/2018 at 21:20, Mindovermaster said:

 

You are asking your own understanding.

Expand  

And i make no secret of the fact it is limited - hence me being here.

 

I'm not the one running around these forums trying to play the big man ;)

Just tried that gnupg.

 

W

T

F

???

 

I've seen mention of Veracrypt and Axcrypt. I'll see if they make more sense to me (i.e. whether they're more user friendly). this gnup thing may be easy for you but you clearly know what you're doing.

Dude, it's not hard. You just have to LEARN how to use it. That goes with ANY program made by human hands.

 

But, as Budman said:

  Quote

Encryption with a password is only going to be as strong as the password.. Doesn't matter if its AES-256, if your password is p@55word 

Expand  

If you always want the easiest way out, you'll never learn.

 

(btw, GNUPG is integrated into Linux, too...)

Its right click encrypt... Maybe computers are just not your thing.. Maybe you should just stick to disk you stick in a player ;)

encrypt.thumb.png.5285a6cf7a661b58c960189f49c8ae6e.png

 

No offense dude - but your like trying to talk to my 4 year old grandson when it comes to anything that has anything to do with tech at all.. Your like in the 1950's or something..  You actually use computers??

 

I'm not talking about compiling your own drivers for your wifi card..  Or your linux kernel.. Im talking about following the bouncing ball the software walks you through and then right clicking..  I could prob walk my 90 year old mother in law through this stuff ;)

 

Does your phone flip up, or do you actually have a current phone.. Maybe you still dial it?  Im OLD dude.. in my 50's... So I remember all the OLD ######... I remember the vhs/beta wars.. And rotary phones, etc..   This is pretty basic ######..  Talking to you is like talking to my 90 year old mother in law about tech..

 

Just really at a loss to how someone smart enough to find such a forum from back in 2003 could be so behind when it comes to basic tech..

 

  • Thanks 1

While we're with these 'does' questions...

 

does throwing these jibes make you feel like a big man? Do they give you a sense of achievement?

 

I'll admit my patience is zero. Things need to work first time. I opened the program and tried encrypting a file and it didn't work. When i was on the download page i actually had a feeling of 'here we go' as it looked like one of those geeky sites that Linux nerds would use, the sort of people who try and tell the world Windows is the devil and they should switch to Mac or preferably as it's less mainstream ... Linux (yeah since we're going with the put downs for no reason i'll have my turn, now it's your turn about how i'm so behind technology again, on you go....)

 

If it helps any then it seems to have installed 'Kleopatra' on my machine.

 

Is this Veracrypt any 'easier'?

 

And regardless of which encryption software is used, will it be needed to be installed on the machine that uses it or will they only need the password? For example, i am now dead (so no more annoying questions for you to see, woo-hoo and all that), they jump on Google Drive / Dropbox / OneDrive / the USB stick at my house or theirs, they have a Windows laptop and a Macbook (sister is a Mac owner, currently), do they just open the file with the password or do they need the program that was used to encrypt it?

kleopatra.thumb.jpg.8740643895e23ed54aeb404716cbf0fd.jpg

Edited by Technique

What didn't work why encrypting it? As Budman says, It's very very easy...

 

Try putting it on a USB flash drive and hide it somewhere...

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Yes, agree 100%!! It baffles me that so many people are so outspoken about hating Win11 but have taken zero steps towards trying out other operating systems. If you don't like the direction Microsoft is taking Windows, then staying on Windows 10 is only the short-term solution, clearly the long-term solution is to find an OS you prefer. Let's be honest about two things...Windows 10 was FAR from perfect, it makes many of the same offenses that 11 does, but maybe to a lesser degree. Also, if anyone is holding out hope that Windows 12 will be some kind of return to the good-old-days, they are being extremely naive. What will end up happening is they will get dragged along to W11 once W10 support fully ends (and they realize 10 IoT isn't what they thought it was), just like they got dragged from Windows 7 to 10. Then start the cycle over, they will figure out how to make W11 work the way they want it to and will start complaining about how bad W12 is.
    • only works for 1 microsoft account . im on rp channel and have 2 pcs with the same microsoft account, i pc got it the other one did not
    • Your first comment about one needing to send all their data to Microsoft's "cloud" to continue Windows 10 support was of course ridiculous but I can't disagree here. I am not sure why the OP would wait to switch to Linux if their Mom just uses a browser as she can use the same one with Linux. Why would she care what OS is running? Install /configure Linux Mint or Ubuntu LTS and almost no maintenance really.
    • Seagate Exos 20 TB BarraCuda 16 TB 7200 RPM CMR hard disk drives are limited-time deals by Sayan Sen Currently, there are some great sales on SSDs, in particular, NVMe M.2 ones, like this SK hynix P41 Platinum P41. However, if you are in the market for a hard disk drive (HDD), then Seagate has you covered. That is because two high-capacity drives, the Exos X20 20TB and the BarraCuda 16 TB are currently at great prices (purchase links down below). Since both of them are high capacity models, they are based on CMR or Conventional Magnetic Recording technology which is typically great for robust use cases like on NAS or (media) home servers and similar such scenarios. However, the Exos is enterprise-grade quality so it is definitely what you would want for 24x7 usage, but the BarraCuda can also serve pretty well but will be a better option for backup purposes. The Exos X20 promises power-on hours of 8760 per year, while the BarraCuda claims 2400. The latter comes with double the DRAM cache, though with 512 MB of it, while the former has 256 MB, but it should still be plenty. In terms of data transfer speed, Seagate promises up to 285 MB/s (272 MiB/s) from the Exos X20 and the BarraCuda is rated for up to 190 MB/s. These are the maximum sustained data transfer rates for the two drives. Since the Exos X20 is an enterprise-class product Seagate does disclose its random performance throughput, which is 168 IOPS for reads and 550 IOPS for writes, respectively. While the BarraCuda's randoms are not specified it is expected to be lower and to compensate, it packs double the DRAM cache. Get the HDDs at the links below: Seagate Exos X20 ST20000NM007D 20TB SATA 6.0Gb/s 3.5" Internal Hard Drive: $379.00 + $50 off with promo code SACET2372 => $329.00 (Newegg US) Seagate BarraCuda ST16000DM001 16TB SATA 6.0Gb/s 3.5" Internal Hard Drive Drive: $194.99 (Newegg US) This Amazon deal is US-specific and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon US deals page here. Get Prime (SNAP), Prime Video, Audible Plus or Kindle / Music Unlimited. Free for 30 days. As an Amazon Associate, we earn from qualifying purchases.
    • Why do you think the writing is on the wall? Tesla continues to have the highest selling models on the planet, and they continue to grow on that despite their junk reliability rating. I'm not going to buy one because of the continued build quality issues (and lack of Carplay), but I appreciate that they're the best player in an EV market that is massively lacking in infrastructure and affordability. Besides the EV technology needing to eventually outpace gasoline, self-driving technology is undoubtedly going to be the future. It's not going to happen tomorrow and not even in 10 years, but within our lifetimes, most cars on the road will be self-driving. That's the only way to solve the issue of a million deaths on the road. Waymo is using technology that's simply too expensive, which means it has to charge high fares. Tesla is going to blow past them with their ~$40k car and further yet when they release that weird looking 2-seater. Pretty soon Nvidia is going to be a market player, Amazon will be a player, and possibly the other 20+ startups that are working on a vehicle. I'd like to revisit this in a year and see how the market looks. I'm willing to bet there will be a huge increase of driverless cars on the road, and I doubt that Waymo is going to be the majority of them. Waymo isn't profitable for Google, so it's entirely possible the plug gets pulled as soon as several players leave them in the dust.
  • Recent Achievements

    • Week One Done
      DrRonSr earned a badge
      Week One Done
    • Week One Done
      Sharon dixon earned a badge
      Week One Done
    • Dedicated
      Parallax Abstraction earned a badge
      Dedicated
    • First Post
      956400 earned a badge
      First Post
    • Week One Done
      davidfegan earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      616
    2. 2
      ATLien_0
      229
    3. 3
      Michael Scrip
      167
    4. 4
      +FloatingFatMan
      161
    5. 5
      Xenon
      142
  • Tell a friend

    Love Neowin? Tell a friend!