Advertise on Bikeforums.net



User Tag List

Results 1 to 11 of 11
  1. #1
    Senior Member JonnyHK's Avatar
    Join Date
    Sep 2008
    Location
    London
    My Bikes
    Baum Romano, Colossi xCr, Homemade Bamboo!
    Posts
    2,223
    Mentioned
    21 Post(s)
    Tagged
    0 Thread(s)

    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).

  2. #2
    Thread Killer
    Join Date
    Aug 2008
    Location
    Ann Arbor, MI
    Posts
    7,397
    Mentioned
    54 Post(s)
    Tagged
    0 Thread(s)
    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.
    Chaad--'95 DeKerf Team SL, '02 Lemond Buenos Aires, '05 Novara Buzz, '73 Schwinn Collegiate, '06 Mountain Cycle Rumble, '09 Dahon Mariner D7, '12 Mercier Nano, '12 Breezer Venturi

  3. #3
    don't try this at home. rm -rf's Avatar
    Join Date
    Jan 2006
    Location
    N. KY
    Posts
    3,465
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)
    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.

  4. #4
    Senior Member MagicHour's Avatar
    Join Date
    Aug 2013
    Location
    NYC
    Posts
    554
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Golden Cheetah, may do it? and it's free.
    http://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. #5
    Senior Member dorkypants's Avatar
    Join Date
    Feb 2006
    Posts
    422
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  6. #6
    Senior Member JonnyHK's Avatar
    Join Date
    Sep 2008
    Location
    London
    My Bikes
    Baum Romano, Colossi xCr, Homemade Bamboo!
    Posts
    2,223
    Mentioned
    21 Post(s)
    Tagged
    0 Thread(s)
    Thank you all.

    I'll try a couple of those out and report back...

  7. #7
    Junior Member
    Join Date
    Sep 2012
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by JonnyHK View Post
    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?!!

  8. #8
    Senior Member JonnyHK's Avatar
    Join Date
    Sep 2008
    Location
    London
    My Bikes
    Baum Romano, Colossi xCr, Homemade Bamboo!
    Posts
    2,223
    Mentioned
    21 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by 67stang View Post
    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...

  9. #9
    Senior Member
    Join Date
    Feb 2009
    Posts
    904
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    [SIGPIC][/SIGPIC]

    I'm fundraising for Tour de Cure in both Napa and Long Beach

    Help Support me in the Tour de Cure Ship to Shore in Long Beach
    Jimbo's Long Beach Page

    Help Support me in the Tour de Cure in Napa
    Jimbo's Napa Page

  10. #10
    Thread Killer
    Join Date
    Aug 2008
    Location
    Ann Arbor, MI
    Posts
    7,397
    Mentioned
    54 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by MagicHour View Post
    Golden Cheetah, may do it? and it's free.
    http://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!
    Chaad--'95 DeKerf Team SL, '02 Lemond Buenos Aires, '05 Novara Buzz, '73 Schwinn Collegiate, '06 Mountain Cycle Rumble, '09 Dahon Mariner D7, '12 Mercier Nano, '12 Breezer Venturi

  11. #11
    aka Tom Reingold noglider's Avatar
    Join Date
    Jan 2009
    Location
    West Village, New York City
    My Bikes
    too many
    Posts
    26,295
    Mentioned
    340 Post(s)
    Tagged
    2 Thread(s)
    There's a web service that does this. I don't remember if I've tried it.

    https://www.gps-data-team.com/convert/
    Quote Originally Posted by noglider
    Please email me rather than PM'ing me. Thanks.
    Tom Reingold, noglider@pobox.com
    New York City and High Falls, NY
    Blogs: The Experienced Cyclist; noglider's ride blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •