Map Extract
Free tool

Radius and distance calculator for lead lists

Give a centre point and a radius, paste or open a CSV with latitude and longitude columns, and keep only the rows inside the circle, nearest first, with the distance and direction added to each. A second mode measures the straight-line distance between any two points.

Runs in your browser. Nothing you enter is uploaded.

Filtering a list by distance

  1. 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.

  2. 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.

  3. Confirm the columns

    Headers such as latitude, lat, lng, lon and Map Extract's gm_latitude and gm_longitude are 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.

  4. 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.

  5. Download

    Download filtered CSV saves every row inside the radius, sorted nearest first, with all your original columns plus distance_miles or distance_km and bearing_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.

Input
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,,
Result
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 containsWhat the calculator does
Empty latitude or longitudeCounted under no usable coordinates and left out of the download.
Exactly 0 and 0Treated 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,48Read as 53.48. This is common in files saved by European versions of Excel.
Latitude above 90 or longitude above 180Counted as unusable. Check whether the two columns have been swapped.
Quoted text containing commas or line breaksKept 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

Top