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

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

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  
JonnyHK 
Senior Member
Thread Starter
 
JonnyHK's Avatar
 
Join Date: Sep 2008
Location: London
Posts: 2,366

Bikes: Baum Romano, Brompton S2, Homemade Bamboo!

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 259 Post(s)
Liked 1 Time in 1 Post
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  
chaadster
Thread Killer
 
Join Date: Aug 2008
Location: Ann Arbor, MI
Posts: 9,321

Bikes: '15 Kinesis Racelight 4S, '76 Motebecane Gran Jubilée, '17 Dedacciai Gladiatore2, '12 Breezer Venturi, '09 Dahon Mariner, '05 Novara Big Buzz, '12 Mercier Nano, '95 DeKerf Team

Mentioned: 19 Post(s)
Tagged: 0 Thread(s)
Quoted: 1026 Post(s)
Likes: 0
Liked 0 Times in 0 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  
rm -rf
don't try this at home.
 
rm -rf's Avatar
 
Join Date: Jan 2006
Location: N. KY
Posts: 5,086
Mentioned: 10 Post(s)
Tagged: 0 Thread(s)
Quoted: 624 Post(s)
Liked 14 Times in 13 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  
MagicHour
Senior Member
 
MagicHour's Avatar
 
Join Date: Aug 2013
Location: NYC
Posts: 831
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 74 Post(s)
Liked 1 Time in 1 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.

Last edited by MagicHour; 12-01-13 at 11:01 AM.
MagicHour is offline  
Old 12-01-13, 02:29 PM
  #5  
dorkypants
Senior Member
 
dorkypants's Avatar
 
Join Date: Feb 2006
Posts: 489
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 23 Post(s)
Likes: 0
Liked 1 Time in 1 Post
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  
JonnyHK 
Senior Member
Thread Starter
 
JonnyHK's Avatar
 
Join Date: Sep 2008
Location: London
Posts: 2,366

Bikes: Baum Romano, Brompton S2, Homemade Bamboo!

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 259 Post(s)
Liked 1 Time in 1 Post
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  
67stang
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 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  
Old 10-27-15, 09:29 PM
  #8  
JonnyHK 
Senior Member
Thread Starter
 
JonnyHK's Avatar
 
Join Date: Sep 2008
Location: London
Posts: 2,366

Bikes: Baum Romano, Brompton S2, Homemade Bamboo!

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 259 Post(s)
Liked 1 Time in 1 Post
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  
Old 10-28-15, 12:54 AM
  #9  
Rumpled
Senior Member
 
Join Date: Feb 2009
Posts: 903
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 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  
chaadster
Thread Killer
 
Join Date: Aug 2008
Location: Ann Arbor, MI
Posts: 9,321

Bikes: '15 Kinesis Racelight 4S, '76 Motebecane Gran Jubilée, '17 Dedacciai Gladiatore2, '12 Breezer Venturi, '09 Dahon Mariner, '05 Novara Big Buzz, '12 Mercier Nano, '95 DeKerf Team

Mentioned: 19 Post(s)
Tagged: 0 Thread(s)
Quoted: 1026 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
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  
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
Posts: 37,089

Bikes: 1962 Rudge Sports, 1971 Raleigh Super Course, 1971 Raleigh Pro Track, 1973 Raleigh Twenty, 1974 Raleigh International, 1975 Viscount Fixie, 1982 McLean, 1996 Lemond (Ti), 2002 Burley Zydeco tandem

Mentioned: 420 Post(s)
Tagged: 0 Thread(s)
Quoted: 5393 Post(s)
Liked 94 Times in 71 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
iab
Classic & Vintage
15
11-01-16 10:47 AM
tombailey
Road Cycling
3
03-29-09 12:46 PM
kudude
Road Cycling
8
05-12-08 02:22 PM
Metro
Bicycle Mechanics
0
04-21-05 12:55 PM

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


Thread Tools
Search this Thread

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

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