vasupuc.blogg.se - Garmin connect export to strava

#Garmin connect export to strava how to
#Garmin connect export to strava zip file
#Garmin connect export to strava update

From there, you can download the result, or if you're a Microsoft person, you can also click JSON to Excel. Paste the JSON text you copied into the text box on their page and click "Convert JSON to CSV". Open a new tab (don't leave the Strava tab, 'cause we have more work to do!) A quick Google search for "convert JSON to CSV" gives me a result of from, which is exactly what I need. The data's in what's called JSON format, and we need to get it into another format so we can import it into the spreadsheet of our choice. Step 1: The Browser ConsoleĬlick anywhere in that raw data (that pretty red and blue text), hit Ctrl-A to select all of it, and then Ctrl-C to copy it to your clipboard.

All API-based plugins or add-ons that I tried while researching this post did not work for my use case they either didn't work at all, didn't have all the columns I needed, or only exported a certain number of workouts. True, Strava provides a developer API, but that's a bit heavy-handed for a single query. It doesn't supply a single spreadsheet view with oodles of data, which is what I was after.

#Garmin connect export to strava zip file

However, that downloads only a zip file of your owrkouts in GPX format. True! Go to profile settings and you'll see "Download your data" in the right column. Note: An astute reader pointed out that Strava already had an export feature. It's a different use case than above, but very useful if you're trying to get per-workout data out to transfer to another platform or analyze further. No arbitrary wait time between downloads and some control over the saved filename, too.

Copy new window's content into to convert to CSV.Īlso, if you're after GPX files from multiple activities, Alistair Adams sent me some code that they've used to bulk-download GPX files from Strava.

Paste the code into the browser console and hit Enter.

Copy the code on this page and set maxPage and activityType at the top.

In Firefox, you can press Ctrl+Shift+I or F12 (Windows, Linux) or Cmd+Opt+I (Mac) In Chrome, you can press Command+Option+J (Mac) or Control+Shift+J (Windows, Linux, Chrome OS).

Open your browser's developer tools and navigate to Console window.

This is by far the easiest and quickest approach. Tibor commented on my original post a while ago, and I had reason to use their code when my wife and daughter summarized their 200-day hike streak.

#Garmin connect export to strava update

Grab a cold one and get your browser console ready, 'cause we're going to go on a Strava data expedition! TL DR: An Update There are a few steps involved, but it's not THAT hard.

#Garmin connect export to strava how to

The resulting poster was just as I'd hoped for! It turns out I'm also a technology geek, so I figured out how to export Strava data into a spreadsheet so I could get the numbers I needed for my poster.

I needed a spreadsheet I could sort, filter and enrich. Going through workout-by-workout just wouldn't cut it.