Transfer an excel file to Mapsource or POI file

 

I have an spreadsheet containing numerous locations all with British Nation Grid References (NGR) (eg. TL 89210 28406) locations (rather than long and latitude). I want to convert them into a POI file as quickly as possible.

Does anyone know a quicker way as apposed to converting each NGR to Long and lat manually.

The spread sheet is set up similar to a conventional POI CVS file; NGR,name,comment.

Thanks in advance.

.

Here's a way you may be able to convert the NGR to Lat,Long.

http://www.dmap.co.uk/ll2tm.htm

Scroll done for the Excel information.

Check out GPSU

GPSU has that Grid style configuration. It has a free trial with certain numbers of points and a shareware fee to unlock the full version. http://www.gpsu.co.uk/index.html
You may need to save your data as a csv.

--
Zumo 550 & Zumo 665 My alarm clock is sunshine on chrome.

UK Ordnance Survey

Also some good free stuff here:
http://gps.ordnancesurvey.co.uk/convert.asp

Free online & downloadable single & batch conversion progs as well as a spreadsheet of functions.

--
It's about the Line- If a line can be drawn between the powers granted and the rights retained, it would seem to be the same thing, whether the latter be secured by declaring that they shall not be abridged, or that the former shall not be extended.