Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  


Go Back   > >

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.

User Tag List

Reply
 
Thread Tools Search this Thread
Old 12-01-13, 07:16 AM   #1
JonnyHK 
Senior Member
Thread Starter
 
JonnyHK's Avatar
 
Join Date: Sep 2008
Location: London
Bikes: Baum Romano, Colossi xCr, Homemade Bamboo!
Posts: 2,226
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(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).
JonnyHK is offline   Reply With Quote
Old 12-01-13, 08:25 AM   #2
chaadster
Thread Killer
 
Join Date: Aug 2008
Location: Ann Arbor, MI
Bikes:
Posts: 7,616
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 82 Post(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.
chaadster is offline   Reply With Quote
Old 12-01-13, 09:28 AM   #3
rm -rf
don't try this at home.
 
rm -rf's Avatar
 
Join Date: Jan 2006
Location: N. KY
Bikes:
Posts: 3,618
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 27 Post(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.
rm -rf is online now   Reply With Quote
Old 12-01-13, 10:54 AM   #4
MagicHour
Senior Member
 
MagicHour's Avatar
 
Join Date: Aug 2013
Location: NYC
Bikes:
Posts: 562
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
MagicHour is offline   Reply With Quote
Old 12-01-13, 02:29 PM   #5
dorkypants
Senior Member
 
dorkypants's Avatar
 
Join Date: Feb 2006
Bikes:
Posts: 424
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
dorkypants is offline   Reply With Quote
Old 12-01-13, 07:38 PM   #6
JonnyHK 
Senior Member
Thread Starter
 
JonnyHK's Avatar
 
Join Date: Sep 2008
Location: London
Bikes: Baum Romano, Colossi xCr, Homemade Bamboo!
Posts: 2,226
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Thank you all.

I'll try a couple of those out and report back...
JonnyHK is offline   Reply With Quote
Old 10-27-15, 09:03 PM   #7
67stang
Junior Member
 
Join Date: Sep 2012
Bikes:
Posts: 10
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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?!!
67stang is offline   Reply With Quote
Old 10-27-15, 09:29 PM   #8
JonnyHK 
Senior Member
Thread Starter
 
JonnyHK's Avatar
 
Join Date: Sep 2008
Location: London
Bikes: Baum Romano, Colossi xCr, Homemade Bamboo!
Posts: 2,226
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(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...
JonnyHK is offline   Reply With Quote
Old 10-28-15, 12:54 AM   #9
Rumpled
Senior Member
 
Join Date: Feb 2009
Bikes:
Posts: 904
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
Rumpled is offline   Reply With Quote
Old 11-03-15, 07:38 PM   #10
chaadster
Thread Killer
 
Join Date: Aug 2008
Location: Ann Arbor, MI
Bikes:
Posts: 7,616
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 82 Post(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!
chaadster is offline   Reply With Quote
Old 11-04-15, 04:52 PM   #11
noglider 
aka Tom Reingold
 
noglider's Avatar
 
Join Date: Jan 2009
Location: West Village, New York City
Bikes: too many
Posts: 26,861
Mentioned: 6 Post(s)
Tagged: 0 Thread(s)
Quoted: 84 Post(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/
__________________
Tom Reingold, noglider@pobox.com
New York City and High Falls, NY
Blogs: The Experienced Cyclist; noglider's ride blog

Please email me rather than PM'ing me. Thanks.
noglider is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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



All times are GMT -6. The time now is 01:18 PM.