The Scenario
You are a field sales ops manager. It is Tuesday morning and the territory planning call is at 2 PM. Your regional VP wants a map of all 500 customer accounts color-coded by territory, and the mapping tool requires lat/lng, not street addresses.
Your workbook has 500 rows. Column A is the full street address. Columns B and C are blank.
The bad version of this morning:
- You paste addresses one at a time into a geocoding website
- The website caps batch uploads at 100 rows
- You split the list into five files, upload each one, download the results, paste them back into Excel
- Three addresses come back ambiguous and you have to look them up by hand
- You walk into the 2 PM call with columns B and C still half-empty.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the data and calls HERE Geocoding for you, row by row, writing the results back directly.
Open the SheetXAI sidebar and type:
For each address in column A of my workbook, use HERE Geocoding to get the latitude and longitude and write them to columns B and C. Skip any rows where columns B and C already have values.
SheetXAI reads the address column, calls HERE for each row, handles the skip logic for already-geocoded rows, and writes results into B and C. If HERE returns an ambiguous match, SheetXAI flags that row so you can resolve it without touching the clean rows.
What You Get
A fully geocoded workbook ready for mapping:
- Column B — latitude for each address
- Column C — longitude for each address
- Ambiguous rows flagged — so you know exactly what needs a second look before importing
The output is ready to paste directly into your mapping tool or territory software. No intermediate CSV export, no manual column alignment.
If you want to go further in the same session, tell SheetXAI to filter by territory, group by region, or add a "geocoded on" timestamp to column D.
What If the Data Is Not Quite Ready
Most real address lists are messier than the scenario above. SheetXAI handles the cleanup and the geocoding in the same prompt.
When addresses are split across multiple columns
Your workbook has street in column A, city in column B, region in column C, and postal code in column D.
Combine columns A, B, C, and D into a full address string, then use HERE Geocoding to resolve each row and write lat/lng to columns E and F.
When some rows have blank city or postal code
About 40 rows have the street but nothing else, because the CRM let users skip required fields.
Geocode all rows where column B has a value. For rows where column B is blank, write "incomplete address" in column E and skip the geocoding call.
When you only want to geocode a subset
You have 500 rows but the territory analysis only covers the Northeast region, flagged as "NE" in column D.
Geocode only the rows where column D equals "NE" using HERE, writing lat/lng to columns B and C. Leave all other rows untouched.
When you need to geocode and then immediately use the coordinates
You want coordinates and drive times from HQ in one shot, not two separate operations.
For each address in column A, geocode it with HERE and write lat/lng to columns B and C. Then use those coordinates to calculate driving distance in kilometers from the HQ at 40.7128,-74.0060 and write the distance to column D. Skip rows where column A is blank.
The pattern: instead of geocoding first, waiting, then running routing, you describe the full chain in one prompt. SheetXAI orchestrates both HERE calls end to end.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of addresses, then ask it to geocode them using HERE. The HERE integration is included in every SheetXAI plan. See also how to calculate drive times from a fixed origin or the HERE in Excel overview.