CSV Rostering: File Requirements and Formatting

Filenames should be lowercase and start with “sections” (e.g., sections_your_filename.csv or sections.csv).

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)

*All field headers are required but content is optional

Field	Required?	Notes
username	required	This must be unique across teachers and students (i.e., a student and a teacher cannot have the same username).
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
email	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.

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