To import a training plan or a training log, you will have to create and put the spreadsheet into a csv filetype (comma separated value) first while using the same cell headers as we do.
Alternatively you can export a date range and use the headers from that as a template to import by. Use only what is necessary.
Use the following headers and formatting guidelines immediately below.
If you want to import 'empty' days between workouts, you must have it in the spreadsheet.
*Excel Users - You can save an Excel worksheet to a .csv file by doing a 'Save As' and choosing 'Other Formats' and then 'CSV - Comma Separated Value'.
You only need the cell headers of things you want to import.
All times are in 'decimal minutes'.
Date header and format
- Log date (v1.2): Dates can be in dd/mm/yyyy format, or sequential numbers (1, 2, 3, etc)
Swim headers and format
Swim time (minutes), Swim distance, Swim units, Swim pace, Swim pace units, Swim comments
* Swim units are 100. Use them as follows: min/100yards, min/100meters
** For 'Swim pace', you can leave empty if you have time and distance. Pace is in decimal minutes.
Bike headers and format
Bike time (minutes), Bike distance, Bike units, Bike pace, Bike pace units, Bike comments
*Bike pace units is either mile or km. You can leave empty if you have time and distance. Pace is in decimal minutes.
Run headers and format
Run time (minutes), Run distance, Run units, Run pace, Run pace units, Run comments
*Run pace units is either mile or km. You can leave empty if you have time and distance. Pace is in decimal minutes.
Strength headers and format
Strength total time (Minutes), Strength comments
Sports headers and format Sports comments
Overall comments
Importing your training plan or training log
You can access the import area by going to SETTINGS --> TRAINING LOG SETTINGS --> MY TRAINING PLANS
At the bottom you will see a 'Import a plan' box:
Then choose the .csv file you would like to upload:
After uploading, your import will be available in the area above the 'Import a Plan' box.
Imports don't go directly to your training log or your planned training. You will then be able to edit the title, browse and edit the training days if needed. You can also copy the plan or data into a new plan and further modify.
Once you are happy with the training log or training plan, you can then use the 'Upload to your training' link to get the following:
You can choose to import it into your actual or planned training log with several customization options.
EXPORTING
Go to SETTINGS --> TRAINING LOG SETTINGS --> EXPORT LOG DATA
Choose the actual or planned training log to export and the date range. If you will be making modifications to a training plan and importing it, include the empty days in the export.
You will then get prompted to save the file as a .csv and you will then be able to open and modify it in Excel or other compatible spreadsheet.
NOTE, there will be many more feilds of data included in an export (health, HR zones, sports, etc) . For simplicity, we only use the basic date, swim, bike and run time/distance/pace/comments for import.
login
View profile
Add to friends
Go to training log
Go to race log
Send a message
View album
CONNECT WITH FACEBOOK
Import <---> Export
How to use the import and export feature of the training logs for training plan uploading, plan-building and other analysis.
With the import/export functionality, you will be able to:
Import a basic training log via a csv file to add to your actual training log.
Export your actual training for other analysis on other spreadsheets.
Import a training plan that you created via csv to use/reuse in your planned training log and all associated features and graphs.
Export a BT training plan from your planned training to modify in Excel or other spreadsheet then import the modified plan to use/reuse.
Features talked about per membership level:
Actual Import - Free
Planned Training Import - Performance Member
Actual Export - Free
Planned Training Export - Performance Member
IMPORT YOUR TRAINING LOG OR PLAN FROM CSV
Creating a .csv spreadsheet for importing
To import a training plan or a training log, you will have to create and put the spreadsheet into a csv filetype (comma separated value) first while using the same cell headers as we do.
Download the Import Template
Alternatively you can export a date range and use the headers from that as a template to import by. Use only what is necessary.
Use the following headers and formatting guidelines immediately below.
If you want to import 'empty' days between workouts, you must have it in the spreadsheet.
*Excel Users - You can save an Excel worksheet to a .csv file by doing a 'Save As' and choosing 'Other Formats' and then 'CSV - Comma Separated Value'.
You only need the cell headers of things you want to import.
All times are in 'decimal minutes'.
Date header and format
- Log date (v1.2): Dates can be in dd/mm/yyyy format, or sequential numbers (1, 2, 3, etc)
Swim headers and format
Swim time (minutes), Swim distance, Swim units, Swim pace, Swim pace units, Swim comments
* Swim units are 100. Use them as follows: min/100yards, min/100meters
** For 'Swim pace', you can leave empty if you have time and distance. Pace is in decimal minutes.
Bike headers and format
Bike time (minutes), Bike distance, Bike units, Bike pace, Bike pace units, Bike comments
*Bike pace units is either mile or km. You can leave empty if you have time and distance. Pace is in decimal minutes.
Run headers and format
Run time (minutes), Run distance, Run units, Run pace, Run pace units, Run comments
*Run pace units is either mile or km. You can leave empty if you have time and distance. Pace is in decimal minutes.
Strength headers and format
Strength total time (Minutes), Strength comments
Sports headers and format
Sports comments
Overall comments
Importing your training plan or training log
You can access the import area by going to SETTINGS --> TRAINING LOG SETTINGS --> MY TRAINING PLANS
At the bottom you will see a 'Import a plan' box:
Then choose the .csv file you would like to upload:
After uploading, your import will be available in the area above the 'Import a Plan' box.
Imports don't go directly to your training log or your planned training. You will then be able to edit the title, browse and edit the training days if needed. You can also copy the plan or data into a new plan and further modify.
Once you are happy with the training log or training plan, you can then use the 'Upload to your training' link to get the following:
You can choose to import it into your actual or planned training log with several customization options.
EXPORTING
Go to SETTINGS --> TRAINING LOG SETTINGS --> EXPORT LOG DATA
Choose the actual or planned training log to export and the date range. If you will be making modifications to a training plan and importing it, include the empty days in the export.
You will then get prompted to save the file as a .csv and you will then be able to open and modify it in Excel or other compatible spreadsheet.
NOTE, there will be many more feilds of data included in an export (health, HR zones, sports, etc) . For simplicity, we only use the basic date, swim, bike and run time/distance/pace/comments for import.
Download the Import Template
Click on star to vote