Saifan Pilot

Excel To Gpx Waypoint Conversion Tool

8 posts in this topic

Hello all,

Often customers provide us with a list of waypoints for a job in a spreadsheet or table.

There are online tools that can help converting these to a GPS file, however they're are cumbersome to use and also require internet connectivity.

 

I created the attached tool, waypoints in Lat/Long or UTM coordinates can be copy pasted into this tool written in Excel which can generate a GPX output file that can be uploaded to your GPS.

 

Instructions on how to use it are provided in the spreadsheet, basically you copy paste the waypoint names, optional description or comment, Lat and Long or UTM coordinates and then click the conversion button, which creates a GPX file, which can be uploaded to your GPS using Garmin Map Source or Base Camp.

 

If you find any issues or bugs, please let me know.

 

P.S

I wrote this on a Mac, it should work also in Windows, but I can not test it, let me know if there are any issues in Windows.

 

Download link: https://www.dropbox.com/s/o9fw4076xddsftu/Excel2GPX%20v1.02.xlsm.zip?dl=0

Share this post


Link to post
Share on other sites

Table can include as many rows as you like. An example of a table containing 3 rows (waypoints), would look like this:

 

uqUOAbs.png

Share this post


Link to post
Share on other sites

Thanks so much for the work you have put into this Guy! I have the 2008 version of Excel which won't open macro's on my Mac but I can open it and see how much effort you've put into it, it's a very user friendly interface and I'm sure it works very well. Is there anything iPad based that you recommend to open and convert in a hurry in the bush or are we relegated to using our laptops/PC's?

Share this post


Link to post
Share on other sites

It might work in Excel 2008, note this tool relies on macros to function properly therefore you MUST enable macros. If the following window pops up when you launch the tool you MUST click on "Enable Macros" else it will not work. This is also true for Excell 2011 on Mac and the Windows Excel versions also.

p4d041P.png

In windows the process to enable Macros is slightly different, usually brings up a tab above the spreadsheet that will look like this:Qz4r8ZV.jpg

You would then need to click on the Options... button, then on the next window click on "Enable this content" and click OK

2GuNkrF.jpg

 

 

I'm not sure anything would work on an iPad for this.

The only other way I know of converting a list of user waypoints from Excel to Garmin GPX file (which is how I used to do it until I created this tool) is using GPS Data Team's POI Converter https://garmin.gps-data-team.com/poi_manager.php
It's much more cumbersome to use. You MUST format the Excel spread sheet in the following format and order
Decimal Long, Decimal Lat, Name
So it would look something like this:
kV4kRMt.png
Then you would need to FileSave as...
Select Format: Windows Comma Separated Values (.CSV)
hTDy0x4.png
The CSV file will look like this:
-110.123,56.4,WP 001
-111.234,58.75,WP 002
-111.375,58.885,WP 003
Then you can use the generated CSV file with data-team link above, and click the GPX button to save it as a GPX file.
Again, this process is much more cumbersome, and only works with decimal degrees (DD.ddd), it will not work with other formats (DD MM SS.sss, nor DD MM.mmm nor UTM) and requires internet connectivity which we don't always have in the bush.
Hope this helps.

Share this post


Link to post
Share on other sites

Hey Guy,

 

When I open mine and my wife's versions of Excel, it tells me that Visual Basic macros do not work in Office 2008 for Mac. It looks like it might be time to upgrade!

 

Thanks for your time and effort!

Share this post


Link to post
Share on other sites

Wow. That is awesome. Thank you very much for making and sharing this one. I can only imagine how much time went into that one.

Share this post


Link to post
Share on other sites
On 2017-04-27 at 10:16 PM, tomstheword said:

Wow. That is awesome. Thank you very much for making and sharing this one. I can only imagine how much time went into that one.

You're welcome.

I updated it to version 2.1 (fixed bug around the equator and also added by request waypoint date, Time, Elevation).

 

Excel2GPX v2.10.xlsm.zip

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now