Menu
It's the year 2017 and anybody who needs to use hashes should avoid 'broken' ones such as MD5, if security is important. Has anybody found or created a way to do more secure SHA256 or SHA512 hashing in Excel, without using VBA or macros?
A spectacular example of this being done before was over 3½ years ago with MD5 (as seen in this SO: MD5 Hash function in excel without using VBA).
Reason for avoiding VBA/Macros: Compatibility with mobile devices, such as Excel for iOS.
Side Note: The original Stack Overflow post has a successful answer with a dead link, here is a new link for reference: https://tzamtzis.gr/2017/web-analytics/excel-function-md5-hashing-without-vba/
403
To my knowledge there is no hash function build into Excel - you'd need to build one as a User Defined Function in VBA. However, please note that for your purpose I don't think using a hash is required or really advantageous! VLOOKUP will work just as well on 256 bytes as it'll be on a smaller hash.
If you prefer using a single Excel function to generate an MD5 hash, you can use Phil Fresle's VBA source code. By adding this as a class in your Excel file, you'll be able to use the function “md5hash” to generate MD5 hashed values for any cell value.
I've got one. Limits to 55 characters and designed more for educational purposes (i.e. how to see how SHA256 works in Excel....?).
To recap...
Download from OneDrive
or
Download from Google Drive
171
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
