Michal Ozogán Smart devices, fitness apps, bikepacking, ultra racing
Michal Ozogán

How to export Endomondo workouts to Excel?

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

  1. Login to Endomondo.
  2. 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.
  3. 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.
  4. 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.


Comments
  1. Chris

    Chris: Thank you, Michal!

    Today your post overcame my growing frustration with Endomondo.

    I have been annoyed for some time that I cannot bulk download what is, after all, MY data. Lately though Endomondo frequently release app updates which I presume they think will make the user experience better. They don’t.

    Every week it seems they eliminate some key feature, or make a simple function more complicated. From reviews I see I am not the only one that feels this.

    So, I am going to cancel my subscription and now, thank to you, I can move my data!

    Best wishes

    1. Michal Ozogán

      Michal Ozogán: You are welcome Chris. I would like to recommend you tapiriik.com, where you can migrate your GPS data to other services like Runkeeper or Strava or export all your tracking data to dropbox.

  2. raffsha

    raffsha: hi, i am trying to scrap a one month running challenge community.
    Did you find how to do that ?

    1. Michal Ozogán

      Michal Ozogán: Sadly, there is no such easy way as with workouts. Challenges on Endomondo cannot be load in JSON format and easily parsed. You can use some HTML scrapper as a plugin for Chrome – http://webscraper.io/

  3. Paul L Mullen

    Paul L Mullen: The pointer to JSON to CSV changed my life… not just for this issue. Thanks.

    1. Michal Ozogán

      Michal Ozogán: You are welcome!

  4. Rune Grønvold

    Rune Grønvold: The heart rate does not show up in the export, or?

    1. Michal Ozogán

      Michal Ozogán: I just checked the URL where you get information about your workouts. I realised that there is missing “expand=workout” so I fixed it. Now you will see average and maximum heart rate in the report.

  5. Dirce Benevides

    Dirce Benevides: Thank you so much, you helped A LOT!!! #fitnessdatafreak #is #real

  6. Rune Grønvold

    Rune Grønvold: Not working for me now 🙁
    Errormessage:

    504 ERROR
    The request could not be satisfied.

    CloudFront attempted to establish a connection with the origin, but either the attempt failed or the origin closed the connection.
    For more information on how to troubleshoot this error, please refer to the CloudFront documentation (https://docs.aws.amazon.com/AmazonCloudFront/latest/DeveloperGuide/http-504-gateway-timeout.html).

    Generated by cloudfront (CloudFront)
    Request ID: lKNPiINy5qn2gFdaOi1onYTmaL5yF0pqQq9mJ0i0GYxFI1rZvV47Og==

    1. Michal Ozogán

      Michal Ozogán: Which url are you trying to open?

      1. Rune
        1. Michal Ozogán

          Michal Ozogán: It seems that 1000 workouts is little too much for Endomondo. Try to change limit from `1000` to `100`. It will fetch your last 100 workouts. To fetch another 100, add offset 100 then 200, … https://www.endomondo.com/rest/v1/users/5635433/workouts/history?limit=100&offset=100&expand=workout

          1. Rune Grønvold

            Rune Grønvold: Hm, them coloumns are different 🙂
            Not easy this…:(

          2. Michal Ozogán

            Michal Ozogán: Different from what? Do you want to get some specific data?

  7. Kobus

    Kobus: Excellent! I appreciate this helpful guide. Considering switching over to MapMyRun due to lack of export options in Endomondo.

  8. ricky

    ricky: how to export challenges data?

  9. Anton

    Anton: Thanks bro. How about export challenge to excel?

  10. Viesturs

    Viesturs: Do You think it is possible to extract GPS data directly from phone (/sdcard/Android/…)?

  11. Lars Sørensen

    Lars Sørensen: Thank you. Export of data from Endomondo with offset, csv-online-crunching and endresult in Excel works like a charm. Did I mention to say thank you? Have a nice day!

  12. Joanna Idczak

    Joanna Idczak: Dear Michal, this is exellence post and recipe!
    Thank you! I was looking for it and for sure I will recommend your site!

Add your comment

 



Follow me

Subscribe to new posts

Follow me
Subscribe to new posts

Instagram