The Scenario
A real estate analyst at a boutique agency is putting together a client-facing property report for 30 listings. The Excel workbook has addresses and coordinates. The client specifically asked for a visual map thumbnail next to each property so they can orient themselves without clicking through to a separate map tool. The analyst has never worked with a static map API. It is Thursday afternoon and the report goes out Friday morning.
The bad version:
- Read through Geoapify's static map API documentation to find the right endpoint format, understand the zoom, width, height, and marker pin parameters, and manually construct a URL string for each of 30 properties.
- Paste each URL into a browser to verify it renders correctly, discover that three properties have their coordinates transposed and the map points to the ocean, fix those rows, and rebuild the URLs.
- Copy all 30 URLs into the report workbook in column D and then manually insert each one as a hyperlink or embed it in a PowerPoint slide.
The report template is waiting. The analyst's Friday morning is already packed.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Excel workbook. It reads the coordinates, constructs the Geoapify static map image URL for each location with the parameters you specify, and writes the URL into the correct column.
Use Geoapify to create a 400x300 static map image for each property in the Listings sheet using the coordinates in columns C and D — write the map URL into column E
What You Get
- Column E receives a valid Geoapify static map URL for each property row.
- Each URL includes a centered marker pin at the property coordinates at 400x300 resolution.
- The URLs are ready to use in a PowerPoint embed, a Word document link, or a client-facing PDF export.
What If the Data Is Not Quite Ready
The coordinates are in a single column formatted as "lat,lon" instead of two separate columns
Split the coordinate string in column C into lat and lon, then generate a Geoapify static map URL for each property at 400x300 resolution with a marker pin and write the URL into column D
The map size should vary based on a column in the workbook
For each row in the Listings worksheet, generate a Geoapify static map URL using the coordinates in columns C and D — use the width and height from columns E and F, add a marker pin, and write the URL into column G
Some properties should display a different zoom level based on the property type
Generate Geoapify static map URLs for all properties in the Listings worksheet using lat/lon in columns C and D — use zoom level 16 for rows where Type is Residential and zoom level 14 for rows where Type is Commercial, and write the URL into column E
Geocode addresses, generate map URLs at two zoom levels, and add hyperlink formulas for the report
For any row in the Listings worksheet where columns C and D are blank, geocode the address in column B with Geoapify to get coordinates. Then generate two static map URLs per property: one at zoom 15 for the neighborhood view and one at zoom 18 for the street-level view. Write the zoom-15 URL into column E and the zoom-18 URL into column F. Add a HYPERLINK formula in column G that links to the zoom-15 map with the property address as the display text.
One instruction handles the geocoding fallback, dual-zoom URL generation, and formula insertion together.
Try It
Get the 7-day free trial of SheetXAI and open any property worksheet, field site list, or event venue tracker with coordinate data and ask it to generate the map thumbnails. See the related spoke on finding nearby points of interest, or return to the Geoapify hub.