=HASH(value, [algorithm])
The =HASH() function allows you to hash any kind of data, including emails, phone numbers, or any other identifiers, using secure cryptographic algorithms, directly within Google Sheets.
Parameters:
| Parameter | Description | Example |
|---|---|---|
value | The text, number, or cell reference you want to hash | =HASH(A2) |
algorithm (optional) | Choose from: SHA256, MD5, SHA1, SHA512 and SHA3-256 | =HASH(A2, "MD5") =HASH("John Doe", "SHA1") |