Educator and student accounts, classes, and rosters (class enrollments) can be managed through our CSV (Comma-separated Values) import system.
| To get started, a user account with administrative access to discoveryeducation.com is required. If you do not have an administrator account, please contact our Customer Support Team. |
Opening the User Import Tool
- Click the Global Nav icon on your Homepage.
- Select Admin Dashboard.
- When My Admin opens, click Tools and select User Import.
Downloading Blank Import Templates
To download all blank file templates at the same time:
- After the User Import tool opens, confirm you are viewing the Roster Upload tab and then click Download All Templates to download all five blank roster file templates.
Overview of File Column Headers and Required Fields
This section gives a high-level overview of the column headers and fields in each template.
| All columns and column headers must be present on each file, even if optional fields are not used. |
Click a file name to jump to file details:
Teacher.csv
The Teacher.csv file creates or updates staff accounts.
| Column Header | Required | Field Details | Example |
| SchoolID | Yes | The Discovery Education School Passcode, site guid, OR mapped district SchoolID | "1234-ABCD" |
| SchoolName | No | The name of the school associated with the SchoolID | "MLK Middle School" |
| FirstName | Yes | The staff member's first name | "Quentin" |
| LastName | Yes | The staff member's last name | "Cisneros" |
| UserName | Yes |
|
"QCisneros@schooldistrict.com" |
| No | The staff member's district email | "QCisneros@schooldistrict.com" | |
| TeacherID | Yes |
Used to/for:
|
"T12345" |
Student.csv
The Student.csv file creates or updates student accounts.
| Column Header | Required | Field Details | Example |
| SchoolID | Yes | The Discovery Education School Passcode, site guid, OR mapped district SchoolID | "1234-ABCD" |
| SchoolName | No | The name of the school associated with the SchoolID | "MLK Middle School" |
| FirstName | Yes | The student's first name | "Laura" |
| LastName | Yes | The student's last name | "Wolf" |
| UserName | Yes |
|
"LWolf98@schooldistrict.com" |
| No | The student's district email | "LWolf98@schooldistrict.com" | |
| StudentID | Yes |
Used to/for:
|
"S98765" |
Grade |
No |
Student's enrolled grade level | 6 |
Class.csv
The Class.csv file creates or updates classrooms.
| Column Header | Required | Field Details | Example |
| SchoolID | Yes | The Discovery Education School Passcode, site guid, OR mapped district SchoolID | "1234-ABCD" |
| SchoolName | No | The name of the school associated with the SchoolID | "MLK Middle School" |
| ClassName | Yes | The classroom name students and educators will see | "Science Period 1" |
| ClassID | Yes | The classroom ID. The classroom ID must be unique within a school. | "SCI12345.1" |
| SchoolYear | Yes |
|
"2026" |
TeacherRoster.csv
The TeacherRoster.csv file connects the staff member accounts that were created or updated in the Teacher.csv file to the classrooms that were created or updated classrooms in the Class.csv file.
| Column Header | Required | Field Details | Example |
| SchoolID | Yes | The Discovery Education School Passcode, site guid, OR mapped district SchoolID | "1234-ABCD" |
| SchoolName | No | The name of the school associated with the SchoolID | "MLK Middle School" |
| ClassID | Yes | The ClassID of the corresponding educator/s classroom (Class.csv) | "SCI12345.1" |
| TeacherID | Yes | The TeacherID of the educator who should be associated with the classroom (Teacher.csv) | "T12345" |
StudentRoster.csv
The StudentRoster.csv file adds student accounts that were created or updated in the Student.csv file to the classrooms that were created or updated in the Class.csv file, creating classroom rosters.
| Column Header | Required | Field Details | Example |
| SchoolID | Yes | The Discovery Education School Passcode, site guid, OR mapped district SchoolID | "1234-ABCD" |
| SchoolName | No | The name of the school associated with the SchoolID | "MLK Middle School" |
| ClassID | Yes | The ClassID of the classroom the corresponding student should be added to (Class.csv) | "SCI12345.1" |
| StudentID | Yes | The StudentID of the student who needs to be added to the associated classroom (Student.csv) | "T12345" |
What Happens After Files are Uploaded?
After files are uploaded, data will be validated and imported immediately. After files have been validated and imported, they may be reviewed for errors under the History tab of the Import Tool.
Best Practices, Tips, and FAQs
| Q: What best practices do you recommend when completing files for the Import Tool? |
A: Follow these guidelines to help prevent import errors:
- All column headers must be present and all required fields must be populated.
- Remove any extraneous commas in the data. If the commas are necessary, contain them within double quotes (eg. "smith, jr").
- If using double quotes, use "straight double quotes: for all instances of quotation marks. “Curly double quotes” may cause an error.
- Save each file in .csv format.
- File names must contain the word "teacher" or "student" or "class" or "roster", depending on the type of file you are completing.
| Q: Why can't I add passwords using the Import Tool? |
A: For user security, passwords are not accepted as an import field. For students not set up with Single Sign-on, the Student ID can be used as a one-time password for students. Upon sign in, each student will be prompted to update their password.
|
Want to learn more how to set, update, and print Direct Login student passwords? Click an article title below. |
| Q: What are School IDs in Discovery Education? |
A: School IDs are the unique identifiers for each school in Discovery Education. They can be found in your My Admin dashboard. If you would like to use your own School IDs instead of our Site Passcodes, please let us know the corresponding IDs.
| Q: What are Discovery Education's best practices for usernames? |
A: Usernames must be unique to all of Discovery Education. We recommend using an email address to ensure uniqueness.
| Q: What are Discovery Education's best practices for confirming if we are creating or archiving data during an import? |
A: Add a Status column as the last column of each template.
- Set the Status as 1 to add new data or keep existing data active.
- Set the Status as 0 to archive existing data.
| If the Status column is not added to the template, the data will default to remain active. |
| Q: If my district isn't using a rostering tool like ClassLink or Clever, is the Import Tool the only way to create educators, students, and classes in Discovery Education? |
A: If you prefer, teachers can create their own classes manually and add students to their classes, unless your district has disabled this option. To learn more, open our Manually Create Accounts & Classes article.
| Q: Can my district use Single-Sign-On (SSO) if we use the CSV Import Tool to set up user accounts and rosters? |
A: Yes! Click here to learn more about imports for Single Sign-On districts.