×

Return to Sports Resources: We are committed to sharing resources to facilitate a safe return to play. See the Resources

Importing Rosters

How-to

This article covers roster imports and how to perform them at every level in TeamSnap.

Don't feel like entering each of your roster member's information one by one manually? That's strange because it sounds like a good time. Type typey type! Luckily there is an option for you to import your roster by uploading a .CSV file, so wipe that anxiety-induced bead of sweat from your brow and let's get started!

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

In this article


Roster Import for Divisions or Full Organization

Applies To:
User
  • Members
  • Team Admins
  • Team Owners
  • Org Admins
  • Org Owners
Device
  • Web app Web
  • iOS app iOS
  • Android app Android
Plan
  • Trial
  • Free
  • Basic
  • Premium
  • Ultra
Country
  • United States USA
  • Canada CAN
  • Worldwide Worldwide

If you are an administrator for an account using TeamSnap for Clubs and Leagues, then we recommend downloading the organization roster import template and plugging in your information for best results.

Download Org Roster Import Template

*This template will not work for team-level imports.

TIP: You can add columns to import information for custom fields you require, provided you create the custom fields in TeamSnap beforehand. Before importing, make sure you have a custom field created in your organization's Settings tab that does not match the name of any other existing roster columns, default or custom profile fields. If there are two fields with the same name, it will create an error. Insert the column for your custom field into your import spreadsheet after the Non-Player column and before the Email column, and make sure the column heading matches the custom field title that you set up in TeamSnap.

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 and the Parent 1 and Parent 2 first names are entered on the import file, the import will automatically create additional contacts in the player profile.

Formatting Requirements:

The first row of your file will be read by the system as column headings for mapping the imported information to the correct fields. If you prefer to use your own custom file, just ensure that your column headings match the fields in the template in order to correctly import roster information.

  • Birthdates for United States: MM/DD/YYYY 
  • Birthdates for organizations using international date format: DD/MM/YYYY 
  • Remove any blank rows, columns, and extra blank spaces before or after any of the data in each cell of your import file
  • Any division or team names included for team assignments must match exactly to how they are entered in TeamSnap

To import your players directly to a team, enter the team name in the “Team” column.  If you have divisions set up, you will also need to include the lowest level 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. 
Click to view division and org roster column headings
  • first
  • last
  • Non-Player
  • address
  • city
  • state
  • zip
  • birthdate
  • Jersey Number
  • Position
  • email
  • email_label
  • phone_number
  • gender
  • p1fn (parent 1 first name)
  • p1ln
  • p1relation
  • p1email
  • p1home (parent 1 home phone)
  • p1cell
  • p1work
  • p2fn (parent 2 first name)
  • p2ln
  • p2relation
  • p2email
  • p2home (parent 2 home phone)
  • p2cell
  • p2work
  • Team
  • Division

How to Import the Division or Org Roster File

  1. Click the Members tab
  2. Click the Import Members 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 for team assigments, you can assign members to their teams after the import by following the steps in the Assigning Members help article.

Getting stuck? Check out Troubleshooting Roster Imports.

Back to Top


Roster Import for Teams

Applies To:
User
  • Members
  • Team Admins
  • Team Owners
  • Org Admins
  • Org Owners
Device
  • Web app Web
  • iOS app iOS
  • Android app Android
Plan
  • Trial
  • Free
  • Basic
  • Premium
  • Ultra
Country
  • United States USA
  • Canada CAN
  • Worldwide Worldwide

Need to import your roster directly to a specific team? If you are an independent team owner or manager, or an organization administrator needing to import rosters team-by-team, you can use our team roster import template below, or create your own CSV file to import. Up to 100 roster entries can be imported at once. For rosters over 100, please divide your roster into separate files for importing.

Download Team Roster Import Template

*This template will not work for division or organization-level imports.

Formatting Requirements:

The first row of your file will be read by the system as column headings for mapping the imported information to the correct fields. If using your own custom CSV file, the columns in your file should match the fields in the roster profile in order to correctly import roster information. 

Click to view team roster column headings
  • First Name
  • Last Name
  • Email Address 1
  • Email Address 1 Label
  • Email Address 2
  • Email Address 2 Label
  • Email Address 3
  • Email Address 3 Label
  • Phone Number 1
  • Phone Number 1 Label
  • Phone Number 2
  • Phone Number 2 Label
  • Phone Number 3
  • Phone Number 3 Label
  • Address
  • City
  • State
  • ZIP/Postal Code
  • Gender
  • Birthday
  • Jersey Number
  • Position
  • Non-Player (Y/N)

How to Import the Team Roster File

  1. Navigate to the team site
  2. Click the Roster tab
  3. Click Import Players
  4. Click Choose File
  5. Choose and open the file to import (.XLS, .XLSX or .CSV)
  6. Double check that all your fields are correctly mapped
    1. For each column of data, select the corresponding TeamSnap column name from the drop-downs. If you don’t want to import a column, or there is no match, select “No Match.” We’ll import only the data that has a matching column name. We promise!
    2. If any field mapping errors are displayed, correct the issues before attempting to proceed by clicking the field and correcting the information. The system will not import fields with a mapping error.
  7. Click Save Roster  
  8. Finally, you just need to invite your roster members to join the team!

Back to Top


Team to Team Roster Import

Starting a new team with some familiar faces? You can invite current or former teammates directly to your new roster using the import from another team tool. Commissioners for sports organizations are not assigned to teams and will not see the option to import from another team. 

NOTE: The team to team roster import is only available to team admins (managers or owners) with a manager profile on the both the team to import players from and to. 
  1. Log into TeamSnap
  2. Click your roster name below the team you will be transferring to, to enter the team site from the dashboard
  3. Click the Roster tab
  4. Click Import From Another Team 
  5. Select the team to import from
  6. Select the names of the players within the team that you want to import
  7. Select/Deselect the checkbox to send invitations to join as desired
  8. Click Import # Players
  9. Click Send Invite to confirm sending the imported players invitations to join the team or click Don't Send to skip sending invitations
  10. All done! Your imported players will be displayed under the Roster tab as soon as the import has finished processing
NOTE: Information that is hidden from teams or marked 'private' on roster profiles will not be copied over.  

Back to Top


Common Questions

Do non-players count towards the roster limit for my team plan?

Yes, all members including both players and non-players added to the roster count toward the total roster member count.

Still need help? Contact Us Contact Us