All Collections
Importing Data
How to import Workouts from a spreadsheet or TrainingPeaks export
How to import Workouts from a spreadsheet or TrainingPeaks export

How to import workouts from a spreadsheet or TrainingPeaks exports.

Cam Langsford avatar
Written by Cam Langsford
Updated over a week ago

You can import into your workout library from a spreadsheet or a CSV file. You can create that file manually or export some data from a TrainingPeaks athlete account. Each of these steps is outlined but you only need to do one or the other to prepare your import file.

How to manually create a CSV file in a spreadsheet to use as an import

If you are going to import from TrainingPeaks scroll down to the directions for "How to get your workouts from TrainingPeaks".

After logging into your Training Tilt account, select "Coaching" > Library

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 first row 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 otherwise it will fail. 

Column Specifications

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.

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).

If you are ready to do the import you can skip the next TrainingPeaks section and scroll down to the import instructions.

How to get your workouts from TrainingPeaks

This is the tricky bit but in order to export workouts from TrainingPeaks they first need to be applied to a TrainingPeaks athlete's calendar. As a coach it's best to just use a test athlete account or your own account if you have one.

Login as your TrainingPeaks coach account and add your workouts you want exported to the athlete accounts calendar. At this point it's not important how you structure these. A good tip is to just add all the workouts to a single month in the future in any order. e.g add all your workouts to February 2025. On any days, it doesn't matter.

Now login as the athlete account and confirm the workouts have been applied to the calendar. Click settings from the profile menu top right.

Choose the "Export Data" option from the left and then in the "Workout Summary" section set the dates to export from that you applied the workouts to on the calendar. In our example that's 1 Feb 2025 to 28 Feb 2025. Then click the "Export" button for that section.

That will export all those workouts from the selected dates into a zip archive. extract the archive and there will be a .csv file with all the workouts. Make sure you click the link that TP shows you to download it first.

How to import your CSV into Training Tilt.

Go to Training Tilt and select the "Plans - Library" option from the menu.

Then click the "Import" button.

Now 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 "Plans - Library" and all the workouts should be there.

Did this answer your question?