Excel formula-based function for SHA256 / SHA512 hashing without VBA or macros

excel hash excel-formula sha256 sha512
JKVeganAbroad picture JKVeganAbroad · Oct 1, 2017 · Viewed 9k times · Source

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/

Answer

PGSystemTester picture PGSystemTester · Jun 26, 2019

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...

  • No VBA.
  • No named ranges.
  • No arrays.
  • Uses standard Excel functions found in 2007 and higher.
  • Format is *.xlsx

Download from OneDrive

or

Download from Google Drive

Related questions

Password hash function for Excel VBA

I need a function written in Excel VBA that will hash passwords using a standard algorithm such as SHA-1. Something with a simple interface like: Public Function CreateHash(Value As String) As String ... End Function The function needs to work …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More