Importing Student Data

If you have the student data in a specific format and would like to import it into RunPTO, you can send a CSV or XLS formatted file to us. We offer free import services for student data. We prefer the following format for the CSV file to ensure smooth and accurate data import.

You can also do your own student data import by following the instructions here.

Student Data File Format

The csv file should be in the following format.
The first row should be header and should have the columns described as below:

Column 1: Name
Column 2: Parent 1 Name
Column 3: Parent 2 Name
Column 4: Grade
Column 5: Teacher
Column 6: Address 1
Column 7: Address 2
Column 8: Email 1
Column 9: Email 2
Column 10: Phone 1
Column 11: Phone 2

The subsequent rows will have values:
Example below
Column 1: John Brayden
Column 2: Jim Brayden
Column 3: Jill Brayden
Column 4: 1
Column 5: Olivia Smith
Column 6: 6509 Elf Dr,Harrisburg, PA 17112
Column 7:
Column 8: jim@yahoo.com
Column 9: jill@yahoo.com
Column 10: 7176870869
Column 11: 7891234567

Address should be separated by commas.(Street Address,City,State,PA 17112)
Teacher Name should be first name & last name of the teacher separated by a space.
Teachers should be already existing in RunPTO prior to loading students.

Teacher Data File Format

The csv file which has the records should be in the following format:
The first row should be header and should have the columns described as below:

Column 1: Name
Column 2: Title
Column 3: Grade
Column 4: Position
Column 5: Email
Column 6: Phone
Column 7: Website
Column 8: Budget Amount

The subsequent rows will have values:
Example below
Column 1: Olivia Smith
Column 2: Mrs
Column 3: 1
Column 4: Teacher
Column 5: olivia@demoschool.com
Column 6: 7176785678
Column 7: www.example.com
Column 7: 500

A budget record will be created if budget amount is greater than 0.