How to convert .csv to .gpx (or .tcx) file on a Mac
#1
Senior Member
Thread Starter
Join Date: Sep 2008
Location: London
Posts: 2,421
Bikes: Baum Romano, Brompton S2, Homemade Bamboo!
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 474 Post(s)
Liked 204 Times
in
129 Posts
How to convert .csv to .gpx (or .tcx) file on a Mac
I'm looking for a way to convert a .csv file to .gpx (or .tcx) file on a Mac.
To match up a Garmin GPS file to a video file I wanted to edit the data. The only way seems to be to export to something you can open in Excel, then extract/modify the data there.
However, I'm not sure how to go back from there.
Any experience? There must be a converter out there somewhere, but I've struggled to find something that works with my Mac (OS 10.9).
To match up a Garmin GPS file to a video file I wanted to edit the data. The only way seems to be to export to something you can open in Excel, then extract/modify the data there.
However, I'm not sure how to go back from there.
Any experience? There must be a converter out there somewhere, but I've struggled to find something that works with my Mac (OS 10.9).
#2
Thread Killer
Join Date: Aug 2008
Location: Ann Arbor, MI
Posts: 12,373
Bikes: 15 Kinesis Racelight 4S, 76 Motebecane Gran Jubilée, 17 Dedacciai Gladiatore2, 12 Breezer Venturi, 09 Dahon Mariner, 12 Mercier Nano, 95 DeKerf Team SL, 19 Tern Rally, 21 Breezer Doppler Cafe+, 19 T-Lab X3, 91 Serotta CII
Mentioned: 30 Post(s)
Tagged: 0 Thread(s)
Quoted: 3078 Post(s)
Liked 1,631 Times
in
1,005 Posts
You could download Cycleops' free Poweragent software and do it there.
It certainly can import and export in any of .csv, .gpx, and .tcx formats, but I was trying to remember if you could edit any field data from within the app, or if you still need to export for use in a spreadsheet app like Pages or Excel; I'm not sure.
It certainly can import and export in any of .csv, .gpx, and .tcx formats, but I was trying to remember if you could edit any field data from within the app, or if you still need to export for use in a spreadsheet app like Pages or Excel; I'm not sure.
#3
don't try this at home.
Join Date: Jan 2006
Location: N. KY
Posts: 5,918
Mentioned: 10 Post(s)
Tagged: 0 Thread(s)
Quoted: 964 Post(s)
Liked 496 Times
in
343 Posts
EDIT-- This is for Windows. I don't have any ideas for an equivalent Mac program. Since the Garmin file has no line feeds, it's messy to edit with a text editor. But if you know the starting and ending times you want to keep (adjusted for Universal time's hour offset), you could just locate and delete a group of Trackpoints.
~~~~~
A .csv (comma separated values) likely doesn't keep the same structure as a gpx or tcx file, so it's difficult to convert back.
My Garmin 705 occasionally mangles a small part of my .tcx recording, but that's enough to keep the whole ride from loading.
I've used the free Firstobject XML editor to delete the bad entry. (Save a copy of the original file first!)
Garmin tcx files don't have any line feeds, so the file looks like one extremely long line of data. In the XML editor click Tools-->Indent to display it in a readable format. Then in the left hand column, expand the Activities-->Lap--->Track sub headings to see each individual trackpoint. Doubleclick a trackpoint to highlight it. The time is in Universal/Greenwich time, and the distance from the start is in meters.
You can easily delete data by selecting, in the right side detail view, a starting "<Trackpoint>" and deleting through an ending </Trackpoint>. Use the Delete key on the keyboard.
I use 1-second recording, so there's a Trackpoint every second.
~~~~~
A .csv (comma separated values) likely doesn't keep the same structure as a gpx or tcx file, so it's difficult to convert back.
My Garmin 705 occasionally mangles a small part of my .tcx recording, but that's enough to keep the whole ride from loading.
I've used the free Firstobject XML editor to delete the bad entry. (Save a copy of the original file first!)
Garmin tcx files don't have any line feeds, so the file looks like one extremely long line of data. In the XML editor click Tools-->Indent to display it in a readable format. Then in the left hand column, expand the Activities-->Lap--->Track sub headings to see each individual trackpoint. Doubleclick a trackpoint to highlight it. The time is in Universal/Greenwich time, and the distance from the start is in meters.
You can easily delete data by selecting, in the right side detail view, a starting "<Trackpoint>" and deleting through an ending </Trackpoint>. Use the Delete key on the keyboard.
I use 1-second recording, so there's a Trackpoint every second.
Last edited by rm -rf; 12-01-13 at 09:39 AM.
#4
Senior Member
Golden Cheetah, may do it? and it's free.
https://goldencheetah.org
UPDATE Yeah just checked I'm on Mac OSX 10.9 too.
You can import data file from most devices, edit data within EDIT tab and then Activity>Export to .CSV, .TSX OR upload to Strava, Training Peaks, or RidewithGPS and I think you can export .GPX from there.
https://goldencheetah.org
UPDATE Yeah just checked I'm on Mac OSX 10.9 too.
You can import data file from most devices, edit data within EDIT tab and then Activity>Export to .CSV, .TSX OR upload to Strava, Training Peaks, or RidewithGPS and I think you can export .GPX from there.
Last edited by MagicHour; 12-01-13 at 11:01 AM.
#5
Senior Member
Join Date: Feb 2006
Posts: 524
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 34 Post(s)
Likes: 0
Liked 17 Times
in
13 Posts
If you're starting with a GPX file, Garmin's free BaseCamp app can import it and open the "track" in a window that displays it as a scrolling list which lets you add and delete lines to edit the track. On Mac, you could also try the free app, Adze, which opens GPX files on a Google Map background. You can visually select and remove segments of any displayed track.
#7
Banned.
Join Date: Sep 2012
Posts: 61
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 43 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
#9
Senior Member
Join Date: Feb 2009
Posts: 911
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 3 Post(s)
Likes: 0
Liked 2 Times
in
2 Posts
What's your original file type?
Gpx files can be edited in simple text editors.
If you are stuck on starting with csv, the website GPS Visualizer might be able to help.
They have a convert to gpx function.
If that doesn't work, try their gpsbabel function which has even more options.
Gpx files can be edited in simple text editors.
If you are stuck on starting with csv, the website GPS Visualizer might be able to help.
They have a convert to gpx function.
If that doesn't work, try their gpsbabel function which has even more options.
#10
Thread Killer
Join Date: Aug 2008
Location: Ann Arbor, MI
Posts: 12,373
Bikes: 15 Kinesis Racelight 4S, 76 Motebecane Gran Jubilée, 17 Dedacciai Gladiatore2, 12 Breezer Venturi, 09 Dahon Mariner, 12 Mercier Nano, 95 DeKerf Team SL, 19 Tern Rally, 21 Breezer Doppler Cafe+, 19 T-Lab X3, 91 Serotta CII
Mentioned: 30 Post(s)
Tagged: 0 Thread(s)
Quoted: 3078 Post(s)
Liked 1,631 Times
in
1,005 Posts
Golden Cheetah, may do it? and it's free.
https://goldencheetah.org
UPDATE Yeah just checked I'm on Mac OSX 10.9 too.
You can import data file from most devices, edit data within EDIT tab and then Activity>Export to .CSV, .TSX OR upload to Strava, Training Peaks, or RidewithGPS and I think you can export .GPX from there.
https://goldencheetah.org
UPDATE Yeah just checked I'm on Mac OSX 10.9 too.
You can import data file from most devices, edit data within EDIT tab and then Activity>Export to .CSV, .TSX OR upload to Strava, Training Peaks, or RidewithGPS and I think you can export .GPX from there.
I had been using PowerAgent myself, but just updated to OS X 11.1 El Capitan on Mac, and Poweragent won't run (7.8.28 anyway, the current offering from Powertap site, though I swear there was 7.10 something going around awhile back; dunno what happened there), so I went looking for a solution.
Golden Cheetah 3.2.0 will run on OS X 11 and will convert .csv to .tcx (among others) for uploading to Strava, GarminConnect (or whatever you want to do with it).
Hope that helps someone!
#11
aka Tom Reingold
Join Date: Jan 2009
Location: New York, NY, and High Falls, NY, USA
Posts: 40,691
Bikes: 1962 Rudge Sports, 1971 Raleigh Super Course, 1971 Raleigh Pro Track, 1974 Raleigh International, 1975 Viscount Fixie, 1982 McLean, 1996 Lemond (Ti), 2002 Burley Zydeco tandem
Mentioned: 510 Post(s)
Tagged: 0 Thread(s)
Quoted: 7287 Post(s)
Liked 2,362 Times
in
1,381 Posts
There's a web service that does this. I don't remember if I've tried it.
https://www.gps-data-team.com/convert/
https://www.gps-data-team.com/convert/
__________________
Tom Reingold, tom@noglider.com
New York City and High Falls, NY
Blogs: The Experienced Cyclist; noglider's ride blog
“When man invented the bicycle he reached the peak of his attainments.” — Elizabeth West, US author
Please email me rather than PM'ing me. Thanks.
Tom Reingold, tom@noglider.com
New York City and High Falls, NY
Blogs: The Experienced Cyclist; noglider's ride blog
“When man invented the bicycle he reached the peak of his attainments.” — Elizabeth West, US author
Please email me rather than PM'ing me. Thanks.
Thread
Thread Starter
Forum
Replies
Last Post
cj19
Electronics, Lighting, & Gadgets
12
07-06-17 01:09 PM
CraigB
Clydesdales/Athenas (200+ lb / 91+ kg)
23
04-02-12 06:13 PM