Import Players Help Guide

Back

Instead of manually typing in each of the names and contact info for every player, the Import Players feature allows you to quickly add your rosters into the system at once.

  1. Download the Sample CSV file - This will be your starting point for entering the information. Click the "Download Template CSV File" link and open the "QS-Player-Import.csv" file or save it to your computer.
  2. Open the CSV File - The CSV (Comma-Separated Value) file is similar to a spreadsheet and can be edited using Microsoft Excel. Once you have the file open, you will see that the top row contains all of the fields that can be defined for Players (along with the Team and League that they will be playing in).
  3. Enter the information - Here are all the fields that you can (or must) enter when importing teams:
    League Name or
    League ID
    Required if you are assigning a player to a non-unique team name
    Season Name Season Name and/or Sport Names might be required to differentiate between League names that used multiple times
    Sport Name
    Team Name Required if you want to assign the player to a Team
    Player's Name Required
    First Name First Name and Last Name can be used in place of the Player's Name field
    Last Name
    Local ID If your organization assigns unique IDs to players, enter it here
    Email Primary email address
    Email 2 Secondary email address
    Mobile Phone
    Home Phone
    Work Phone
    Gender Accepted values: M, F, Male, Female (capitalization ignored)
    Birthdate Preferred format is MM/DD/YYYY, but we are flexible
    Street Address
    City
    State
    Zip Code
    School
    Emergency Contact 1 Six possible fields: Name, Relationship, Phone, Email, Phone 2, Email 2
    Emergency Contact 2 Six possible fields: Name, Relationship, Phone, Email, Phone 2, Email 2
    Custom Fields Include a separate column for any custom fields. Text in the header column must match the already created field name.
  4. "Save As..." a CSV file - This is important! When you are done entering information, you must do a "Save As" and save the file as a CSV instead of a normal XLS file. The file types vary depending on which version of Excel you have, but the most common options are:
    MS Office 2010 CSV (MS-DOS)
    MS Office 2007 CSV (Comma delimited) (*.csv)
    MS Office 2003 CSV (Comma delimited) (*.csv)
    MS Office for Mac Windows Comma Separated (.csv)
    If you get prompted about "This file already exists. Do you want to replace the current file?" or "Do you want to keep the workbook in this format?", say yes to both questions.
  5. Upload the CSV file - Now it's time to get the teams into the system. Upload this new file on the Import Teams page and follow the steps on the screen to complete the import process.