Do you already have your roster saved in a spreadsheet? If your organization is using TeamSnap for Clubs and Leagues, you're in luck!
You can use our roster import template, or your own comma-delimited (.csv) file. If you use your own .csv file, make sure to use the same column headings that we have on the import template. Have specific player information that you want imported as well? No problem! Prior to the import, you will want to go to the league admin settings tab and set up custom fields for this data. You’ll then add a column to your import file for each of the custom fields that you created. Your column headings for those custom fields should match exactly with the custom field title that you set up.
Import file key:
P1 = Parent one
P2 = Parent Two
Non-Player = Enter Y for non-player (i.e. coach/manager), Enter N or leave blank for player.
When there is data in the P1 and P2 columns, the import will automatically create Additional Contacts in the player profile, as long as the Parent 1 and Parent 2 first and last names are populated on your import file. You can add as many Additional Contacts on your import file as you need using P3, P4 etc.
If your spreadsheet has any blank rows, you will want to make sure to remove them.
To import your .csv you will just want to go to the league/club level Roster page and select the button that says Roster Imports.
On the Roster Imports page, click on the button that says “Upload Import File” and choose your file from your computer.
Once the importing is complete, you will have the option to inspect the records first. If all looks good, go ahead and click on “Create All Rosters” and you will be up and running!
To import your players directly to their team, you will want to include their team name in the “team” column. Make sure that team name matches exactly how you have it set up in TeamSnap. If you have divisions set up, you will need to include the division too. Make sure the division name matches how you have it set up in TeamSnap as well. If you have sub-divisions, you would put in the division name for the lowest level sub-division.
If you did not include their team in the import, after your import is complete you can assign your players to their respective teams using the Change Team button, or the bulk action option at the bottom of the league/club level Roster page.