Advertise on Bikeforums.net



User Tag List

Results 1 to 6 of 6
  1. #1
    Senior Member JonnyHK's Avatar
    Join Date
    Sep 2008
    Location
    Hong Kong
    My Bikes
    Baum Romano, Colossi xCr, Lynskey Crosstown
    Posts
    1,976
    Mentioned
    0 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
    4,369
    Mentioned
    14 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
    2,756
    Mentioned
    3 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
    304
    Mentioned
    0 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
    392
    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
    Hong Kong
    My Bikes
    Baum Romano, Colossi xCr, Lynskey Crosstown
    Posts
    1,976
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you all.

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

Posting Permissions

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