Filtering a list by distance
Set the centre and radius
Keep Filter a list by radius selected. Type the centre as decimal latitude, longitude (for example
53.4808, -2.2426), choose Miles or Kilometres and enter the radius.Load the businesses
Paste CSV text into the box, or use Open a CSV file to read one from your computer. Commas, semicolons and tabs are all detected. The first 5,000 data rows are checked.
Confirm the columns
Headers such as
latitude,lat,lng,lonand Map Extract'sgm_latitudeandgm_longitudeare picked automatically. If your file uses other names, choose the columns from the two lists. Untick First row is a header for files without one.Read the counts
Three figures show how many rows are inside the radius, how many are outside and how many had no usable coordinates. The table lists the nearest 200 with their distance and a compass direction from the centre.
Download
Download filtered CSV saves every row inside the radius, sorted nearest first, with all your original columns plus
distance_milesordistance_kmandbearing_from_centre.
Example: trade customers within 5 miles of a Manchester showroom
A tile showroom in central Manchester wants to invite nearby trades to an open evening and has eight prospects from different towns, one of them with no pin. With the centre at 53.4808, -2.2426 and a radius of 5 miles, three rows are kept, four are outside (Oldham, Stockport, Bolton and Warrington) and one has no usable coordinates. Raising the radius to 10 miles keeps five.
All business names here are invented. The bearing column is the direction from the showroom to each business, which helps when you plan visits by area.
Centre: 53.4808, -2.2426 Radius: 5 miles business,town,latitude,longitude Harbour Bakery,Manchester,53.4794,-2.2427 Quayside Joinery,Salford,53.4723,-2.2935 Moorland Roofing,Oldham,53.5409,-2.1114 Riverside Glazing,Stockport,53.4106,-2.1575 Fellside Plumbing,Bolton,53.5769,-2.4282 Weir Electrical,Warrington,53.3900,-2.5970 Canal Street Florist,Manchester,53.4770,-2.2350 No Pin Decorators,Bury,,
business,town,latitude,longitude,distance_miles,bearing_from_centre Harbour Bakery,Manchester,53.4794,-2.2427,0.10,S Canal Street Florist,Manchester,53.4770,-2.2350,0.41,SE Quayside Joinery,Salford,53.4723,-2.2935,2.17,WSW 3 within 5 miles, 4 outside, 1 with no usable coordinates
How the distance is worked out
Distances are great-circle distances: the shortest path over the surface of a sphere, calculated with the haversine formula. The sphere uses the mean Earth radius of 6,371.0088 km. The real Earth is slightly flattened, so a spherical figure can differ from a survey-grade ellipsoid calculation by up to about half a per cent. Across a county that is a few hundred metres at most, which is far smaller than the uncertainty in where a map pin was placed.
Miles are international miles of exactly 1.609344 km. The bearing is the initial compass direction from the centre to each point, rounded to one of 16 points such as NNE or WSW. In two-point mode you also get the midpoint along the great circle, useful for choosing a meeting place or the centre of a combined area.
These are straight-line figures. Driving distance is usually longer, and in places with rivers, estuaries or hills it can be much longer. Use the radius to narrow a list, then judge real travel times for the businesses that are left.
What happens to awkward rows
| Row contains | What the calculator does |
|---|---|
| Empty latitude or longitude | Counted under no usable coordinates and left out of the download. |
| Exactly 0 and 0 | Treated as missing. Exports often write 0, 0 when a location is unknown, and that point is in the Gulf of Guinea. |
A comma as the decimal mark, such as 53,48 | Read as 53.48. This is common in files saved by European versions of Excel. |
| Latitude above 90 or longitude above 180 | Counted as unusable. Check whether the two columns have been swapped. |
| Quoted text containing commas or line breaks | Kept intact, following the usual CSV quoting rules, and written back the same way. |
Picking a sensible radius
- For visits on foot or by bike in a city, start at 1 to 2 miles.
- For a van-based trade covering a town, 10 to 15 miles is a common service area; check what your own customers accept.
- When a list was built from several overlapping searches, filter by radius before you remove duplicates, so you only clean the rows you will keep.
- If a lot of rows fall into no usable coordinates, look up their postcodes first rather than widening the radius.
Questions people ask
How do I find all addresses within a radius of a point?
You need coordinates for each address first, as latitude and longitude columns in a spreadsheet. Save or copy it as CSV, set your centre and radius here and the calculator keeps every row inside the circle, sorted by distance. If your list only has postcodes, convert them to coordinates with a postcode lookup before filtering.
Is the haversine formula accurate enough?
For lead lists, yes. Haversine treats the Earth as a sphere, which is within about 0.5% of the more exact ellipsoid figure. Over 10 miles that is roughly 80 metres at worst, and usually much less. A business pin on a map is rarely placed more precisely than that, so the formula is not the weak link.
Why does the distance differ from Google Maps directions?
Google's directions give the length of a route along roads, which bends around buildings, rivers and one-way systems. This calculator gives the straight line between two points, sometimes called distance as the crow flies. The road distance is always at least as long and is often a third longer or more in towns.
Which columns does it recognise automatically?
Headers named lat, latitude, lng, lon, long or longitude, with any capitalisation, plus names that contain those words such as Store Latitude, and Map Extract's own gm_latitude, gm_longitude, bing_latitude and apple_latitude style columns. If nothing matches, pick the two columns from the lists that appear under the box.
Can I measure the distance between two postcodes?
Not directly, because the calculator works with coordinates. Look up each postcode's latitude and longitude, then switch to Distance between two points and type both pairs. You get the distance in miles and kilometres, the compass bearing from the first point and the midpoint.
Is there a limit on file size?
The calculator checks the first 5,000 data rows of a file, which keeps the page quick on most laptops and phones, and tells you when it has stopped early. For a longer list, split the file into parts, filter each one with the same centre and radius and join the downloads afterwards.
Where your data goes
Your CSV is read by this tab, whether you paste it or open it from disk, and is never uploaded. The calculations use no map service and no network connection, and the filtered file is created on your device. Closing the tab clears everything you loaded.
Checked against the tool on