The Scenario
You're a sales analyst at a SaaS startup. The growth team handed you an Excel workbook with 200 prospect domains in column A — scraped from a conference attendee list — and asked you to have it enriched and ready for the SDR team by end of day.
The workbook has domains. That's it. No industry, no headcount, no revenue band, no geography. None of the context the SDRs need to prioritize who to call first.
The bad version:
- Export the domain list as a CSV, upload it somewhere, look up companies on Bigpicture.io one by one, paste enriched values back in
- Spend three hours on a task that should take ten minutes, only to find that fifteen domains return partial data with no revenue figure
- Deliver the workbook two hours late with a note that "some rows are incomplete" — which the SDR team then has to reconcile before they can use it
This is not analysis work. It is data entry with extra steps, and the SDR 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 data you're looking at and talks to Bigpicture.io on your behalf. No API setup, no column mapping configuration, no separate tool.
For every domain in column A, look up the company on Bigpicture.io and fill columns B, C, D, E with industry, employee count, estimated revenue, and country. If a field is unavailable, write "N/A" in that cell and add a note in column F.
What You Get
- Column B: Industry (e.g., "Software," "Healthcare," "Financial Services")
- Column C: Employee count as a number
- Column D: Estimated annual revenue (in USD, formatted consistently)
- Column E: Country code or full country name
- Column F: Any enrichment gaps flagged with a brief note — "No revenue data," "Domain not found," etc.
The SDRs get a workbook they can sort and filter immediately. The analyst gets their afternoon back.
What If the Data Is Not Quite Ready
Some domains have "www." prefixes or trailing slashes
Enrich each domain in column A with Bigpicture.io — strip any "www." prefix or trailing slash before looking up. Write industry, employee count, revenue, and country to columns B through E.
Some rows already have partial enrichment from a previous run
For rows in column A where column B is blank, look up the company on Bigpicture.io and fill columns B through E. Skip rows that already have a value in column B.
The list has a mix of domains and company names — not all are proper domains
Column A has a mix of domains and company names. For each row, determine whether it's a domain or a name, look up the company on Bigpicture.io using the appropriate method, and write industry, employee count, revenue, and country to columns B through E.
Full kill chain: deduplicate the list, enrich what remains, and flag accounts already in our CRM worksheet
Remove duplicate domains from column A, then enrich each unique domain with Bigpicture.io — write industry, employee count, revenue, and country to columns B through E. Cross-reference against the "CRM Accounts" worksheet and add an "Existing" flag in column G for any domain that already appears there.
Each prompt does the cleanup and the enrichment in a single pass — no pre-processing step, no second prompt to apply the logic.
Try It
Open an Excel workbook with a column of prospect or target company domains and get the 7-day free trial of SheetXAI. Ask it to enrich the list with Bigpicture.io firmographic data — industry, headcount, revenue, geography — and it'll fill the columns in one shot. For the IP-to-company version, see the visitor IP resolution spoke, or go back to the Bigpicture.io hub overview.