UK Postcode Distance Calculator

**darrenjohnson** · 06-13-2008, 04:37 PM

Hi,

Im looking for and Excel Spreadsheet that calculates the distance between 2 x UK Postcodes in a straight line.

Please, please help!

You can email me the spreadsheet (or contact me) at: helen.darren@hotmail.co.uk

Many thanks,

Darren.

**mrice** · 06-13-2008, 04:50 PM

You'll need something to convert postcodes into GPS coordinates before you can calculate the great circle distance between the two. Such datasets do exist in the commercial arena but there is an interesting non-commercial exercise which might help.

http://www.freethepostcode.org/

If you look at Google Earth, there is a longtitude/latitude display of the cursor position in the bottom left hand corner of the map. If this information was transcribed in a spreadsheet, a formula could be written which calculates the distance.

**mikeyfear** · 06-13-2008, 06:10 PM

I'm not sure on copyright issues, but can the distance between two points not be determined by the OS reference?

The reason I quote that specifically is that streetmap use this as part of their address bar when you search for a postcode.

I.e do a postcode search on there for : LE13 0NP

Would give as part of the results address: x=474892&y=319532
(easily extracted through vba I would have thought)

I've found some javascript code on a site LINK that will then tell you the distance and bearing between two sets of OS x y coordinates as above. Apologies if posting links is frowned upon, but I'm sure someone here could easily convert the java to vba for an excel file... and bob would be your preverbial aunties spouse.

In fact its much simpler than that, the distance in metres is simply SQRT(SumSq(Xa+Xb),(Ya+Yb)).

Therefore where (my previous two work places):
Postcode LE13 0PN ===> X = 474892 Y = 319532
Postcode BD13 1PL ===> X = 409907 Y = 430581

Distance = 1159973.613 (I presume to a precision of 0.1m) equiv 116 Km

Which seems ridiculous short but I suppose it is as the crow flies.

**shg** · 06-13-2008, 09:01 PM

If those are linear units, then the distance between them is

=SQRT(SUMSQ(x1 - x2, y1 - y2) )

**mikeyfear** · 06-14-2008, 06:32 AM

Of course! Ooops. The change in x and change in y forms the triangle where the distance between them is what you're calculating.

Incidentally, a list of postcodes and OS coordinates to XX11 precision is freely available online with a quick search on google.

**johnny938** · 06-10-2010, 12:12 PM

You can use a service like http://postcoder.tenfourzero.net to get the distance for you using DATA from the menu in Excel and then IMPORT EXTERNAL DATA.

**harrycarrick** · 05-06-2011, 02:46 PM

Have a look at postcode.org.uk because i also used this tool or service to calculate the distance through postcode in uk but I don't know much more about this tool. you can try this one and then tell me Is it helpful for you or not??
_____________________________________

Distance Calculator

**adamjoony** · 08-10-2011, 02:10 AM

The online postcode to postcode distance calculator allows you to enter two postcodes and after clicking the 'Calculate Distance' button the Online Postcode to PostCode Travel Distance Calculator will calaculate... wait for it... the distance between the two postcodes you entered! The distance between the postcodes will be shown in kilometres (km) and miles (mi). Additionally that the calculated post code to postcode distance is measured both 'as the crow flies' between the two postcode

distance calculator

**adamjoony** · 08-18-2011, 07:10 AM

Postcode distance calculator is used to calculate the distance between two postcodes..This calculator is very helpful....

distance calculator

**NBVC** · 08-18-2011, 08:02 AM

ummm... you already said so a week ago.

manmade1234 · 12-08-2011, 04:35 AM

Do you know how simple is it to calculate distance online:
Check for online 'Postcode distance calculator UK' in goole, it will help you to get exact solution.
postcode.org.uk
It is working in all over Europe and is expanding its services