Uploading Participants

As more race organizers are using RaceGorilla in combination with the dashboard, it is important to get a bit further into detail about uploading start lists.Uploading a start list is really quite easy if you have your list of competitors prepared in a spreadsheet.

How to prepare your spreadsheet?

You can have a spreadsheet with any column name and order, but if you would start from scratch, it is recommended to choose the following column names:

Bib

First Name

Last Name

Gender

Category

Tags

Club

Country

Remember that in RaceGorilla:

Bibs do not have to be unique, except when used in combination with the keypad entry at the finish (It is recommended in general to have unique bib numbers). Bibs can also contain characters.

Gender has to be either male,female or mixed

The category must exactly match the category in you RaceGorilla Competition

Tags can be anything you choose to make an extra indication of a participants status, such as U23, HC, or Suit or Skin. If a junior goes into the elite race using a swimsuit you can separate the two tags by a semicolon: U19;Suit.

Country must exactly match the list of countries in RaceGorilla (in English)

In the RaceGorilla dashboard

The RaceGorilla dashboard can be entered using the same login and password as used when entering the app.

After opening your competition you’ll see the settings screen and a menu to the left.

By default your competition is in of the type “Demo”. While you have full functionality in demo mode, the use is restricted to only 10 participants. This should be enough for you to practice using the software. More about these setting can be found in the dashboard tutorial and at the pricing page.

Uploading the participants

As stated earlier, the category names of your upload file have to exactly match the categories in your RaceGorilla competition. So you’ll first have to set the categories. By default the categories Men and Women are used in most pre-set formats.

After setting the categories, go to participant list. In the upper right corner you can choose upload participants.

Then its up to you whether you want to upload a fileo or just copy paste a selection of participants.

As an example You can just copy paste this table including the headers:

Bib

First Name

Last Name

Gender

Category

Tags

Club

Country

1

James

Watson

male

Men

U19

ABC

Australia

2

Jean-Claude

Leonard

male

Men

Ajax

France

3

Markus

Brummer

male

Men

Real Madrid

Germany

4

Guan

Da Silva

male

Men

Juventus

Spain

5

José

Balke

male

Men

Arsenal

Germany

6

Andrea

Dumoulin

female

Women

U19

Red Sox

Netherlands

7

Valerie

Bergman

female

Women

Juniors

Czech Republic

8

Suzan

Jansen

female

Women

Santa Monica

Italy

9

Michiel

Stock

mixed

Women

Red Sox

United States

10

Joost

Welling

male

Women

Juventus

Bulgaria

After pasting the table into the designated area and tapping next to accept the data. You have to assign each column of your data file to the correct RaceGorilla data format. As the columnheaders already match the RaceGorilla columnames, in this case it is a matter of assigning the correct column by tapping save. The team name could be skipped. if you want as it is empty.

After tapping “verify data”, a screen is shown indicating the number of records that will be imported. Here is to show what happens when a certain item does not match:

The category Pre-runners is unknown to the RaceGorilla. You can still submit the data and only 8 participants will be imported. The best solution is to go back to add the Pre-runners category and upload the file again. If you want you can edit here and assign the pre-runners to either Men or Women category.

Uploading a file works largely similar to the copy paste process. You can upload .CSV, XLS, XLSX. Be aware that only the first sheet of the excel file is imported and that all rows / columns containing data are being imported (if the data is correct)