Papa-Bear-NYC, on Jan 10 2007, 09:16 PM, said:
I have generated a number of waypoints in an Excel spreadsheet and I'd like to get them into my Garmin 60CS. For ease of calculations, I am using UTM (which the Garmin is quite happy with).
But ... the Garmin software (Mapsource) wants it's own format or GPX format. Excel can produce tab delimited text files (or a variety of spread sheet files). Ironically, Mapsource can write tab delimited text files, but it won't read them.
Any suggestions? I could cut and paste them in one by one, but there are too many (about 100)
GPXtoPOI release notes as of 3/2/07
This program converts from GPX format to CSV format or vice versa. You can create waypoints in MapSource and then convert them to POI (CSV) files for download or sharing with others.
You can also convert POI (CSV) files that others have created, and then edit them in MapSource. Now that the Garmin POI loader supports GPX files, GPXtoPOI's most important role is CSV to GPX conversion.
The program has a few other special features:
1- It supports a command line interface, if you want to make it part of a batch, or just have shortcut that does a predefined conversion.
2- It supports a profile mode where an external profile can be used, allowing special conversions (one to many/many to one and various filters and text generation options).
3- It utilizes the recently documented fourth CSV parameter for comment information (which can include address, phone number, etc).
4- In the Waypoint/GPX file, you can include @NN (for instance @55) at the end of the waypoint name to indicate the alert speed, or you can put @55 in the "description" field for the waypoint in MapSource. It will automatically attach it to the name.
5- When converting from POI (CSV) to GPX, if there is an @55, or @25, etc. in the name, it will pull that off of the name, and dump the speed information into the description field.
Get this from garmin's site.