Spark Institutional Administrator HelpSkip to start of content.

Import Multiple Students

Add multiple students to your course at the same time by uploading a roster CSV file.

  1. Click User Management.
  2. Click Import Expand > Students.

    The Import Students menu opens.

    Import Students menu with two options: "Download CSV template" and "Drop CSV file to upload or browse."
  3. Click Download CSV template.
    Download CSV template button
  4. Open the template in a spreadsheet editing program such as Excel.
  5. Enter student information.

    You can add a student to up to three courses with the template.

    Username
    The username for the account.

    Usernames can include the following characters:

    A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
a b c d e f g h i j k l m n o p q r s t u v w x y z
0 1 2 3 4 5 6 7 8 9
~ ` ! @ # $ % ^ & * ( ) _ - + = { [ } ] | \ : ; " ' < , > . ? /
    Your password should contain:
    • At least 8 characters
    • At least one uppercase letter
    • At least one lowercase letter
    • At least one number
    First Name

    User's given name.

    Last Name

    User's family name.

    Email

    Optional: An email address where Spark can send the student a link to set their password, or verify their identity if they forget their password.

    Note Without an email address, the user cannot set, or reset their own password.
    Course Key 1

    Your course's 8-digit identification code.

    Access Code 1

    A 10-digit code that verifies a student may access Spark materials.

    Not all schools require an access code.

    Course Key 2
    Optional: A second course key is needed to add a student to a second course.
    Access Code 2
    Optional: If your school uses access codes, a second access code is needed to add a student to a second course.
    Course Key 3
    Optional: A third course key is needed to add a student to a third course.
    Access Code 3
    Optional: If your school uses access codes, a third access code is needed to add a student to a third course.
  6. Save your spreadsheet as a CSV file.
  7. Upload your file by dragging it to Drop CSV file to upload or clicking browse and selecting your file.
    Upload CSV button
    Your upload has started and you will be sent a notification when it has completed. This notification will include details of any users which could not be provisioned successfully and the reasons for that.

    A message is shown in your Messages tab after each roster upload. It contains information about the created accounts or any errors.

    On the administrator dashboard, "Messages" has the label "1", meaning there is a new message.
  8. Check your messages to be sure all users were added successfully.
    1. Click the Messages tab.
    2. If your upload had errors, click the Error Report to download a report explaining each error in your original document.

      Common errors include not completing required fields or using an existing username.

      Correct your .CSV file and import it again.

    3. If your upload was successful, your message does not link to an error report.
Students in the roster are added to their courses.