Skip to main content

=HASHPHONE(phone, [algorithm])

The =HASHPHONE() function standardises and hashes phone numbers using the E.164 international format, ensuring platform compliance and consistency.

Parameters:​

ParameterDescriptionExample
phoneThe phone number (or cell reference) to be cleaned and hashed=HASHPHONE(C2)
algorithm (optional)Choose from: SHA256 (Default), MD5, SHA1, SHA512 and SHA3-256=HASHPHONE("+14155552671", "SHA256")

What it does:​

  • Formats the number to E.164 (e.g., +14155552671)
  • Adds a + prefix if missing
  • Hashes the result using the selected algorithm

Use Cases:​

  • Anonymising phone numbers for Meta or Google Ads custom audiences
  • Ensuring consistent hashing across countries and formats
  • Automating secure, phone-based identifiers in a no-code data workflow
info

HASHPHONE expects the input to be a valid phone number