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

How to export Endomondo workouts to Excel?

How to export Endomondo workouts to Excel?

Published 14.01.2018 Published Tips & Tricks Comments 37

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?

          3. Mikola Ákos

            Mikola Ákos: In some cases the results have different columns and different order of the columns.

  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!

  13. Michal

    Michal: Michal, great job – thanks a lot!

  14. Andre

    Andre: Thankyou Michal, great tip, i like numbers..

  15. Triple-Ko

    Triple-Ko: Please suggest extracting data group challenge by Ranking to Excel

    Thank you

    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/

  16. Talented

    Talented: Hi Michal,

    I have a question about the challenges in ENDOMONDO. Can I export challenges data such as Name, Total Distance in challenges of each person?

  17. Harryjh

    Harryjh: YES. Thank you Michal, you made that very simple.

  18. Michał

    Michał: Hi Michal, thanks a lot for this tutorial. This is something I’ve been thinking about recently and it suits me well!

  19. Frank

    Frank: HI Michael this is great stuff. Works perfektly!

  20. Gilles

    Gilles: Endomondo will be stopped at the end of the year! So thank you for this tool which permit to export all trainings in Excel!

  21. Rainer

    Rainer: Hi. You are my hero!
    Good that I found your article. Endomondo is going to be retired by 31.12.2020 :-(
    With your steps I at least was able to save all my workouts from 2016 to today. Would have been a big loss otherwise.
    Thanks a lot!

    P.S.: I assume this will help lots of other frustrated users during the next weeks.

    Best regards
    Rainer

  22. Markus

    Markus: Hi, I realized it too late. Is there still a possibility to save my runs?
    Best,
    Markus

    1. Michal Ozogán

      Michal Ozogán: You can try to contact them https://support.endomondo.com/hc/en-us/requests/new All data will be deleted on 31st March.

  23. Angelo Verdicchio

    Angelo Verdicchio: Hi Guys,

    I have realized right now that Endomondo is retired and I think that I am too late to ask to endomondo the data.

    Is there someone that he has been able to recover the data after 21 March 2021

Add your comment

 


Don't miss Race 1000 Miles Adventure 2015, day #3 – How I was going to use pepper spray for the first time

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?

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 →


Follow me

Subscribe to new posts