The Scenario
It's 8:45 AM and you're a government affairs manager walking into a lobbying briefing at 9:00. The briefing covers a dozen facility addresses your organization operates, and at least two of the legislators in the room will ask which congressional district each facility sits in. You opened your Excel workbook this morning expecting that data to be there. It isn't. Your predecessor tracked this in a separate workbook that nobody else had access to.
The bad version:
- Look up each address one at a time in Geocodio's web interface, copying the congressional district, state senate district, and state house district from the result page into your workbook manually.
- After the third address, realize you also need the county name and FIPS code for the compliance report that goes out after the briefing — which means starting over with a different field selection.
- Twelve addresses, five fields each, nine minutes left before the meeting. You're going in with whatever you've managed to fill in.
The cognitive load of doing this mid-morning, mid-deadline, for a task you're doing for the second time in a month — that's the kind of work that convinces people to block an hour every quarter just to dread it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the address column, calls Geocodio for each address, and writes the legislative and census fields back into the specified columns — all in one request, without you touching the Geocodio dashboard.
Open the sidebar and paste this prompt:
For each address in column A, use Geocodio single geocode to fetch the congressional district, state senate district, and state house district and write them into columns B, C, and D
What You Get
- Column B: congressional district (e.g., "CA-12" with representative name if requested)
- Column C: state senate district (e.g., "State Senate District 11")
- Column D: state house district (e.g., "State Assembly District 17")
- Addresses that return a partial match get a note in column E so you can review before the report goes out
What If the Data Is Not Quite Ready
Addresses are missing state abbreviations, which causes Geocodio to return ambiguous matches
For each address in column A, check whether it includes a state abbreviation — if not, append the state from column B (State column) before calling Geocodio, then geocode and write the congressional district, state senate district, and state house district into columns C, D, and E
Some facilities span two addresses (main entrance and loading dock) — you need the legislative data for the main address only
For each facility in column A, geocode the primary address (the first one listed if there are two separated by a semicolon) using Geocodio and write the congressional district, state senate district, and county FIPS into columns B, C, and D — flag rows with dual addresses in column E
The briefing doc needs both legislative district names and the elected representative names for each district
Geocode all facility addresses in column A using Geocodio and append the county, FIPS code, congressional district representative name, and school district to each row in columns B through E
The compliance report needs a full kill-chain: normalize address formatting, geocode, append five legislative fields, and flag any facility in a swing district for follow-up
Standardize the address format in column A (fix abbreviations, remove duplicate commas, normalize state names to two-letter codes), then geocode each address using Geocodio and write the congressional district, state senate district, state house district, county FIPS, and a "swing district" flag (Y/N based on whether the congressional district margin was under 5% in the last election) into columns B through F
Running the normalization and enrichment in a single prompt means no intermediate file to manage and no second pass.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your facility addresses. Ask SheetXAI to pull the congressional district, state senate district, and any other Geocodio fields you need — written back into the workbook before your next briefing. See also how to batch geocode large address lists or reverse geocode coordinates to structured addresses.