Phone Toolkit app icon

Google Sheets™ add-on

Phone Toolkit for Google Sheets™

Normalize, validate, and identify phone numbers with formula-first PHONE_ functions powered by local libphonenumber metadata.

8 custom functions
E.164 formatting
Country and type detection
No phone API calls
Read function docsMarketplace listing URL pending publication
Normalize=PHONE_FORMAT(A2, "E164", "US")+12025550182
Validate=PHONE_VALID(A2:A100, "US")TRUE / FALSE
Identify=PHONE_TYPE("+44 20 7946 0018")FIXED_LINE

CRM cleanup

Normalize phone columns from forms, lead lists, and CRM exports before dedupe or upload.

Import validation

Flag invalid and impossible numbers with TRUE/FALSE formulas that spill down whole lists.

Regional routing

Identify country codes, calling codes, and line types for territory assignment and support workflows.

Function map

Format, validate, identify, and parse with PHONE_ formulas

Open full reference

Format

PHONE_FORMAT

Validate

PHONE_VALIDPHONE_POSSIBLE

Identify

PHONE_COUNTRYPHONE_CALLING_CODEPHONE_TYPEPHONE_NATIONAL

Parse

PHONE_PARSE

What validation means

Validation checks bundled numbering-plan rules. It does not prove a number is assigned, reachable, owned by someone, or SMS-capable. Metadata may become outdated. Store complete phone numbers as text to preserve leading zeros and plus signs, and review results before updating records.

List audits

Pair PHONE_VALID and PHONE_POSSIBLE to separate clean, malformed, and maybe-fixable phone records.

Parse tables

PHONE_PARSE spills normalized formats, country, calling-code, type, valid, and possible columns for review.

Private by design

Formatting and validation run locally in the add-on bundle without sending phone numbers to an external API.

    xs