The Scenario
You took over CRM data hygiene from a colleague who left the company three weeks ago. Part of the handoff was a note that said "the Mapulus pins should match the accounts in column A — just check periodically." Column A of your Excel workbook has 50 account IDs. You have no idea which ones have Mapulus pins and which ones don't. Your first task is figuring out the gap.
The bad version:
- Open Mapulus, search for the first account ID by hand, write down whether it had a pin, then repeat for all 50
- Copy the results into the workbook manually, realizing mid-way through that Mapulus's search doesn't always surface exact ID matches and you're not sure if "not found" means the pin doesn't exist or just that the search missed it
- Get through 30 of the 50 IDs before a Slack message pulls you away, and come back 45 minutes later unable to remember where you were in the list
The reconciliation itself is not complicated. What makes it miserable is doing it one ID at a time against a UI that wasn't built for batch lookups.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the external IDs in your workbook, queries Mapulus for each one, and writes the match results back into the adjacent columns — without you touching the Mapulus dashboard once.
For each external ID in column A, search Mapulus for a matching location pin and write the location name into column B, latitude into column C, longitude into column D, and "not found" into columns B, C, and D if there is no match — process all 50 rows
What You Get
- Column B gets the matched Mapulus location name, or "not found"
- Columns C and D get the latitude and longitude of the matched pin
- Every row in column A is processed — no manual verification needed
- "Not found" entries make the gap immediately visible so you can prioritize which accounts need pins created
What If the Data Is Not Quite Ready
Some IDs in column A have trailing spaces or inconsistent casing
The external IDs were pasted in from a CSV export and some have formatting quirks that could break the match.
Clean any whitespace and standardize the casing of all values in column A, then search Mapulus for a matching location for each cleaned ID and write the results into columns B, C, and D — "not found" where there is no match
A match was found but you need the Mapulus location ID too, not just the name
You'll need to pass the Mapulus location ID back to the developer who's going to create the missing pins programmatically.
For each external ID in column A, search Mapulus for a matching location and write the Mapulus location ID into column B, location name into column C, and "not found" into both columns if there is no match
You only want to process rows where column E says "Active"
Not all accounts in the workbook are currently active, and you only need to reconcile the live ones.
For each row where column E says "Active", search Mapulus for a location matching the external ID in column A and write the match result into columns B and C — skip any row where column E is not "Active"
Full reconciliation: clean IDs, match against Mapulus, flag gaps, and summarize
Your manager wants a complete reconciliation report — cleaned data, match results, and a gap count.
Trim whitespace from all values in column A, search Mapulus for a matching location for each ID, write location name into column B and coordinates into columns C and D, write "not found" in those columns for any ID with no match, then add a summary row at the bottom showing total IDs checked, matched count, and unmatched count
One prompt handles the cleanup, the lookup, and the summary — you walk away with a finished reconciliation, not a half-done checklist.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of CRM account IDs, then ask SheetXAI to reconcile them against your Mapulus location pins and write the results back. When you're ready to go further, see how to pull your full map inventory or build a detailed map metadata registry.