Ability to generate Training Reports from your Strava data

Having just worked my way through my 2013 training data to find out my weekly, monthly and total training amounts, it occurred to me that it would be handy to be able to generate these as reports automagically within Strava.

  • Weekly, monthly, annual and all time reports for any week/month/year.
  • Report describes total mileage, training time, number of activites, HR maximum/average etc. - all the usual information.
  • Reports can be activity type specific (one report for runs, one for rides) or aggregated.
  • Users configure which report types they want generated automagically (and optionally emailed to them) based on period and activity type.
  • Custom reports (specific date ranges, previous weeks/months/years etc,.) can be created ad-hoc if I wanted.

 

After all, we're using a site like Strava because we crave data and comparative competition - more data is exactly what we always want...

 

177

Comments

126 comments
  • Official comment

    Hi Folks, 

    Thanks for adding your comments. I understand the need for having all your data easily accessible and downloadable. I'll pass your thoughts along. 

    One thing to remember: just because something's popular doesn't mean it'll be implemented. Our forums are just one component of our decision-making process. While a ton of ideas are genuinely valuable, we need to be selective and balance our priorities.
     
    Thanks for understanding!
    Comment actions Permalink
  • Comma delimted (CSV) would be great! Another reason to renew Premium membership! The only reason I'm on this page is because I was trying to find out how to download the data! It's an intuitive request. Thanks!

    18
    Comment actions Permalink
  • A simple CSV file dump to Excel would be great!

    18
    Comment actions Permalink
  • Excel is the analytical tool of choice.   You need a simple export with route, date, distance, and time.

    17
    Comment actions Permalink
  • Hi,

    This is something I've been working on as a side project recently and, although it needs a fair bit of polishing around the edges, it gets the job done :)

    The process is a) select the fields you're interested in, b) select the activity types to include and c) select the date range. All through a form like this:

           

    https://gnar.jakelodge.co.uk/register 

    15
    Comment actions Permalink
  • Exporting to Excel should be a one button push. Crazy to be unable to do this...............

    14
    Comment actions Permalink
  • I'd like to export my activities to csv or excel too!
    12
    Comment actions Permalink
  • I vote for an 'Export to MS Excel' function. It would seem an easy addition to the program. If it were only available to Premium users then I would consider upgrading.

    9
    Comment actions Permalink
  • simple csv export would be great. all I want is date, distance, time and I can calculate the rest myself. I'm wanting to trend my average run speed per week over the last few years, really interested to see how this changes.

    8
    Comment actions Permalink
  • Yes - would love some similar reports to Garmin Connect. All the data is here, just need different ways to show it. Otherwise, need a raw dump to Excel

    7
    Comment actions Permalink
  • Include me in on the request for CSV.  Just give us all the data and we can sort as needed.  I really like Strava.  I've gotten several friends to sign on and they are avid users now and this would put you way over the edge with your competition

    7
    Comment actions Permalink
  • Agree with above - need to have an export all function to Excel. Whether its csv comma delimited or not, I don't really care. Just want to be able to manipulate the data a bit myself

    7
    Comment actions Permalink
  • I agree...export data to excel would be awesome!

    6
    Comment actions Permalink
  • Well I'm new to strava and am rather surprised that I can't export to csv. I log all my training manually in excel & it would be si much easier to export directly
    4
    Comment actions Permalink
  • Strava! Export to csv...are you ever going to listen to your user base and add this capability?

    -- New to Strava Premium and highly dissapointed with the lack of reporting features.

    4
    Comment actions Permalink
  • So has there been any movement on the export to excel idea or has it fallen on deaf ears? Seeing as how it has been asked about in 2014 it doesn't appear now makes me wonder. Let us export the data to excel so we can improve out KOM's and daily rides!! I look forward to a prompt reply. I am a Premium member but may not be if this isn't addressed.

    3
    Comment actions Permalink
  • Allowing download of stats to a .csv file would be the One easy thing that would please most users who complain about lack of reporting. Why delay?

    3
    Comment actions Permalink
  • csv export please please please

    3
    Comment actions Permalink
  • Hi folks, I had a similar idea and wrote a Strava to Excel exporter, which can be found here: https://entorb.net/strava/

    Features:

    • Download complete activity list and converts it to Excel
    • Bulk modify of activities (Name, Description, Commute...)
    • Find most frequent start/end locations from the activites, store a name to the location to allow for nice filtering in Excel. (e.g. search for activities starting home, ending at work)
    • High level of security and privacy

     

    3
    Comment actions Permalink
  • I was really surprised when I upgraded to Premium that, from what I can find, there is no actual report available to monitor progress? This was really disappointing, Any updates on when this will be offered?

    2
    Comment actions Permalink
  • Agree with the comments already posted. This should be a pretty straightforward request and not clear why it's not already available. The bulk export to separate GPX files is pretty useless.

    2
    Comment actions Permalink
  • I'll add my voice to this. I ride three bikes (at least) for three different purposes. Right now, I only see PRs, etc. in the aggregate. It would be useful--no, it's really necessary--to be able to run my own reports from .CSV data. Then, I could filter for a specific bicycle over a specific date range. If Strava can provide GPX/TCX data, it can certainly provide this. (Also a Premium member and I think that would be an appropriate advantage for Premium members--download of data.)

    2
    Comment actions Permalink
  • csv export needed... especially for "description" field where I track injuries and recovery.

    Vital feature here.

    Yes Garmin connect does export... but without "description" field... which is the reason why I switched to Strava 2 years ago. I'm kinda fed up waiting.

    It would be reason enough to switch to premium if available with premium

    2
    Comment actions Permalink
  • Thanks for all the great comments!

    I'm making changes quite often at the moment so lots of the small issues should get ironed out soon hopefully.

    speed is meters/second. Just added pace (min/mile & min/km) and mph / kph fields, along with a couple of others. 

    Strava imposes a limit on the number of activities that can be returned in one go, and limits the requests per unit time. So, at the moment the rows are limited to 40 activities.

    2
    Comment actions Permalink
  • Hi @DavidSchorow, @TomPeregrine

    I haven't been able to conduct any work on this for one reason or another since the summer, so it's still pretty clunky. Nonetheless, I've updated the post above with some new codes.

    Cheers

     

    ps. Sorry for the long delay David, I have no excuse, but my mailbox is a mess..

    pps. Any feedback welcome on here or anonymously here! https://goo.gl/forms/qkg3V58gLaikBuvW2

     

     

    2
    Comment actions Permalink
  • @ Al G.

    Thanks for taking a look!  I'll have to investigate the issue later this week. The expected behavior is that it pulls your entire history.  If you know a little Ruby, you're welcome to glance at the relevant code here. (Offhand I don't know why this wouldn't be capturing other years unless something with Strava's  API or the wrapper I used [already] changed.)

    Do also note that there's another issue involving the actual mailing of the CSV.  Gmail occasionally blocks the server from logging in, so I'll need to fix that too.  It was admittedly hacky. 

    2
    Comment actions Permalink
  • Has anyone found a product that would do this????  I'm on premium this year & this is kinda deal breaker for me.  If you try and printout your activities, each set of 10 activities on each page turns out to be about 5 pages of printout that definitely is not parsed correctly.  It is a mess.  I need this feature or I'll go back to my excel spreadsheet or ??????

    Please post!

    1
    Comment actions Permalink
  • Export to Excel = Excel-lent idea (Sorry. No. I never wanted to be a standup comic!) BTW: Love the latest update, no more Wahoo running concurrently.

    1
    Comment actions Permalink
  • Please add a csv export function, I need to get more specific data analysys.

    Thx!

    1
    Comment actions Permalink
  • "I can do most of this at Garmin Connect but would rather use Strava"

    "Yes - would love some similar reports to Garmin Connect. All the data is here, just need different ways to show it. "

    "Exporting to Excel should be a one button push. Crazy to be unable to do this..............."

     

    Are you listening, Strava?

    1
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post