Go Back  Bike Forums > Bike Forums > Electronics, Lighting, & Gadgets
Reload this Page >

How to convert .csv to .gpx (or .tcx) file on a Mac

Notices
Electronics, Lighting, & Gadgets HRM, GPS, MP3, HID. Whether it's got an acronym or not, here's where you'll find discussions on all sorts of tools, toys and gadgets.

How to convert .csv to .gpx (or .tcx) file on a Mac

Old 12-01-13, 07:16 AM
  #1  
Senior Member
Thread Starter
 
JonnyHK's Avatar
 
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).
JonnyHK is offline  
Old 12-01-13, 08:25 AM
  #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.
chaadster is offline  
Old 12-01-13, 09:28 AM
  #3  
don't try this at home.
 
rm -rf's Avatar
 
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.


Last edited by rm -rf; 12-01-13 at 09:39 AM.
rm -rf is offline  
Old 12-01-13, 10:54 AM
  #4  
Senior Member
 
MagicHour's Avatar
 
Join Date: Aug 2013
Location: NYC
Posts: 877
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 85 Post(s)
Liked 12 Times in 10 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.

Last edited by MagicHour; 12-01-13 at 11:01 AM.
MagicHour is offline  
Old 12-01-13, 02:29 PM
  #5  
Senior Member
 
dorkypants's Avatar
 
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.
dorkypants is offline  
Old 12-01-13, 07:38 PM
  #6  
Senior Member
Thread Starter
 
JonnyHK's Avatar
 
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
Thank you all.

I'll try a couple of those out and report back...
JonnyHK is offline  
Old 10-27-15, 09:03 PM
  #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
Originally Posted by JonnyHK
Thank you all.

I'll try a couple of those out and report back...
I've been f'ing waiting here for nearly 2 years...are you going to report back?!!
67stang is offline  
Old 10-27-15, 09:29 PM
  #8  
Senior Member
Thread Starter
 
JonnyHK's Avatar
 
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
Originally Posted by 67stang
I've been f'ing waiting here for nearly 2 years...are you going to report back?!!
Didn't work (or I couldn't get it to) and I gave up...
JonnyHK is offline  
Old 10-28-15, 12:54 AM
  #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.
Rumpled is offline  
Old 11-03-15, 07:38 PM
  #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
Originally Posted by MagicHour
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.
I just ran into this problem again myself: have a .csv file (sent to me from coach's Cycleops/Poweragent program) I want to upload to Strava, so need to convert to a friendly format.

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!
chaadster is offline  
Old 11-04-15, 04:52 PM
  #11  
aka Tom Reingold
 
noglider's Avatar
 
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/
__________________
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.
noglider is offline  
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
bgrider
Road Cycling
4
07-17-19 02:43 PM
cj19
Electronics, Lighting, & Gadgets
12
07-06-17 01:09 PM
redtires
Road Cycling
16
08-11-12 07:56 PM
CraigB
Clydesdales/Athenas (200+ lb / 91+ kg)
23
04-02-12 06:13 PM
vandalarchitect
Road Cycling
34
09-27-11 01:24 AM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.