Skip to content

Instantly share code, notes, and snippets.

@evenevan

evenevan/csv to gpx.md

Last active June 22, 2024 22:10
Show Gist options
  • Save evenevan/4253a37306f05b149142c802e4caffe3 to your computer and use it in GitHub Desktop.
Save evenevan/4253a37306f05b149142c802e4caffe3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
csv to gpx.md

csv to gpx using gpsbabbel

using this format https://www.gpsbabel.org/htmldoc-development/fmt_unicsv.html

in the universal csv format, we can use lat, long, alt, time, date, temp, speed

use below for the time and date fields. with the gpsbabbel gui, the utc offset can also be specified

iso8601

to get utc_d and utc_t, use =TEXT(DATE(MID(A1,1,4),MID(A1,6,2),MID(A1,9,2)),"yyyy/mm/dd") and =TEXT(TIME(VALUE(MID(A1,12,2))+2,VALUE(MID(A1,15,2)),VALUE(MID(A1,18,2))), "HH:MM:SS") on a column with iso8601

YYYY-MM-DD 00:00:00 AM

=TEXT(E2, "yyyy-mm-dd")

=TEXT(E2, "HH:MM:SS")

tracks to waypoints

Use -x transform,wpt=trk

.\gpsbabel -w -i gpx -f C:/Users/User/Downloads/test1.gpx -x transform,wpt=trk -o gpx -F C:/Users/User/Downloads/test2.gpx
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment