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 #3 – How I was going to use pepper spray for the first time
On the third day I started having problems with my bike. For one moment I even thought about giving up. Fortunately, there was a lot of cycle services in Slovakia.
Show more →
Does have Endomondo bright future?
On March 2012 I used Endomondo for the first time. It is now 6 years. I bought a premium app and then even a premium membership and keep it for several years. Since Endomondo was bought by Under Armour I have the feeling that platform is not evolving anymore. I cancelled my membership and thinking about searching different app.
Show more →