If you don't use Liveheats for athlete registration, you can quickly import your whole event's athlete list into your Liveheats event by uploading a single CSV file.
If you'd prefer to import individual lists/files into each division individually, head over to this article for importing athletes into a division's seed list.
This article will take you through:
- How to save your athlete list as a CSV
- How to format your CSV file for import
- How to use the import athletes feature
How to save your athlete list as a CSV
To import your athletes into LiveHeats, you'll need to upload a CSV (Comma Separated Values) file.
If you have your athlete data in a spreadsheet, save it as a CSV file. You can typically do this within your spreadsheet application (like Microsoft Excel or Google Sheets) by going to the File menu and selecting "Export as .CSV" or "Download as .CSV."
How to format your CSV file for import
-
Minimum Required Information
At a minimum, your CSV file must include the following fields:
-
Name: You can include this as a single "Name" column or use two separate columns: "First Name" and "Last Name."
-
Division: The spelling of the Division in your CSV file must exactly match the Division names in your LiveHeats event.
Download our basic import template CSV file here, which includes the "Name" and "Division" columns.
-
-
Optional Information
You can also include these optional fields in your CSV upload:
- Seed: (Optional) You can always add seed numbers within LiveHeats later.
- DOB: (Date of Birth) Use the format "yyyy-mm-dd" (e.g., 1995-07-04). See here for how to change the date format in Excel.
- Nationality
- Team: (If included, the team name will be displayed beneath the athlete's name to the public.)
- Bib: (Athlete's Bib number identifier, typically used for snow events.)
You can arrange these fields in any order within your CSV file. You can also include only the required fields or all of them, depending on your needs.
Download our advanced import template CSV file here, which includes all optional fields. You can delete any columns that are not relevant to your athlete data.
How to use the import athletes feature
- Go to the Event Dashboard.
- Before drawing heats, locate the three dots menu in the top right corner of your Divisions section.
- Open the menu and select Import entries to open the import wizard.
- Click Select file and choose the CSV file you prepared.
- Select the header row of your CSV file and click Next.
- Match the columns from your CSV file to the corresponding fields in LiveHeats by selecting the correct options from each dropdown list. Some matches may be automatically suggested.
- Click Next.
- Review the data that will be imported carefully.
- Click Confirm.
- A final confirmation message will be displayed. Review it and click Import entries to complete the process.