To have a successful upload
You must download and use our template.
Do not delete any tabs or column headers.
All required columns must be filled in.
You must save it as a .xlsx file.
Things you will need
A list of your classes/teacher names.
A list of your runners with first name, last name, gender, and grade.
Optional: Parent contact information (first name, last name, email) if you want them to have the ability to submit miles run at home and follow their child’s progress.
Upload Roster Steps:
1. Download our Template
You will need to download our template to your computer and either open it in Excel or Google Sheets.
Please note: If you've already set up classes and participants, it's important to download the updated template. This will display your current classes, and you can then add new participants to them.
2. Add Classes
Enter your class names.
Add your classes on the "Add Classes" tab by filling in the Teacher's First Name, Last Name, and Class Name. The Class Name will appear on ID cards and the filters within your club dashboard and reports.
Enter the class's unique number.
This is a distinct number that groups runners in the related class on the "Add Runners" tab. Ensure that the numbers are different for each class and in numerical order to avoid running into conflicts.
Example: For 8 listed classes, assign numbers 1 to 8 in the unique class number column.
3. Add Runners
To add runners, you must copy and paste their first name, last name, gender, and grade into the "Add Runners" tab for each class. You will then add the corresponding class unique number that was assigned in the "Add Classes" tab. This process should be continued until all runners are added to the roster.
4. Save the Roster as an Excel file
Google Sheets roster download steps
After all runners and assigned class unique numbers are added, you will download the roster and save it as an Excel file.
In Google Sheets, click "File."
Choose "Microsoft Excel (.xlsx)
Excel roster saving steps
Click on the 'File' tab in the top left corner of the Excel window.
Select 'Save As' from the dropdown menu.
Choose a location on your computer where you want to save the file.
Enter a file name in the 'File name' box.
From the 'Save as type' dropdown, select 'Excel Workbook (.xlsx)'
Click the 'Save' button to save the file in the chosen format and location.
5. Upload the Roster File
After your roster has been saved to your computer, you will upload it to your account.
Click "Select File."
Find and select the saved roster file.
6. Review the Upload Summary
This gives you a final chance to review your roster and resolve any conflict that may have arisen from the uploaded file before saving it to your account.
Note: If you encounter numerous conflicts in your upload summary and prefer not to fix them, we can help. Click "Cancel" and send us the file you were trying to upload using the Upload Roster Support Form, and we'll work with you to resolve the conflicts.
7. Save your Roster to your Account