CSV file requirements for bulk import – Discovery Education UK

Users with Admin access to the platform can bulk import teachers, students and classes into the platform. You will need to extract teacher, student and class data from your MIS system into a .CSV file to use with our User Import Tool.

-------------------------------------------------------------------------------------------

If you are the school administrator, but do not have the Admin dashboard tile on your homepage, please email schoolsupport@discoveryed.com so we can transition your account to have Admin access.

Please also read our step by step guide before uploading your files.

-------------------------------------------------------------------------------------------

Column headers and required fields

This section gives a high level overview of the column headers and the fields in each template. Ensure that all columns and headers are present, even if optional fields are not used.

Under Templates List section, 'Details' link will provide you information on the fields that you will require from your MIS for each template type. 'Download' will download the template for you to populate.

Teacher template

Column headers and field details below

Column headers/Fields	Required field	Description
SchoolName	Required	School Name as it is in the platform (Pre-populated by Discovery Education)
SchoolID	Required	Discovery Education School Passcode (Pre-populated by Discovery Education)
FirstName	Required	School to enter teacher's first name
LastName	Required	School to enter teacher's last name
Username	Required	School to enter teacher's email address For Google SSO - use email address For Office 365 SSO - use email address No SSO - teacher work email is recommended as username
Email	Required	Used to reset passwords. School to enter teacher's work email
TeacherID	Required	School to enter an ID, this can be anything (see example below) or the MIS id ID is used to update username and email ID is used to link teachers to classes in import Duplicate values not accepted

CSV file example data -

Student template

Column headers and field details below –

Column headers/Fields	Required field	Description
SchoolName	Required	School Name as it is in the platform (Pre-populated by Discovery Education)
SchoolID	Required	Discovery Education School Passcode (Pre-populated by Discovery Education)
FirstName	Required	School to enter student's first name
LastName	Required	School to enter teacher's last name
Username	Required	School to enter a preferred username for the student For Google SSO - use email address For Office 365 SSO - use email address No SSO - your preferred username. Note, if the username is not unique in the platform, the upload will provide you with an error notification. We recommend you add a prefix to the username to ensure this is unique first time round. See example below.
Email	Optional	School to leave this field blank
StudentID	Required	School to enter an ID, this can be anything (see example below) or the MIS id ID is used to update username and email ID is used to link students to classes in import Duplicate values not accepted
Grade	Required	School to enter the student's 'year group' This is the 'Year' the student belongs to. Used to link students to classes in import

CSV file example below -

Class template

Column headers and field details below –

Column headers/Fields	Required field	Description
SchoolName	Required	School Name as it is in the platform
SchoolID	Required	Discovery Education School Passcode
ClassName	Required	Name that users will see
ClassID	Required	Must be unique within a school
SchoolYear	Required	Differentiates classes from year to year IF ClassID remains the same

CSV file example below -

TeacherRoster template

Column headers and field details below –

Column headers/Fields	Required field	Description
SchoolName	Required	School Name as it is in the platform
SchoolID	Required	Discovery Education School Passcode
ClassID	Required	ClassID from Class.csv
TeacherID	Required	TeacherID from Teacher.csv

CSV file example below -

StudentRoster template

Column headers and field details below –

Column headers/Fields	Required field	Description
SchoolName	Required	School Name as it is in the platform
SchoolID	Required	Discovery Education School Passcode
ClassID	Required	ClassID from Class.csv
StudentID	Required	StudentID from Student.csv

CSV file example below -

Related articles