Comma-separated values (CSV) file

Knowledge Base Article ID: 37 ( Try another search )

A CSV (comma-separated values) file contains the values in a table as a series of ASCII text lines organized so that each column value is separated by a comma from the next column's value and each row starts a new line. Here's an example:

Leo,Bergkamp,4/17/1994,Boy,1st,Y,N,109654887
Madison,Akocha,1/26/1999,Girl,Other,N,Y,44-8798-09
Jason,Henry,,Boy,K,Y,Y,
Marco,Van Basten,4/17/1971,Boy,K,,Y,
Maria,,1/26/1973,Girl,K,,AF10BJ95

The example above defines 5 students. The first two students have a first/last name, birthdate, gender, grade, special needs indicator, ESL indicator, and a student ID. For example, the first line defines the student Leo Bergkamp. Leo's student ID is 109654887. He was born on 4/17/1994 and he is a boy in the 1st grade. He is a special needs student but not an ESL student. The fourth student, Marco Van Basten also has a first/last name, birthdate, gender, grade and ESL indicator. However, Marco does not have a value for the studentID nor the special needs indicator since they are optional. The third student, Jason Henry, does not have his birthday specified nor a student ID since birthday and student ID are optional. Finally, the last student, Maria, only has a first name, birthdate, gender , grade, and student ID.

A CSV file can be created by most Student Management Systems. Also, Microsoft Excel can be used to generate a CSV file. Once you have a CSV file in the correct format, you can use it to automatically enroll your students in Headsprout.

To view the CSV file specification that we support for importing student data during the enrollment process, please click here.

Keywords: CSV importing enrollment

Date last modified: 09/16/2005