Go Back  Bike Forums > Bike Forums > General Cycling Discussion
Reload this Page >

Edit GPX files in Excel for import to Strava

Search
Notices
General Cycling Discussion Have a cycling related question or comment that doesn't fit in one of the other specialty forums? Drop on in and post in here! When possible, please select the forum above that most fits your post!

Edit GPX files in Excel for import to Strava

Thread Tools
 
Search this Thread
 
Old 07-08-18 | 09:05 AM
  #1  
bluehills3149's Avatar
Thread Starter
Full Member
10 Anniversary
 
Joined: Jun 2014
Posts: 457
Likes: 91
From: Melbourne, Australia

Bikes: depends what week it is..

Edit GPX files in Excel for import to Strava

I found I can import a gpx file as an xml file into Excel (I use Excel 2016) and the data is all in neat columns - Speed, timestamp, cadence etc. So now if there is bad data I can edit it -example my HRM picks up stray data showing bpm above 230.
My question is how do I re-save the file so I can import it back to Strava as a gpx file? Excel says I can't save as a xml file. Is there some plugin I need install?

bluehills3149 is offline  
Reply
Old 07-08-18 | 03:37 PM
  #2  
Junior Member
 
Joined: Nov 2009
Posts: 13
Likes: 2
From: United Kingdom
Originally Posted by bluehills3149
I found I can import a gpx file as an xml file into Excel (I use Excel 2016) and the data is all in neat columns - Speed, timestamp, cadence etc. So now if there is bad data I can edit it -example my HRM picks up stray data showing bpm above 230.
My question is how do I re-save the file so I can import it back to Strava as a gpx file? Excel says I can't save as a xml file. Is there some plugin I need install?
You can certainly edit them in a text editor. I often export the previous day's commute and do a find and replace on the date if I forget to record a ride. It won't be tabulated as neatly as in Excel but if you use something like Notepad++ that has an understanding of XML syntax you may find it ok
jamesdelap is offline  
Reply
Old 07-09-18 | 07:14 PM
  #3  
bluehills3149's Avatar
Thread Starter
Full Member
10 Anniversary
 
Joined: Jun 2014
Posts: 457
Likes: 91
From: Melbourne, Australia

Bikes: depends what week it is..

Yes- I know the notepad trick. Trouble is my HRM data has a couple hundred bogus points I want to edit. In both notepad and word I cannot use find/replace probably because the data has too many symbols and Word thinks symbols have meanings in find/replace - here is a typical entry in the gpx file for HR: <gpxtpx:hr>116</gpxtpx:hr>
bluehills3149 is offline  
Reply
Old 07-09-18 | 08:35 PM
  #4  
deapee's Avatar
Ride On!
 
Joined: Apr 2016
Posts: 970
Likes: 3

Bikes: Allez DSW SL Sprint | Fuji Cross

You could find and replace in notepad++ on “hr>230” - “hr>170”. And just do that X number of times for like 230, 229, 228, etc...

This is funny because I actually do stuff like this for work. Times 80,000 (sometimes more lol) - I’d write a script to do it in most cases, but no point with such a small amount of data as you can do this pretty quickly with find and replace.
deapee is offline  
Reply
Old 07-09-18 | 09:11 PM
  #5  
bluehills3149's Avatar
Thread Starter
Full Member
10 Anniversary
 
Joined: Jun 2014
Posts: 457
Likes: 91
From: Melbourne, Australia

Bikes: depends what week it is..

Thanks deapee - notepad++ will do it under search>replace
Highlight all the text which has the erroneous data. Tick "In Selection" and "regular Expression"
find: hr>… (each dot is represents a single number)
Replace with whatever figure you want (eg hr>120)
Hit "replace all" and note the number of replacements made.
bluehills3149 is offline  
Reply
Old 07-09-18 | 09:41 PM
  #6  
TrojanHorse's Avatar
SuperGimp
 
Joined: Mar 2010
Posts: 13,346
Likes: 65
From: Whittier, CA

Bikes: Specialized Roubaix

there's a program out there called Free XML Editor (FoxE)... give it a whirl. I use it all the time to identify bad data in XML files (by bad, I mean non-compliant, won't display etc, not necessarily an unwanted number)

Free XML editor download
TrojanHorse is offline  
Reply
Old 07-10-18 | 08:34 AM
  #7  
Member
 
Joined: Jun 2018
Posts: 44
Likes: 1
From: N Nevada

Bikes: '18 Giant Defy,'18 Trek FX3, Early '90s Giant Iguana

Have you tried exporting data as CSV (comma separated values)? Then rename to GPX. I have not looked in a bit but I think that's how excel saw your data. They are just pure text files.
bgdoyle is offline  
Reply
Old 07-10-18 | 11:10 AM
  #8  
Member
 
Joined: Jun 2018
Posts: 44
Likes: 1
From: N Nevada

Bikes: '18 Giant Defy,'18 Trek FX3, Early '90s Giant Iguana

Well, I guess it is in a kind of .xml. I use GPX track editor to clean up and divide tracks. Never tried changing data but you can delete sections and export selections. I normally use it for rock hounding trips and offroading.
Wife was after me before to "get going if you are going for a ride before it gets any hotter". Did 12 miles.
bgdoyle is offline  
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
tricky
Electronics, Lighting, & Gadgets
5
01-17-19 02:34 PM
cthenn
Road Cycling
4
08-22-17 07:09 AM
YogaKat
General Cycling Discussion
6
11-02-15 09:40 AM
cmark84
Electronics, Lighting, & Gadgets
0
04-19-14 09:57 AM
Myosmith
Training & Nutrition
8
12-25-13 08:51 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
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



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

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