This guide is for setting up and importing student .CSV files as part of a manually rostered school.
This article does not apply to Clever or ClassLink rostered districts/schools
You can add each student account manually, but importing a student list can save time.
Use the main drop-down menu at the top right and select Students to reach the Manage Students page.
At the bottom of the page, select the Import Student .CSV File button to reach the Import Students Page.
Use the link Download Sample .CSV File to get the template for the student import.
Input the data into the spreadsheet or paste it from a student management system. Do not rename, move, delete, or add to the column labels, or the roster import will not work. The header row (row 1) must remain the same as the sample CSV file.
The required spreadsheet fields are marked with an “(R)” to the right of their field name.
Require Fields:
Column A: Action (A/U)
"A" represents adding a new student
"U" represents updating an existing student
Column B: Username - This must be unique for your school.
Column C: Password: Password must be at least 8 characters long, with one uppercase letter, one number, and one symbol.
Password also can't contain their username ex. username: student1, the password cannot be student1ABC$"
Column G: Grade - The word “Grade” must be typed before the student’s numerical grade level. This field is not technically required, but it helps organize student accounts for class creation. "Grade 3", for Kindergarten use “Grade K”
Column J: Active/Inactive
If a student is currently enrolled at your school, you will enter "Active" in this field. If they are no longer enrolled at your school, you will enter "Inactive" into this field.
Not Required Fields:
Column D: First Name
Column E: MI - Middle Initial is usually left blank.
Column F: Last Name
Column H: Student ID - Helps for organization. It can also be used as a password.
Column I: email address - Usually left blank, the email address has no function in the program for student accounts.
Save the file (keep the file in CSV format, DO NOT let Excel change the format).
-
Choose the saved CSV file and click the “Upload” button to load it into the system.
The next screen displays a preview of the data, with invalid rows shown by default. An error message will appear for any invalid rows. These rows won't be imported. To proceed, select Cancel to fix your import file and try again, or click the Import button to import only the valid rows.
A summary of the import is displayed, and the import is completed.
