Import race results from a spreadsheet

Copy your club's rows from the organiser's results and paste them in, instead of typing each one.

You need the Editor or Owner role.

1. In the organiser's spreadsheet, copy the column names row and your club's rows.
2. Open Schedule, choose Races, click the race, then click Add results (or Change the results).
3. Open Paste from a spreadsheet and paste into the box.
4. Click Use these results. The rows appear in the table below.
5. Check them, fix anything that's wrong, then click Save the results.

There's no file upload. If you have a CSV file, open it in a spreadsheet or text editor and copy from there. Rows copied from a spreadsheet and lines of comma-separated text both work.

The columns it reads

The first line must be the column names. Club Routes looks for these (capitals don't matter):

• Name: "Name", "Runner", "Athlete", "Full name" or "Competitor". Or "First name" and "Last name" (or "Forename" and "Surname"), which are joined together.
• Sex: "Sex", "Gender" or "M/F". Anything starting with M or F counts.
• Age: "Age".
• Distance: "Distance", "Race", "Event" or "Course". If there isn't one and the race has one distance, that's used.
• Time: "Chip time", "Net time", "Time", "Finish time" or "Gun time". Chip or net time is used when there's a choice.
• Position: "Pos", "Position", "Place", "Overall" or "Overall position".
• Age grade: "Age grade", "Age graded %", "AG%" or "WAVA". A % sign is fine.

Other columns are ignored.

Good to know

• Pasting replaces the rows already in the table.
• Saving replaces all the results for that race.
• If you see "The first line should be the column names", check the name column is there.