If you want jersey numbers ready before check in starts, you can upload them in bulk using a CSV import. This is a helpful option when you already have pinnies assigned or want evaluators to see jersey numbers consistently during ratings.
You can also add jersey numbers one at a time during check in. That workflow is covered in Take Attendance at Tryouts.
What you’ll find in this article
How to export your tryout player list
How to fill out the jersey number upload template
How to import jersey numbers in bulk
How to clear existing jersey numbers
Before you begin
Jersey numbers are imported from a CSV file.
The import uses Player ID to match each jersey number to the correct player.
For the cleanest sorting on rating pages, format jersey numbers consistently (details below).
Step 1: Go to Take Attendance
In the left navigation, select Tryouts.
Open the tryout registration you want to work with.
Click Take Attendance.
Step 2: Export players to get Player IDs
In the top right, open the Actions dropdown.
Select Export.
This downloads a file with your tryout players and includes the Player ID you will need for the import.
Step 3: Download the jersey number upload template
Open the Actions dropdown again.
Select Import.
Select Tryout Jersey Number Upload Template.
Step 4: Fill out the template using the import layout
Use the Import Layout to populate your upload file. At minimum, you will fill out:
Player ID
Tryout Jersey Number
Tryout Jersey Number formatting tips
Jersey numbers can be alphanumeric.
If you use letters to indicate color or group (example: 12B), enter the numeric digits first, then any other characters.
To ensure rating pages sort by jersey number accurately:
Use the same number of numeric digits for all jersey numbers.
Example: use 01, 02, 34, 99 instead of 1, 2, 34, 99.
If you need 3-digit jersey numbers in a CSV
If you want all jersey numbers to be three digits (example: 001, 045, 120), you can format the column before saving the CSV:
Highlight the Tryout Jersey Number column.
Right click and select Format Cells.
Select Custom.
Enter 000.
Confirm the values display as three digits.
Step 5: Save as CSV and import
Save your file as a .csv.
In Sprocket, open the Actions dropdown.
Select Import.
Click Upload, choose your CSV file, then select Import.
Clear existing jersey numbers (optional)
If jersey numbers already exist and you need to start over, you can clear them before re importing.
Navigate to Tryouts.
Open the correct tryout registration and session.
Click Take Attendance.
Open the Actions dropdown.
Select Clear Tryout Jersey Numbers.
If you run into issues
If jersey numbers do not appear after import, confirm you used the correct Player ID values and saved the file as a .csv.
If sorting looks incorrect on rating pages, confirm all jersey numbers use the same digit length (example: 01, 02, 03).
FAQs
Can I assign jersey numbers one at a time instead of importing a CSV?
Yes. You can also add jersey numbers one at a time during check in. That workflow is covered in Take Attendance at Tryouts.
What file type do I need to import jersey numbers?
Jersey numbers are imported from a CSV file. Save your file as a .csv before uploading.
Why do I need Player ID for the import?
The import uses Player ID to match each jersey number to the correct player.
Why are jersey numbers sorting incorrectly on rating pages?
If sorting looks incorrect on rating pages, confirm all jersey numbers use the same digit length (example: 01, 02, 03).