The Scenario
The daily call list needs to go to the sales reps by 8 AM. You're a field sales manager. Two thousand inbound leads arrived overnight in Excel — all have phone numbers, none have geographic data. Territory assignments run by state. Without area code geography, you can't route the calls.
It's 7:30 AM.
The bad version:
- Google area codes one at a time and fill in city and state manually — workable for 20 leads, not 2,000.
- Find a free area code CSV from 2019, import it, write a VLOOKUP, discover several codes are missing.
- Delay the call list, tell the reps assignments are "coming soon," and lose the morning.
The 8 AM deadline is not negotiable.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Excel workbook and calls Interzoid's area code geography API for every lead phone number.
For each phone number in column A, use Interzoid to look up the area code's primary city and state and write them to columns B and C.
What You Get
- Column B: primary city associated with the area code.
- Column C: state associated with the area code.
- A lead list ready for territory-based routing — filter by column C to create the per-rep call sheets.
What If the Data Is Not Quite Ready
Phone numbers have inconsistent formatting
Strip all non-numeric characters from phone numbers in column A, write cleaned numbers to a helper column, then look up area code geography and write primary city and state to columns B and C.
You need to handle toll-free numbers separately
For each number in column A, check if the area code is a toll-free prefix (800, 888, 877, 866, 855). If so, write 'TOLL-FREE' in column B and skip Interzoid. For all other numbers, look up area code geography and write city and state to columns B and C.
You want territory name as well
After writing state to column C, add column D mapping each state to your four territory regions: Northeast, Southeast, Midwest, or West.
Full territory assignment in one shot
Extract area code geography for every number in column B using Interzoid and write the associated city and region to columns C and D. Map each state to territory and write to column E. Create four separate worksheets — one per territory — each containing the leads assigned to that region, sorted by state.
The reps get their filtered call sheets. Distribution happens at 7:58 AM.
Try It
Get the 7-day free trial of SheetXAI and open your lead workbook — ask SheetXAI to append area code city and state to column A before the morning distribution. Then see the spoke on bulk validating phone numbers for carrier and risk, or the full Interzoid integration overview.