You are hereForums / Windows Software / Tips and Tricks / Inputting multiple points from a spreadsheet
Inputting multiple points from a spreadsheet
I have a large list of points I'd like to import into BCN. Right now the list is in an Excel spreadsheet in lat/lon. I can easily convert to a comma-delimited text file. I have access to Google Earth Pro, so I can quickly import the points and export to a KML/KMZ file.
Using these tools and/or free web software, does anyone know of a way to fairly quickly import a large list of points into BCN waypoints? I have the desktop and PPC versions.
Thanks,
Jason
Tags
Share This Page
Share |
I also asked this question over in the Geocaching forums and got an answer there.
GPSBabel can convert from comma-delimited to gpx, as can the latest version of GSAK. Also the GPSVisualizer web site (free) can convert comma-delimited points to a route/track.
I saved the coords as a comma-delimited file, copy-n-pasted to GPSVisualizer and directed the output to a route. This was saved as a XML file, which I renamed to a GPX file, and directly imported into BCN.
I now have all the proposed tower locations for an 100+ mile transmission line we're designing shown as points in BCN. This will GREATLY help in navigation to specific tower sites in the open desert with limited access roads and no signs.
Thanks again for the awesome program!