The Scenario
Your team has been building a location research automation using TomTom's POI search API, and the developer who knows TomTom's category system just went on sabbatical. You're left with a half-built lookup table that maps category IDs to human-readable names — and it has obvious gaps. The search queries your automation sends are pulling back inconsistent results because some category IDs are wrong. Before you can fix the queries, you need the complete, authoritative list of TomTom's POI categories in a workbook you can reference.
The bad version:
- Find TomTom's category list in the developer documentation, which is a long nested HTML table that doesn't export cleanly
- Manually copy each category name and ID into the workbook, try to preserve the parent-child hierarchy, and get to row 150 before the page freezes and you lose progress
- End up with a partial list that covers the categories you happened to paste before giving up
The developer is on sabbatical for three weeks. The lookup table is broken right now.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It calls TomTom's category endpoint, retrieves the full taxonomy, and writes every category ID and name into the workbook in one operation.
Get all TomTom POI categories and write their IDs, names, and parent category IDs into this Excel sheet so I can build a hierarchy reference
What You Get
- One row per TomTom POI category
- Column A: category ID
- Column B: category name
- Column C: parent category ID (for building the hierarchy)
- Complete list, not just the categories that happen to appear in the documentation examples
What If the Data Is Not Quite Ready
You only need the top-level categories
Fetch all TomTom POI categories and write their IDs, names, and parent category IDs into this workbook. Then filter to only rows where the parent category ID is empty or null, indicating top-level categories, and write those to a separate "Top Level" sheet.
You need the list formatted for use in a dropdown validation
Fetch all TomTom POI category IDs and names. Write each name into column A and the corresponding ID into column B. Sort column A alphabetically so the list is ready to use as a data validation source for a dropdown in another sheet.
You want to filter to a specific branch of the taxonomy
Fetch the full TomTom POI category list. Write all categories where the name or parent name contains "food" or "restaurant" into this workbook, with category ID in column A and name in column B.
Full hierarchy table with search result counts
Fetch the full TomTom POI category taxonomy and write category ID, name, and parent category ID into columns A, B, and C. Then for each category, query TomTom POI search using the center of London as a reference point and write the number of results returned within 5km into column D. Sort by column D descending.
One prompt builds the complete taxonomy table and adds a result-count column for context.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to export the full TomTom POI category list. Once you have the reference table, see the nearby POI enrichment spoke to put those category IDs to work on your location data.