Create Student Data Files

Build the student data files by following the format indicated below.

We recommend uploading an updated student .csv file on a termly basis.

FYI: For a reminder on the file structure notes check out Build Data Export Files.

School (.csv)

This file identifies all the schools.

Column Name Type Description
SchoolCode char(15) URN
Name char(250) Full school name.

Example:

LINC|Lincoln Secondary School|1
JOHNS|Johns Middle School|2

Student (.csv)

This file identifies all enrolled students that will use Xello in years 7-13. It must include the CurrentSchoolCode.

Column Name Type Description
UPN ID char(15) The student's unique pupil number that identifies each pupil in the local-authority-maintained school system.
FirstName char(100) Student's first name.
LastName char(100) Student's last name.
Gender char(1) M = Male, F = Female, N = Not Specified.
DateOfBirth Date Student's birth date. Format dd-mm-yyyy. Note: Ensure the format is entered correctly. Do not spell out the date.
CurrentYear Int The year the student is in. Note: Ensure the format is only the numerical value. Do not include the word "Year".
CurrentSchoolCode char(15) The SchoolCode of the student's current school.
Username char(100) UPN ID cannot be used as username. Email addresses or any username used by the school can be provided as their Xello username.
OPTIONAL COLUMNS
Email char(100) Student's email address.
Password char(10) Suggested password for the student.
ULN ID char(15) A student's unique learner number is used alongside and to access the Personal Learning Record of anyone over the age of 13 involved in UK education or training.

Example:

10005252|Erin|Smith|F|01-12-2005|8|JOHNS|LINC