Excel To Gpx Waypoint Conversion Tool

[kjunmed]

Hello Saifan Pilot, I am having a terrible time trying get this data to convert. I keep getting "Runtime error 13" "Type Mismatch" . I have gone through the data several times and can not fine the error. If you could look over this data and maybe give me some insight on where I am failing? I would greatly appreciate any help you can give me. 

 

Thanks for taking your time to write this program. I am running this on an Macbook Pro using office 365

 

[kjunmed]

A great Tool, I was able to find my errors after putting a way for the night and coming back this AM. 

[krizkaoz]

Hey guys, this spreadsheet sounds like exactly what I'm looking for but the links don't work.

I'm currently plotting waypoints to visit on Viewranger from Excel by hand, it takes ages.

I'm in Northern Ireland and the data comes in the form of an excel spreadsheet, Irish grid letter directly followed by easting and northing in one cell.

If this spreadsheet will help can someone please send it to me?

Cheers.

[swanie]

Hey Krizkaoz make an account to access the file. 
Thanks Saifan Pilot for making this.. 

Cheers, 

Tom

[Saifan Pilot]

On 3/10/2019 at 11:06 AM, krizkaoz said:

Hey guys, this spreadsheet sounds like exactly what I'm looking for but the links don't work.

I'm currently plotting waypoints to visit on Viewranger from Excel by hand, it takes ages.

I'm in Northern Ireland and the data comes in the form of an excel spreadsheet, Irish grid letter directly followed by easting and northing in one cell.

If this spreadsheet will help can someone please send it to me?

Cheers.

https://www.dropbox.com/s/yt4dsrxanr2n72i/Excel2GPS v3.00.xlsm?dl=0

[orin]

Hi,

Just wanted to add my kudos/thanks for your work on this spreadsheet.  I've was looking for a way to convert on my Mac for survey work and found your solution.  Perfect!!  Thanks again.

Orin

[Saifan Pilot]

On 4/15/2019 at 3:15 PM, orin said:

Hi,

Just wanted to add my kudos/thanks for your work on this spreadsheet.  I've was looking for a way to convert on my Mac for survey work and found your solution.  Perfect!!  Thanks again.

Orin

Glad you found it useful.

I often got customers who would give me hundreds of waypoints in a spreadsheet and they had no idea how to convert them to a useable GPS file, so I figured I had to come up with something on my own