Importing CSV

Importing CSV (Comma Separated Values)

Comma separated values are the easiest way to import data as you can edit them with most spreadsheet software (Google Sheets, Microsoft Excel etc)

CSV has no official standard however.

This page will detail how Timing Trials reads CSV files and how you can use google sheets to create a them.

Enter the time trial headers. The first column must start with ">>Time Trial".
Enter the time trial data (Name, date, laps etc)
Enter the course data headers. Row must start with ">>Course"
Enter course data (Name, length, CTT Course Code, etc)
Enter rider data headers. Must start with ">>Rider". Can either have "Rider Name" column or separate "First Name" and "Last Name" columns.
Enter the rider data. Timing trials will consider every row below ">>Rider" to be a rider, until it reaches another ">>Time Trial" so be careful!

(Note: formatting doesn't matter. Only the text content of the cells.)

Timing Trials CSV Template

Table must be preceded by ">>timing trials mixed results"
Enter column headings. Course, Date, Time and Rider are required, the rest are optional.
Finally a table of the results.

(Note: formatting doesn't matter. Only the text content of the cells.)

Method 2 CSV Template

Go to https://www.cyclingtimetrials.org.uk/ and go Events -> Startsheets or Results
Find your event and click view
Click CSV List button and open it with Timing Trials

Page updated

Google Sites

Report abuse