2 minutesBefore you begin, for a reminder on the file structure notes and automating subsequent exports, check out Build Data Export Files 
Build the student data files by following the format indicated below.
Note: This setup integration depends on your school's subscription service. If you're unsure if your school has this setup, reach out to your Xello Success Manager.
Student (.txt or .csv)
This file identifies all enrolled students that will use Xello in grades K-12. It must include the CurrentSchoolCode and PreRegSchoolCode.
The student CurrentSchoolCode and PreRegSchoolCode will be the same in many cases. However, when a student is transitioning from Grade 8 to Grade 9, or if they're transferring schools, the CurrentSchoolCode indicates the student's elementary, middle (or sources) school, and PreRegSchoolCode indicates the high school location the student will attend next year.
| Column Name | Type | Description |
|---|---|---|
| StudentID | char(15) | Unique for the district (not just unique to the school). If this is not unique for the district, please inform your Onboarding Manager. |
| FirstName | char(100) | Student's first name. |
| LastName | char(100) | Student's last name. |
| Gender | char(1) | M = Male, F = Female, N = Not Specified. |
| CurrentGrade | Int |
The grade the student is in. Note: Use "0" for kindergarten. |
| CurrentSchoolCode | char(15) | The SchoolCode of the student's current school. |
| PreRegSchoolCode | char(75) | The SchoolCode that the student will be attending next year. If blank, we assume CurrentSchoolCode. |
| DateOfBirth | Date |
Format yyyy-mm-dd. Student's birth date. Note: Ensure the format is entered correctly. Do not spell out the date. |
| OPTIONAL COLUMNS | ||
| StateProvNumber | char(20) | The student's unique state or province ID. |
| char(100) | Student's email address. | |
| Password | char(10) | Suggested password for the student. |
| SSOStudentToken | Speak to your Onboarding Manager about SSO Options and configuration. | |
Example:
10005252|Erin|Smith|F|2005-01-12|8|JOHNS|LINC
