The Scenario
You run a travel concierge service and your team has been collecting destination requests from customers for the past three months. A hundred rows in an Excel workbook: things like "Eiffel Tower Paris," "Central Park New York," "the big market in Marrakech," "JFK airport." Some are precise. Some are guesses at what the customer meant. Before you can plan itineraries, you need official place names, categories, and precise coordinates for every entry. A junior team member tried to do it manually last week and gave up at row 30.
The bad version:
- Copy the first query, paste it into TomTom's fuzzy search developer tool, find the top result in the JSON, read out the official name, category, address, latitude, and longitude, type them into the workbook
- Do that 100 times
- Discover at row 75 that "the big market in Marrakech" resolved to a hardware store, and you typed it in without checking
The itinerary planning starts Monday. The dataset needs to be resolved before then.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the location queries, calls TomTom fuzzy search for each one, and writes the top result's structured data back into the workbook.
For each free-text search term in column A of my Excel sheet, call TomTom fuzzy search and write the first result's place name, country, and lat/lng into columns B, C, D, and E
What You Get
- Column B: official place name from TomTom
- Column C: country of the resolved location
- Column D: latitude
- Column E: longitude
- Blank rows where TomTom returned no results — easy to review manually
What If the Data Is Not Quite Ready
Queries have country context that should bias results
For each query in column A, append the country in column B to form a location-biased search, then call TomTom fuzzy search and write the top result's official name, category, and lat/lng into columns C, D, E, and F.
You need the top 3 results for ambiguous queries
For each location query in column A, call TomTom fuzzy search and write the top 3 results — each result's name, category, and lat/lng — into columns B through J so you can choose the correct one for ambiguous entries.
Queries include categories alongside place names
For each location query in column A of this workbook, run a TomTom fuzzy search and write the top result's official name, category, formatted address, latitude, and longitude into columns B through F
Full resolution with confidence tagging
For each query in column A, run TomTom fuzzy search and write the top result's official name into column B, category into column C, and lat/lng into columns D and E. If the category returned is not one of "landmark," "airport," "park," or "museum," flag the row in column F with "review" so the team can verify those before itinerary planning starts.
One prompt resolves all 100 queries and flags the ones that need a human check.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your customer destination queries, then ask it to resolve each one using TomTom fuzzy search. For enriching resolved locations with nearby POIs, see the named POI search spoke.