School Setup: Upload Students

The "Students" tab lists out the entire student population at your school. You can add, edit, or deactivate students in bulk. Click "Upload" to reveal the import/export section. Then, click "Download import template".

The .csv file you download will list all active students in the school (it will include inactive students as well, if you toggle the "Show Inactive" button first). Don't modify any column headers or the import may not work (including "Schoolrunner Student Attribute Import v1" in cell A1).

Here's an overview of the columns.

Column Header	Required	Format	Notes
First Name	Yes	String
Middle Name	No	String
Last Name	Yes	String
Student ID	No	Integer	Leave blank for new records. DON'T MODIFY if present.
SR Student Number	No	String
SIS Student Number	No	Integer
State ID	No	String	M/D/YY or YYYY-MM-DD format.
Active	No	Boolean	Will default to 1 (active) if left blank.
External ID	No	Integer
Grade Level	Yes	Integer	-1 for Pre-K, 0 for Kindergarten, 1-12.
School	No	String
Lunch ID	No	String
Ethnicity	No	Integer	Match decode for ethnicity.
Gender	No	String	Match decode for gender.
Lunch Status	No	String	Match decode for lunch status.
DOB	No	Date	M/D/YY or YYYY-MM-DD format.
Street	No	String
City	No	String
State	No	String	Use two-letter abbreviation.
Zip	No	String
Phone	No	Phone	Use (###) ###-#### format.
Email	No	Email
Mailing Street	No	String
Mailing City	No	String
Mailing State	No	String	Use two-letter abbreviation.
Mailing Zip	No	String
Bus Route	No	String
Bus Stop	No	String
Transfer Comment	No	String
School Entry Grade Level	No	Integer	-1 for Pre-K, 0 for Kindergarten, 1-12
Entry Code	No	String	Match decode for entry code.
Entry Comment	No	String
Exit Code	No	String	Match decode for exit code.
Exit Comment	No	String
Entry Date	No	String	M/D/YY or YYYY-MM-DD format.
School Entry Date	No	Date	M/D/YY or YYYY-MM-DD format.
District Entry Date	No	Date	M/D/YY or YYYY-MM-DD format.
Exit Date	No	Date	M/D/YY or YYYY-MM-DD format.
Alert Discipline	No	String	Will be highlighted on student page in web and mobile, if present.
Alert Guardian	No	String	Will be highlighted on student page in web and mobile, if present.
Alert Medical	No	String	Will be highlighted on student page in web and mobile, if present.
Alert Other	No	String	Will be highlighted on student page in web and mobile, if present.

When you're finished working in the spreadsheet, be sure to save it as a .csv and then drop it back into Schoolrunner in the same section from which you downloaded the template.

Pay attention to any errors that are displayed. An error will prevent all changes in your file from being processed. Address any issues mentioned by the errors in your spreadsheet, save, and re-upload. Contact Schoolrunner support with any issues you can't resolve yourself.