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
What is a running cadence and how to track it
Running cadence is a number of steps that you will do in one minute. It is common to recommend to keep it about 180. Even that this value can be applied in a vacuum only, it is good to keep your cadence in higher levels. More steps in a minute mean that you are running more effectively.
Show more →
Why use speed sensor for biking
The simplest way how to track your speed is by GPS. It works with all vehicles even with human legs. Unfortunately, it doesn’t give always precise results. Sharp curves are not sharp and what if get inside a building or to the tunnel? For accurate results, you need a speed sensor.
Show more →