Update calendar with Excel file

Hi, I am slowly making my way through all the posts in the forum and the features on the site. I am more and more amazed each day, this is superb!
Not sure if it has been asked yet, but would it be possible to edit the calendar with an Excel file?

I use Trainerday.com to create my workouts and training calendar. This then spits out a .xls file

I then manually input this info into the interval.icu calendar. How about being able to upload a file in the correct format that automatically updates the calendar?

I was wondering when someone was going to ask for Excel upload for plans. Can you please email me (david@intervals.icu) a sample xls so I can have a look? Tx.

Also I see TrainerDay has an API. I am going to ask for access as that might be easier.

Do they have .ics calendar export? That would probably work already.

1 Like

Don’t worry about sending me a file. I got one.

I haven’t seen the .ics export.
I was thinking we wouldn’t need the full workout imported, just date, name and load.

Although a workout creator would be an awesome stretch goal!

+1 to API integration with Trainer Day, at least short of having a similar workout builder that also includes the W’ feature. Ideally, you would have both workout and training plan calendar sync. For the former, just add all the Trainer Day workouts in my library to the Intervals.icu library, including updating any modified workouts? For the latter, something similar but into the calendar, obviously. This plus Strava + Training Peaks free accounts would make for a pretty good system.

Create workout in Trainer Day  -> send to Training Peaks (I need this for sync to Wahoo)
                              |-> add to Intervals.icu library -> add to Intervals.icu Calendar (would be great if this also sync'ed to TrainingPeaks so I could skip the above step) -> ride and upload to Strava -> sync ride data to Intervals.icu for analysis
1 Like

I will do calendar upload from CSV file soon.

If you have a plan in Training Peaks then you can add that calendar to Intervals.icu (“Options” on the calendar page and then “Add calendar”).

2 Likes

Hi David,

I’ve recently switched from syncing a TrainerRoad calendar (successfully) to syncing a TrainingPeaks calendar. I can’t seem to get my whole training plan (18 weeks) to sync up from TrainingPeaks. Do you know how I can resolve this issue?

  • Kevin

Hmm. The ics download from TP is only returning stuff until the end of July. I don’t know if it is possible to get TP to go further into the future.

DTSTART;VALUE=DATE:20200713
DTSTART;VALUE=DATE:20200713
DTSTART;VALUE=DATE:20200713
DTSTART;VALUE=DATE:20200714
DTSTART:20200714T190131
DTSTART:20200714T192918
DTSTART:20200715T194047
DTSTART:20200716T064025
DTSTART;VALUE=DATE:20200717
DTSTART;VALUE=DATE:20200718
DTSTART;VALUE=DATE:20200719
DTSTART;VALUE=DATE:20200720
DTSTART;VALUE=DATE:20200720
DTSTART;VALUE=DATE:20200721
DTSTART;VALUE=DATE:20200722
DTSTART;VALUE=DATE:20200723
DTSTART;VALUE=DATE:20200724
DTSTART;VALUE=DATE:20200725
DTSTART;VALUE=DATE:20200726
DTSTART;VALUE=DATE:20200727
DTSTART;VALUE=DATE:20200727
DTSTART;VALUE=DATE:20200728
DTSTART;VALUE=DATE:20200729
DTSTART;VALUE=DATE:20200730