Empty

You Have 0
Items in Your Cart

Help

Student data CSV file format

Knowledge Base Article ID: 39 ( Try another search )

When you import student data during the enrollment process using a CSV file, the values of the fields must conform to expected values. For example, it would not make sense to have the value "Boy" in the birthdate field. This document will describe the order (column) that each field must be in, the name of each field (including its description), and range of acceptable values for each field.


ColumnField NameDescriptionValid Values
1Student First NameContains the first name of the name of the studentAll values are valid
2Student Last Name*Contains the last name of the name of the studentAll values are valid
3Birthday*Birthdate of studentMM/DD/YYYY
4GenderGender of the studentBoy,Girl,Male,Female,B,G,M,F
5GradeThe grade that the student is inpreK,K,1st,2nd,3rd,other,0,1,2,3
6*Special Needs flag*Indicates whether or not the student is a special needs learnerYes,No,True,False,Y,N,T,F
7*ESL flag*Indicates whether or not the student is an ESL studentYes,No,True,False,Y,N,T,F
8Student ID*Defined by the school.All values are valid
Note: Field names marked with an asterisk (*) are optional.

Example: Your spreadsheet may look like this:

You would then export your spreadsheet to a CSV file (Note: Excel and other spreadsheets allow you to save your spreadsheets as .CSV files) and use that CSV file during Headsprout's student enrollment process.

Example (continued): After the CSV file has been created, if you opened it up in a Text Editor (such as Notepad), it would look like this:

It is important to note that even though some fields are optional, (for example, birthday), your CSV file must still have a place holder for that column.

Keywords: enrollment CSV importing values schema

Date last modified: 09/16/2005

Quick Links

Knowledge Base

Frequently Asked Questions