Converting eastings / northings to Latitude / longitude or KML

[Zamyatin]

I have a large amount of Northings - Eastings data which I need to convert
into Latitude - Longitude, or KML data.

I can do this manually but it is very time consuming.

Does anyone know of some VBA code or other means of converting my data together?

Thanks!

 

[Gerald Higgins]

Hi, welcome to the board.

Can you give us some examples of what exactly you want to do ?

I know what Northings, Eastings, Lat and Long are, but what's KML ?

 

[Zamyatin]

Location Easting Northing
Ogle Street Car Park 453295.59 349363.45
Market Place outside Library 453383.09 349347.56
Annesley Road/Baker Street 453427.73 349452.48


Hi, thanks for the reply

I've posted some sample info above.

Ideally I would end up with the E/N data in the shape of latitude -longitude.

So the first example would be 53.038894, -1.206613

KML is keyhole mark up language, used for coding data for use on a map

Thanks again!

 

[Gerald Higgins]

OK thanks, so what process do you go through to do this manually ?

 

[Zamyatin]

Website like this

http://www.nearby.org.uk/coord.cgi?p=453295.59,+349363.45&f=full#llSK5329549363

 

[Gerald Higgins]

OK thanks, I was hoping for some kind of equation.

I think there are two possible approaches for you.

First, if you are happy to rely on that website (or some other that does the same job), there are probably ways that you can write a macro that will automate the process that you go through, of inputting your Northings and Eastings and capturing the output generated by the website. That is beyond my capabilities, sorry, but probably not beyond that of other people on this board. There are lots of threads on here about automating interaction with websites.

Second, if you can find some kind of equation that does the calculation, you could write an Excel formula that does the same thing, and we can help you write that formula if you can't do it yourself. I did a bit of research on finding out the equation but I'm afraid I don't have time to do this fully, but I'm sure the answer is out there.

 

[Zamyatin]

Thanks for the advice, I'll look into what you've suggested

Cheers!

 

[ravi4ever]

I really do not have any idea of the calculations but found these links which can help in the calculations..

http://www.cpearson.com/excel/LatLong.aspx (check
http://www.cpearson.com/Zips/LatLong.zip (Excel file for calculations..)

http://www.earthpoint.us/ExcelToKml.aspx

 

[Zamyatin]

Thanks to everyone who gave me some help

For future reference, this enables you to upload northings / eastings and convert en masse to lat / long

http://gridreferencefinder.com/batchConvert/batchConvert.htm

Not perfect, but workable!