How to find the nearest supermarket to each address in a list
Upload a list of addresses and get, for every row, the closest supermarket, how far it is and how many sit within walking distance. How to set it up and read it.
Part of the guide Location intelligence automation
To find the nearest supermarket to each address in a list, place every address on the map, search around each one for supermarket types, and keep the search in counting mode so each address stays a row and gains three answers: the closest supermarket's name, its distance in metres, and how many supermarkets sit within the distance you chose. You get your own list back, enriched, instead of a pile of shops to match by hand.
Property developers use this to describe homes, landlords and estate agents to price them, councils and charities to find food deserts, delivery and dark store planners to judge demand, and grocery chains to check where their own stores stand. The sections below explain the setup, the reading, a made-up example, what to watch out for, and an AI employee that reruns it monthly.
Step one: get the addresses onto the map
Upload your list as a CSV or a Google Sheets link to My data. If it already has latitude and longitude columns, they are read straight away. If it only has an address and a city, rows without a position are placed from those columns. Check a handful afterwards: an address with a typo or a missing city can land in the wrong place, and every answer after that will be wrong for that row.
Step two: search around each address
Put Nearby places after My data and set:
- Where: each incoming place.
- Types: supermarket, discount supermarket and, if you want them, hypermarket and grocery store. The Supermarket group itself is small, so add the others deliberately rather than by accident.
- Within: 500 m for walking distance, 1 km for a short walk or a quick drive, more for suburbs and towns.
- Pass on: each incoming place, with counts.
Each address comes back with nearby_count (how many within the distance), nearby_nearest and nearby_nearest_m (the closest one and its distance), the average rating of those found, how many belong to a chain, and, with two types or more, a count per type. A run handles up to 100 addresses; for a longer list, split the table into parts of 100 or run it a part at a time.
How dense supermarkets are in three cities
How you read the counts depends on the city. xMap's places database, November 2026, gives a sense of the spread within 10 km of three city centres:
In London, an address with none within 500 m is unusual and worth a look. In Toronto, the same answer may be normal outside the core, and a 1 km radius is the fairer test. The chain mix differs too: of the 437 London supermarkets nearest the centre, 68% belong to a chain, while in Toronto 34% of the 82 do. Set your distance and your expectations city by city.
A made-up example: a letting agent
Invented, to show the method. A letting agent in Melbourne has 60 flats on its books and wants each listing to say how far the nearest supermarket is. It uploads the addresses, searches supermarket and discount supermarket within 1 km of each, and sorts by distance.
| Made-up flat | Nearest supermarket | Distance | Supermarkets within 1 km |
|---|---|---|---|
| Flat 12, inner suburb | a chain store on the high street | 180 m | 4 |
| Flat 31, near the rail line | a discount supermarket | 640 m | 1 |
| Flat 47, new estate | none within 1 km | - | 0 |
Invented addresses and figures to explain the reading.
Flat 12's listing can say "supermarket three minutes' walk away". Flat 47 gets a run with a 3 km radius instead, and the agent learns that buyers of the new estate will drive to shop.
What to watch out for
- Supermarket versus grocery. Corner grocers and convenience shops are useful to residents but a different promise from a full supermarket. Report them separately with a count per type.
- Closed stores. Places marked closed are left out unless you switch off Only places that are open.
- Old data in the description. The database is refreshed every month. Rerun before publishing a listing.
- Badly placed rows. Check addresses that come back with zero supermarkets in a dense city; often the row was placed in the wrong spot.
An AI employee that keeps the answers fresh
- Schedule: on the first of each month.
- My data: your addresses, placed on the map.
- Nearby places: supermarket types around each, with counts.
- Sort and limit: the farthest from a supermarket first.
- Show on a map and an email with the list, each address with its nearest store and distance.
To look at it the other way round, from new homes that lack shops, the template New homes with no supermarket yet does exactly that; Neighbourhoods without a grocery store adds who lives there. Retail and property teams will find related flows under real estate, and the method is part of the guide to location intelligence automation.
Questions
How many addresses can I check at once?
Up to 100 in one run of Nearby places around each incoming place. Split longer lists into parts and run each.
Is the distance by road or in a straight line?
In a straight line. Walking or driving routes are usually longer, especially across rivers, rail lines or big roads.
Can I count grocery stores and supermarkets separately?
Yes. Pick both types and each address gets a count for each type as well as the total.
What if an address has no supermarket nearby?
It comes back with a count of zero and no nearest store. Rerun those rows with a larger distance to find how far the nearest one is.
Templates that do this
Read next
More on business and places data · Every article · Templates