Find Named Points of Interest Near Locations Listed in an Excel workbook

The Scenario

You're writing property listing summaries for a commercial real estate firm. Fifteen target neighborhoods are in the workbook. For each one, the brief says to include the nearest hospital, pharmacy, and primary school — distances included. It's the kind of enrichment that makes a listing look researched and thorough, and the account manager wants the draft by 3 PM.

It's 11 AM. You have 15 locations and 3 POI types per location. That's 45 TomTom searches you have no efficient way to run.

The bad version:

• Go to TomTom's POI search developer page, enter the first neighborhood's coordinates, search for "hospital," read the first result's name and distance, paste them into the workbook
• Repeat for pharmacy, then primary school, then move to neighborhood 2
• 45 searches at 2-3 minutes each is a full morning, and you still have to write the summaries after

The copy is due at 3. The research phase was supposed to take an hour.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the neighborhood locations, calls TomTom POI search for each named place type, and writes the results back into the columns you specify.

For each lat/lng pair in columns A and B of my sheet, search for EV charging stations within 2km using TomTom and write the number found and the nearest station's name and distance into columns C, D, and E

What You Get

• Column C: count of EV charging stations (or whichever category you specify) within the radius
• Column D: name of the nearest station
• Column E: distance to the nearest station in metres

What If the Data Is Not Quite Ready

Addresses need geocoding first

For each neighborhood address in column A, geocode it using TomTom and write lat/lng into columns B and C. Then use those coordinates to find the nearest hospital, pharmacy, and school using TomTom POI search. Write each name and distance in metres into columns D through I.

Results need to be formatted for direct use in listing copy

For each neighborhood address in column A, find the nearest hospital, pharmacy, and school using TomTom POI search. Write a single formatted sentence for each row into column B, for example: "Within 400m: St. Mary's Hospital, Boots Pharmacy, Greenfield Primary School."

You need results for multiple POI types in one pass

For each neighborhood address in column A, find the nearest hospital, pharmacy, school, and supermarket using TomTom POI search. Write name and distance in metres for each into columns B through I.

Full neighborhood scorecard in one shot

For each neighborhood in column A, geocode the address using TomTom, then find the nearest hospital, pharmacy, school, and supermarket. Write each name and distance in metres into columns B through I. Then write a one-sentence summary combining all four results into column J.

One prompt handles the geocoding, four POI lookups, and the summary text.

Try It

Get the 7-day free trial of SheetXAI and open the Excel workbook with your neighborhood list, then ask it to find the nearest named POIs using TomTom. For scoring locations by POI category counts rather than named results, see the nearby POI enrichment spoke.