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
Zajímáte se bikepackingové závody a cestování na kolech? Navštivte nový magazín BezPodpory.cz, kde postupně přibívají tipy na vybavení, jeho minimalizaci a řešení problémů, které vás na dlouhých cestách potkají.
Race 1000 Miles Adventure, day #6 – How I threw my bike to a scarp
I planned an easy ride for the sixth day. I didn’t want to look devastated at the first checkpoint. But the track was more complicated than I expected … as always.
Show more →
Race 1000 Miles Adventure, day #8 – How I coudn’t trust my GPS
The eighth day was one of the best in the race. It was nice to have some rest before the second checkpoint. I was told that the Czech part is harder than the Slovak one, but I have to say that the roads there were much easier.
Show more →