The following guide will allow you to enter data into a spreadsheet and then use that data to import a Training Plan into the system.
How to create a CSV file in a spreadsheet to use as an import
The first step of the process is to generate a CSV file with the data in the correct format.
After logging into your Training Tilt account, select "Coaching" > "Plans".
When you're taken to the next page, select the Import button on the top right.
Next, click the Download Template button.
This will download a CSV file with the correct columns and one row of sample data. Open this CSV file in a spreadsheet app like Microsoft Excel or Google Sheets.
Using the sample rows as a guide enter all of your own rows. You may have this data stored somewhere already so you may be able to copy and paste the rows. It's important that you only use the template you downloaded for the actual import with the formats specified below otherwise it will fail.
The Title column is the name of the workout, this should be a short name with less than 255 characters.
The WorkoutType column is the type of workout, Swimming, Cycling, Running etc. This field can be taken directly from the "Workout Type" dropdown from inside the system. You can use one of the default workout types or one of the custom ones you have added to Training Tilt yourself.
The WorkoutDescription column is the detail and prescribed workout. This is where you should prescribe the workout.
The Code column can be left blank.
PlannedDuration must be entered in hours as a decimal e.g 1:30 as 1.5.
PlannedDistance must be entered in metric meters. e.g 3000 for 3km. If you need to convert miles to meters you can use this Google search term https://www.google.com/search?q=convert+miles+to+meters
The WorkoutDay column should be left blank
The CoachComments column is optional and this text will be appended to the workout description.
The Variation column is optional and will populate the "Additional Category" field in a workout.
The DisplayUnitOfMeasure column is optional and should only be used if you want the workout to display distance in yards or meters instead of Kilometers or miles. The options for this field are m or yds. Note: regardless of this setting the PlannedDistance column must always be specified in meters.
The WeekNumber is required and represents X week of the plan. So for workouts for week 1 you should enter 1, workouts for week 2 enter 2 etc.
The DayOfWeekNumber is required and represents the day of the week the workout should appear on. Monday is 1, Tuesday is 2, Sunday is 7 etc.
The TimeOfDayInMinutes will determine what time of day the workout will be added to the plan. This number is in total minutes for the day. E.g 6am is 360, 6pm is 1080. You can calculate this by multiplying the hour in the day by 60. e.g 6am is 6 x 60 = 360. 6 pm is 18 x 60 = 1080
Now depending on your spreadsheet software either use the "save as", "download as" or "export" option and save the file as a CSV (comma separated values).
Importing into Training Tilt
Go back to the Import page in Training Tilt and choose the Select Files button
Select the CSV file you created and then click the Upload button.
This may take a while but you'll see when the process is completed. If there are any errors download the result file and send it to us so we can help troubleshoot.
Now go back to "Coaching" > "Plans" and all the Training Plan should be there. You can now edit plan type, level etc as required. The new Training Plan's name will include the file name of the CSV file you used.