How to export Endomondo workouts to Excel?
Endomondo is a good fitness application but is have some downsides. It is not easy to export your data. I prepared simple guide how to get your basic workout data to excel file.
You can create miracles with Excel and I know that Endomondo is no excellent at workout analytics, Especially when you don’t have a premium version. Thanks to this export you will get basic data about distance, duration, speed and average heart rate.
The are many ways how to export your data and I tried to find the easiest, without special tools and the fastest.
How to do it
- Login to Endomondo.
- Open following URL address in the same browser: https://www.endomondo.com/rest/session You will see some data mess. It is called JSON. At the beginning, you will find something like: “id”:5635433. You will need this number, note it.
- Now open in the browser: https://www.endomondo.com/rest/v1/users/5635433/workouts/history?limit=500&expand=workout Just replace 5635433 by the number from the previous step. You will see another data mess that contains you 500 last workouts. Copy it all.
- Now open website http://www.convertcsv.com/json-to-csv.htm. In “Step 1” insert to “option 3” data from the previous step. In “Step 3” click on button “JSON to Excel”. Now you have your Endomondo workouts in excel file.
What this data means
There is a lot of columns in export. I will try to explain some of them.
- sport: Activity type number. 0 is running, 1, 2 a 3 is biking. All activity types you will find here: https://github.com/fabulator/endomondo-workouts/blob/master/lib/Fabulator/Endomondo/WorkoutType.php
- local_start_time: Start of workout.
- distance: Distance in kilometres.
- duration: Duration in minutes.
- speed_avg: Avearge speed in kilometres per hour.
- ascent: Ascent in metres.
- descent: Descent in metres.
- heart_rate_avg: Avearge heart rate
Race 1000 Miles Adventure 2015, day #1 – How it all started
1000 Miles Adventure is a 1600 kilometres long race for bikes, feet or kickbikes through Slovak and Czech mountains. Everyone is on their own – you have to carry your own food and drinks, find a place to rest and sleep. Racers have to follow a GPS path and have to hand all tracked data to the organisers at the end of the race, so they can check that they didn’t cheat. And this is my story of how I struggled on the road and faced a lot of challenges and dangers.
Show more →
Race 1000 Miles Adventure 2015, day #2 – How I was afraid to go through the tunnel
The next day was much harder. It was a little more hilly, the terrain was rougher and the temperature was above forty degrees. I made 120 kilometres in spite of these unpleasant conditions. But at the end of the day, I was nearly dead.
Show more →