CSV-to-GPX-Converter for geocaching.com
This Go application converts coordinates from a CSV to a GPX file. The GPX file follows the standard format so that it can be imported in GSAK. Using the two provided GSAK scripts, you can upload your coordinates to geocaching.com. The provided scripts automatically update the coordinates for each geocache.
You have to provide the GC number and the coordinates for each geocache within the CSV file. Thats the minimal requirement for a successful upload via the geocaching.com API.
The application is configured to work with this pattern:
GC-Code;LAT;LON GC10020;N33° 41.876;W117° 57.297
If you know some Go, you can easily adjust it to your needs. You can also contact me if you need help.
The application creates a GPX file with this format
<gpx> <wpt lat="33.697933" lon="117.954950"><name>GC10020</name></wpt> </gpx>
Build the application with
This creates an executable called csv2gpx.exe in the working directory.
Run the application with
csv2gpx.exe data/input.csv data/output.gpx
Download and install GSAK
In GSAK, go to
Macro -> Execute -> Install or press
CTRL+M -> Install. Select a .gsk file and click install. Repeat for the second macro.
Upload with GSAK
- First, import the converted GPX file in GSAK (CTRL+O)
- Run the macro
SetCorrectedFlag(CTRL+M and doubleclick on it). This will set a flag on all your imported geocaches so the next macro can pick them up for upload.
- Then, run the macro
CorrectedCoord2GCcomand wait until all coordinates are uploaded.
You can also use the provided Dockerfile to build and run the application.
docker build --rm -t csv2gpx . docker run -e INPUT=data/example_input.csv -e OUTPUT=data/example_input.gpx --name csv2gpx csv2gpx # copy gpx to host (replace container id with the real one) docker ps -a docker cp <containerid>:/data/example_input.gpx ./output.gpx
If this saved you some time, you may want to support me.