How to Mass Import or Upload Users from CSV

New Users can be uploaded to the Sparta Cloud via CSV import. This is particularly helpful when large volumes of Users are added, and information can be copied-and-pasted from existing rosters.

To learn how to add one User at a time, click here for a tutorial.

 

 

Add Users from CSV Upload

  1. Navigate to a Team
  2. Click "Add Users" in top right of your screen
    Screen Shot 2022-08-05 at 1.37.22 PM
  3. Click "Import from List" on pop-out menu
    Screen Shot 2022-03-29 at 4.17.02 PM
  4. Click "Download CSV Template", then open the document once the download is complete
  5. Clear all example data (rows 2 and 3) before beginning roster entry
  6. Begin filling in each column by entering First and Last Names, or copy and paste from existing rosters
  7. There are four required fields when creating a new User:
    1. First Name
    2. Last Name
    3. Sex Assigned at Birth (m or f)
    4. Birth Year (YYYY)
  8. Optional fields:
    1. Email Address - personal email address to use for viewing your user profile and/or utilizing the Sparta MOVE App
    2. Height (first column is ft., second column is in.)
    3. Invite ("y" for yes and "n" for no) - if an email is included, "y" will trigger an invitation email to the User
    4. Group Membership - click here for a guide to creating Groups
      1. To automatically add a User to an existing Group, type in the Group name as it appears on Cloud
    5. Tags - must be activated in Team settings. Click here for a guide to setting up Tags
      1. Tags must be entered as Main:Subgroup as they appear in Cloud. For example, "Baseball:Pitcher" or "Public Service:Police"
      2. To add more than one tag to a User, separate each by a comma and one space. For example, "Soccer:Forward, Soccer:Midfield"
    6. External ID - student ID number, jersey number, patient ID, or other alternate ID, if desired
  9. Before saving CSV for upload, clear all edits including text formatting and hyperlinks. Select all the data, click the Clear icon that looks like a rubber eraser, and click "Clear All Formats" from the dropdown list. 

    Screen Shot 2022-03-29 at 4.15.11 PM
  10. Save the document as a CSV, then navigate back to the Sparta Cloud. Click the Cloud icon under Import From List and select the document from your computer.
    Screen Shot 2022-03-29 at 4.17.02 PM
  11. Upload will be populated on a screen that allows you to correct any typos or erroneous entries. Review and edit within, and when finished, click Import Subjects.

Screen Shot 2022-03-29 at 4.18.29 PM