grid reference conversion to Latitude & Longitude

**clanmurray** · 03-20-2011, 07:13 PM

Can anyone help me with this?
I have over 500 Grid ref locations that I wish to convert to Long & Lat

The following Grid ref NO305105 converts to -3.1249666,56.2816999 I have used various web sites which allow you to convert one at a time.

Can I paste my info to Excel and convert to Long & Lat? This will then allow me to convert to Ov2 file for my Tom tom.

Any help greatly appreciated.

Davy

**alansidman** · 03-20-2011, 07:25 PM

A couple of years ago, I was looking for a conversion in Excel and found the attached. Not sure if it will work for you, but look it over and see if you can make it happen.

Alan

**clanmurray** · 03-21-2011, 12:16 PM

Thanks for the information Alan, Very informative spreadsheet, but, I haven't got a clue how to use it. Shall work away with it to see if I can find out how to use it.

David

**alansidman** · 03-21-2011, 12:50 PM

Click on the help link on the first worksheet and it will take you to a website with additional information. Good Luck. Wish I could help, but I don't use it.

Alan

**steet** · 03-21-2011, 11:22 PM

Hi Davy,

Just checking in to see if you found a batch converter? I have 1600 OS Grid Ref plots I need to convert to Lat long

by Friday

**clanmurray** · 03-22-2011, 06:19 PM

No, still surfing various web sites trying to locate one. If you find one please let me know.

Davy

**jazbaati99** · 01-04-2016, 08:02 AM

Hello, stumbled upon this thread while searching for a similar solution. I found this website very useful http://www.gridreferencefinder.com/b...tchConvert.php