The Scenario
You work in a call center's data team. Last week the inbound line captured 500 phone numbers. No names, no emails, no company context — just raw strings in column A of your Excel workbook. Before the sales team can qualify any of them, someone needs to map each number to a carrier, a location, and an associated name. That someone is you.
The bad version:
- Paste each number into a reverse-lookup site one at a time, copy carrier and location into the workbook manually — 500 rows, three fields each, at minimum a half-day of nothing but copy and paste
- Export the column to CSV, upload it to a bulk lookup tool, download the results file, import it back into Excel, discover the results landed in a new workbook instead of the original table and now you're reconciling two files
- Ask a developer to write a Python script that calls Datagma's reverse-lookup endpoint in a loop, handles rate limits, parses JSON, and writes results back — which is a few hours of engineering time for a non-engineering task
Nobody assigned sprint capacity to this list. And the sales team is already asking when it'll be ready.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the Inbound Leads worksheet, understands the layout, and through its built-in Datagma integration it runs reverse-lookup on every number in column A and writes name, carrier, and location into columns B, C, and D — all without leaving the workbook.
For each phone number in column A, run a Datagma reverse lookup and write the associated name, carrier, and location into columns B, C, and D
What You Get
- Column B: associated name where Datagma found a match
- Column C: carrier or network provider
- Column D: geographic location tied to the number
- Rows where Datagma returned no data are noted in column E so the team knows which numbers to triage manually
What If the Data Is Not Quite Ready
The phone numbers have inconsistent formatting
Some are "(555) 867-5309," others are "15558675309" or "+1-555-867-5309." Datagma's API expects E.164 format.
Normalize all phone numbers in column A to E.164 format (+1XXXXXXXXXX), then run Datagma reverse lookup for each one and write name, carrier, and location into columns B, C, and D
You need to score lead quality based on the result
Your team wants to know at a glance which numbers are worth calling. Any number where Datagma found an associated name gets marked "Verified," everything else gets "Unknown."
Reverse-lookup all 500 phone numbers in my 'Inbound Leads' worksheet and add a 'Lead Quality' column using the result — 'Verified' if a name was found, 'Unknown' otherwise
Some numbers are duplicates from repeat callers
The log captured a few numbers multiple times when callers hung up and called back. You want each number looked up only once.
Deduplicate column A by phone number, then run Datagma reverse lookup on the unique set and write name, carrier, and location into columns B, C, and D — mark the duplicate rows in column E
Full normalization, dedup, lookup, and quality score in one shot
The numbers have mixed formats, there are duplicates, and you need a quality column before handing the workbook to sales.
Normalize all phone numbers in column A to E.164 format, deduplicate the list, run Datagma reverse lookup on the unique numbers, write name into column B, carrier into column C, location into column D, and write 'Verified' or 'Unknown' into column E based on whether a name was found
Try It
If your inbound number log is sitting in an Excel workbook with no enrichment, get the 7-day free trial of SheetXAI and open it. Ask it to run Datagma reverse lookup on column A and you'll have carrier, location, and name data written into the workbook before the sales team's next shift. For related workflows, see bulk-enrich a lead list or append mobile phone numbers.