Phone Toolkit reference
Phone Toolkit
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
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.
Format
1 functionsValidate
2 functionsIdentify
4 functionsPHONE_COUNTRYReturns the detected ISO country code for valid phone numbers.
PHONE_CALLING_CODEReturns the country calling code for valid phone numbers.
PHONE_TYPEReturns the phone number type, such as MOBILE, FIXED_LINE, or TOLL_FREE.
PHONE_NATIONALReturns the national significant number for valid phone numbers.