Import .xls co-ords into Mapsource?

[(RIP) Bin Ridin]

Hi,

I don't seem to have any Import button on the File menu on my Mapsource.
Should there be one?

Any way to import .xls data into the Mapsource as waypoints?
The Lat Long are in columns.

Thanks

Bin

 

[ECM]

THat does not exist. But maybe (very maby) this works:

Save the .xls as a .csv file

Use ITN CONVERTER to make a .gpx file of it.
Mapsource reads .gpx

Tell me if it worked..

 

[(RIP) Bin Ridin]

That URL blocked here in good old Saudi Arabia - how big is the file download?
Thanks,

 

[(RIP) Bin Ridin]

OK, can access from Google - will try it!
Ta,
Bin

 

[AndyW]

Great timing

I was sent an AutoRoute map saved as a .csv file........time to follow ECM's advice to me

Doh!.......ITNC fails to import the data.....no 'Itinerary'

Import the data in AutoRoute to find that there's folks out there with less understanding of Routes etc than me!.......the data wasn't a Route as such, just a bunch of pins on the map!! :lol
Quick play in AutoRoute, re-save the file and ITNC opens the file and exports to .gpx for MapSource

I'm learning .............slowly

Thanks again ECM

 

[(RIP) Bin Ridin]

Hi,

Got help here from IT genius.
Format the Excel into 3 columns, named NAME, Latitude, Longitude.
Use XLSConverter to open this and then save as .CSV
Use POIConverter to open this and save as .GDB

http://rjdavies.users.btopenworld.com/html/xlsconverter.html
http://rjdavies.users.btopenworld.com/html/poiconverter.html

175 POI's Bloody clever, too simple for words.

Bin

 

[AndyW]

Use XLSConverter to open this and then save as .CSV

Why not just select: File / Save As in Excel and choose the .csv file type option....no need for a third part app.

Did you not try ECMs link? ITNConv converts various file types pretty much every which way you could want.......dead simple to use and great the way it integrates with Google Maps.
I've done a summary/write up on ITNConv here with screen shots etc

 

[(RIP) Bin Ridin]

Hi Andy,
I was too dumb to figure it out, so the IT genius did it for me!!
Thanks,
Bin