Electronics, Lighting, & Gadgets - How to convert .csv to .gpx (or .tcx) file on a Mac
Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.
12-01-13, 06:16 AM
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).
12-01-13, 07:25 AM
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.
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 (http://www.firstobject.com/dn_editor.htm) 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.
12-01-13, 09:54 AM
Golden Cheetah, may do it? and it's free.
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.
12-01-13, 01:29 PM
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.
12-01-13, 06:38 PM
Thank you all.
I'll try a couple of those out and report back...
Powered by vBulletin® Version 4.1.12 Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.