Copy-paste formulas to format phone numbers in Google Sheets
Paste a formula into row 2, test on a few rows, then drag down.
Format to E.164
A: raw phone · B: default country
=GPT("Convert this phone number to E.164 format. If no country code, assume " & B2 & ". If not a valid number, return invalid. Number: " & A2)
Guess country
A: raw phone
=GPT("Guess the country for this phone number from its code or format, or unknown. Return the country name. Number: " & A2)
Validity flag
A: raw phone
=GPT("Is this a plausibly valid phone number? Answer valid, invalid, or unsure, then a 4-word reason. Number: " & A2)
Short answer
Phone formatting in Sheets means standardizing inconsistent numbers, mixed separators, missing country codes, and stray text, into one clean format, flagging ones that are invalid. GPT for Sheets normalizes and labels numbers across every row, with formulas you can review.
Fastest path: Install GPT for Sheets → put raw numbers in a column → add the format formula → review → fill down.
This page is for ops and CRM teams cleaning contact data in spreadsheets. Treat formatting as best-effort: the model guesses country from context and can be wrong, so review flagged rows and verify before dialing or texting.
Workflow
A practical sheet for this workflow usually has these columns:
| Column | What to put there | Why it matters |
|---|---|---|
| A | Raw phone | The messy input |
| B | Formatted number | Standardized output, e.g. E.164 |
| C | Country guess | Inferred where possible |
| D | Valid? | Flags too-short or junk values |
| E | Notes | Why a row was flagged |
Pick a target format
Decide on one output format, E.164 (like +14155550123) is the most portable, and tell the formula to convert to it. Standardizing first makes the data usable in CRMs, dialers, and messaging tools that expect a single format.
Format, flag, review
Run the format and validity formulas on a sample, check that country guesses look right for your data, then fill down. Flag numbers that are too short, contain letters, or are ambiguous, and keep a notes column explaining each flag.
Use cases
- CRM import: standardize before upload.
- Dialer prep: convert to E.164 for tools.
- Junk removal: flag letters and short strings.
- Segmentation: group contacts by country.
- QA: keep a notes column for every flag.
Best for / not best for
Best for: Ops and CRM teams that clean contact lists in Google Sheets and want consistent, tool-ready phone formatting without custom scripts.
Not best for: validating that a number is live or assigned to a person; this standardizes format and flags implausible values but does not verify reachability.
The strongest use case is converting a messy phone column into one consistent format with invalid rows flagged, so the list imports cleanly into your CRM or dialer.
Internal links and next workflows
- GPT for Sheets product page
- GPT for Sheets pricing
- AI lead enrichment guide
- Categorize leads by industry
- Apollo export enrichment
- B2B sales account research
Safety, compliance, and data quality
Phone formatting here is best-effort: the model guesses country from context and can be wrong, and it does not verify that a number is live or assigned. Review flagged rows, keep notes, and confirm before dialing or texting.
Frequently Asked Questions
What format should I standardize to?
E.164 (for example +14155550123) is the most portable and is what most CRMs and dialers expect. Tell the format formula to convert to it and supply a default country for local numbers.
Can it guess the country?
It infers country from the code or format where possible and returns unknown otherwise. Guesses can be wrong for ambiguous local numbers, so review them.
Does it verify the number is real?
No. It checks plausibility and format only and does not confirm a number is live or assigned. Verify before dialing or texting.
Will it handle extensions and junk text?
It flags letters and implausible values as invalid; review flagged rows and use the notes column to decide how to handle extensions or partial numbers.
Start formatting phone numbers in Google Sheets
Put your raw numbers in a column, install GPT for Sheets, and standardize them to one clean format where your contacts already live.