Importing Races
If you have a large number of races to create, you can upload a CSV or Excel file to import them all at once instead of creating each race individually. The import will create new races and update existing ones (matched by name and date) in a single operation.
Contents
Who can import races
The Import Races button is only available to organisation race managers — users who manage races at the organisation level and have been granted the Import races permission.
Note: Clubs (subaccounts) cannot import races. If you are a club race organiser, ask your organisation race manager to import the races on your behalf.
How to import races
- Prepare your CSV or Excel file using the file format described below.
- Navigate to the Races page for your organisation.
- Click Import Races.
- Select your prepared file.
- Click Upload. The races are created or updated immediately.
A summary message confirms how many races were created or updated. If any rows could not be processed, an error message identifies the problem row and the reason for the failure.
What happens during import
- Each row in the file is matched to an existing race by race name and race date. If a matching race is found, it is updated with the values from the file. If no match is found, a new race is created.
- If a row contains any validation errors (for example a missing required field or an unrecognised race type), that row is skipped and an error is reported. Other rows are still processed.
- Pricing information (pricing level deadlines and per-class fees) is created or updated alongside the race.
File format
The file must be a CSV or Excel (.xlsx) file. Each row represents one race. The supported
columns are described below. Column names are case-insensitive.
For full details of all supported columns and accepted values, see the Race Import File Format reference.
Required columns
| Column | Description |
|---|---|
| race name | The name of the race |
| race type | The race type code or name (must match an existing race type) |
| race date | The date of the race (YYYY-MM-DD or DD/MM/YYYY) |
| entry closing date | The entry deadline date and time |
Optional columns
| Column | Description |
|---|---|
| race code | A short internal code for the race (up to 20 characters) |
| location | The race venue address |
| location latlng | The venue coordinates as latitude,longitude |
| entry opening date | The date and time from which entries can be submitted. If omitted, entries open immediately. |
| subaccount | The subaccount code or name to associate the race with |
Pricing columns
Pricing information is configured using additional columns named after the pricing levels defined
for each race type. For a pricing level with the code PR1, the deadline column is named
pricing PR1 deadline. For a fee applying to competitor group adult at pricing level standard,
the column is named fee adult standard.
See Race Import File Format for worked examples.