# =HASHPHONE() Formula for Google Sheets

> Reference for =HASHPHONE(phone, algorithm), which normalises numbers to E.164 format and hashes them for consistent custom audience matching.

- Source: https://www.8apps.co/docs/hash-data/using-hash-data/hash-phone
- Markdown: https://www.8apps.co/docs/hash-data/using-hash-data/hash-phone.md
- Language: en

---
# =HASHPHONE(phone, [algorithm])

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

## Parameters:

| Parameter              | Description                                                   | Example                                |
| ---------------------- | ------------------------------------------------------------- | -------------------------------------- |
| `phone`                | The 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
:::