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
Carpatia Divide 2019, day #3 – When I was crossing endless meadows
I was awake long before the alarm clock. But to have your eyes open is one thing and getting out of the sleeping bag is another. It took me half an hour of convincing to get the job done. It wasn’t easy to pack all my things, including the rescue blanket which changed from a small square to a huge piece of trash. The cold helped me with the speed.
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 →