Waypoints in Excel -&gt; GPS ?

Waypoints in Excel -> GPS ? File conversion

#1 Papa-Bear-NYC

Geocacher

Group: Members
Posts: 917
Joined: 13-September 05

Posted 10 January 2007 - 07:16 PM

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)

This post has been edited by Papa-Bear-NYC: 10 January 2007 - 07:16 PM

#2 NightPilot

Helicacher

Group: +Premium Members
Posts: 2382
Joined: 26-October 03

Posted 10 January 2007 - 08:40 PM

GPSBabel. It will open .csv or tab delimited files, and speaks Mapsource, or will send straight to the GPS.

#3 CallawayMT

Geocacher

Group: Members
Posts: 363
Joined: 10-October 02

Posted 10 January 2007 - 08:43 PM

Papa-Bear-NYC, on Jan 10 2007, 08:16 PM, said:

PBNYC,

Mapsource is not great for this type of data, and I don't see a way to import your UTM coords. I build and import/export files all the time for projects using survey software, but I also use expertGPS; for which I have paid the $60 dollars for. You can try easyGPS forever or download expertGPS for 30 days free. ExpertGPS will definitely bring in your excell data and then can be exported directly to your Garmin.

If you need help, I would be glad to help you.

CallawayMT

#4 Two Sleepy Ravens

Premium Member

Group: +Premium Members
Posts: 1
Joined: 16-January 08

Posted 26 January 2008 - 09:52 PM

CallawayMT, on Jan 10 2007, 08:43 PM, said:

Papa-Bear-NYC, on Jan 10 2007, 08:16 PM, said:

There are a couple ways to format and convert between different gps formats in excel... I have some macro'ed the others are procedures to follow... throw me an example... contact me directly. thanks.

#5 Black Dog Trackers

Geocacher

Group: +Premium Members
Posts: 2661
Joined: 07-October 01

Posted 27 January 2008 - 07:44 AM

Papa-Bear-NYC -

Would this Waypoint software do it?
http://www.tapr.org/~kh2z/Waypoint/

This post has been edited by Black Dog Trackers: 27 January 2008 - 08:03 AM

#6 GEO*Trailblazer 1

* GEORIENTEER *

Group: +Charter Members
Posts: 4382
Joined: 04-August 02

Posted 27 January 2008 - 07:52 AM

GPSTrackmaker does it all for you.
Import,export and save as many types like KML<KMZ<GPX<CSV<and a host of others.

You can open it then send to Garmin or 100+ other GPS recievers.
I know the New Acrobat(Adobe 8) PDF thingy works too but am still figuring all that out.
Adobe 8 GEOPDF is what I think it is called.
I have been doing some online workshops with Carasoft.

I just did a Excel for a E-911 mapping project and the Surveyor needed it in an excel spread sheet so I made one up and got it sent.
I know you can also use your maps and GPS with Adobe reader,quite nice but still learning it all.

This post has been edited by GEO*Trailblazer 1: 27 January 2008 - 08:02 AM

#7 Black Dog Trackers

Geocacher

Group: +Premium Members
Posts: 2661
Joined: 07-October 01

Posted 27 January 2008 - 08:34 AM

I tried the Waypoint+ software, downloaded my waypoints from my GPSr, switched to UTM coordinates, and exported to a comma-delimted text file. Waypoint+ then was able to open the comma-delimted text file.

So, it will work with excel through a comma-delimted (CSV) file.

#8 Papa-Bear-NYC

Geocacher

Group: Members
Posts: 917
Joined: 13-September 05

Posted 27 January 2008 - 10:08 AM

Black Dog Trackers, on Jan 27 2008, 07:44 AM, said:

Papa-Bear-NYC -

Would this Waypoint software do it?
http://www.tapr.org/~kh2z/Waypoint/

Thanks for the suggestions, but that discussion was a year ago. Since then I've moved everything to GSAK and everything works fine.

How do you guys find these old threads to respond to? :smile:

#9 Black Dog Trackers

Geocacher

Group: +Premium Members
Posts: 2661
Joined: 07-October 01

Posted 27 January 2008 - 10:12 AM

LOL, I saw the message from Two Sleepy Ravens from yesterday, and then looked at the earlier messages were from January. Wrong January! :smile:

#10 DonB

Premium Member

Group: +Premium Members
Posts: 1262
Joined: 31-May 01

Posted 28 January 2008 - 03:57 AM

Papa-Bear-NYC, on Jan 10 2007, 09:16 PM, said:

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.