Import Organization Roster Members

Need to add your members and already have your roster saved in a spreadsheet? If your organization is using TeamSnap for Clubs and Leagues, you're in luck!

Note: Planning to use registration? All right stop! Collaborate and listen. Members will be added via the registration process and you don't need to import them beforehand. Skip on over to our registration articles to get started!

Prepare the CSV Roster File

You can use TeamSnap's league roster import template, or your own CSV file.  If you use your own file, you'll want to ensure that the column headings match up to what is listed in the import template. Have custom player information that you want to be imported? No problem! Before importing, you'll need to go to the league Settings tab and add 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 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 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.

Note: The email address in the player email column is the first email to receive a roster invite. This address will need to accept the invite before the P1 and P2 emails can be sent invitations. If the player is unlikely to accept this invitation promptly or does not have a TeamSnap account, you may want to list a parent email in the player email column, and have the child's email listed as a secondary contact. 

Import the CSV Roster File

  1. Click the Directory tab
  2. Click the Roster Imports button
  3. Click the Upload Import File button
  4. Click the Choose File button
  5. Select your import file and click Open
  6. Click Continue
  7. Click the Inspect button
    • Review a few imported records to ensure that the information is accurate and populating in the correct fields
    • Once satisfied, click Back to Roster Import
    • If the data is incorrect, click Import Later, make corrections to your import file and start back at step 5
  8. Click Create All Rosters to finish the import process

If you did not include data in the team column of the import file, you can assign members to their teams after the import by following the steps in the Adding Members help article.