Importing athletes via CSV

Modified on Tue, 16 May 2023 at 05:38 PM

Swift Labs allows you to import athletes via a CSV input.

Navigating to the athletes page, you will be presented with a list of your athletes, or if you have yet to add any athletes; a page detailing the options in how to add athletes.

By clicking the import button on the athletes page, you will be prompted to upload the CSV file with your athlete data.

If you do not have a csv file, you click on the Download button to download the CSV template or download it here CSV Template Download

The CSV file has some strict formatting rules that must be followed. The table below contains the a description for each of the CSV keys and whether the column is required.

IMPORTANT

It should be noted that the Athlete’s height and weight is dependent on the value in the Units column. ‘metric’ will treat athlete weight and height in Kilograms and Centimetres respectively. Vice-versa ‘imperial’ will treat weight in pounds and height in feet and inches. Imperial athlete height must be input as ‘X ft X in’, eg, ‘6 ft 2 in’. All units within labs are displayed depending on your profile settings.

Column	Required	Description
FirstName	Yes	Athlete first name
MiddleName	No	Athlete middle name
LastName	Yes	Athlete last name
Notes	No	Athlete notes
Email	No	Athlete email
DOB	Yes	Athlete date of birth
Weight	Yes	Athlete weight in kg or lbs with no unit.
Height	Yes	Athlete height in cm or ft, in (only imperial needs units with the following format “X ft X in”)
Sex	No	Athlete sex (Male \| Female \| Undecided \| Withheld)
Squad	No	Athlete squads to join (must be the exact spelling of the squad, can join multiple by using the “\|” delimiter eg (Squad 1\|Squad2)
Units	Yes	Units of the athlete (metric\|imperial)

After selecting the file you wish to upload you will shown the rows within the CSV file if you will to remove any rows prior to submitting. Pressing the import button will upload the file and add the athletes.

An important note is to ensure that you have enough available seats within your organisation. Prior to importing the athletes, the application will check if you have enough available seats, if you are trying to upload more athletes than seats available, the application will refuse to upload the athletes.