File Requirements
Sections
Filenames
Filenames should be lowercase and start with "sections" (e.g. sections_your_filename.csv or sections.csv).
CSV Fields
Field | Required? | Notes |
section_name | required | |
subject | optional | |
delete | optional |
Add “TRUE” or “TRUE” to delete a section, otherwise leave blank |
Students & Teachers
Filename
- Students: Filenames should be lowercase and start with "students" (e.g. students_your_filename.csv or students.csv)
- Teachers: Filenames should be lowercase and start with "teachers" (e.g. teachers_your_filename.csv or teachers.csv)
CSV Fields
Field | Required? | Notes |
username | required | |
password |
only required for new users |
Must be a minimum of 6 characters |
first_name | required | |
last_name | required | |
grade_level | only required for students | |
birthdate | required | You can use dummy data here (e.g. "2020-01-01" for all students) |
ethnicity | optional | |
gender | optional | |
optional | If your school uses Google SSO set up, emails in your rostering file must exactly match student and teacher Google emails used for SSO. | |
sections | optional | Including sections in a teacher or student import will enroll the user in the indicated section or sections). |
delete | optional | Add “TRUE” to delete a student or teacher, otherwise leave blank |
File Formatting
- Special characters, such as parentheses or dashes, and spaces are not allowed. The only exceptions are:
- first_name, last_name, grade_level, and ethnicity are the only fields that can contain spaces.
- password and birthdate are the only fields that can contain special characters.
- Birthdate: Birthdate fields should be formatted as YYYY-MM-DD and cannot include spaces. For example, January 1, 2021, should be formatted as 2021-01-01 and not as 1/1/21 or any other date format variation.
- Sections: To enroll a user in more than one section, separate multiple sections by commas.
- Grade level: Note that the column header must be grade_level. For student's grade level, make sure you use the following required grade level formats. If you attempt to use other formatting for grade levels, you will receive an error and the upload will fail.
- Preschool
- Kindergarten
- 1st Grade
- 2nd Grade
- 3rd Grade
- 4th Grade
- 5th Grade
- 6th Grade
- 7th Grade
- 8th Grade
- 9th Grade
- 10th Grade
- 11th Grade
- 12th Grade
- Adult