CSV Guidelines & Tips - Securly Learn

Here are some guidelines to keep in mind when adding parents via CSV.

The name of the CSV file should be parents.csv
A header line specifying each column name is required.
The header line must include: Parent First Name, Parent Last Name, Parent Email, Student First Name, Student Last Name, Student Email
Column names are not case sensitive.
Student emails must belong to your school domain or sub-domain. Other email addresses will be rejected during file upload.
Student email ID or parent email ID cannot be the same as admin email ID.
Student email ID and guardian/parent email ID cannot be the same.
Do not include any special characters ( ", (), *, ><, /) in either the Parent First Name, Parent Last Name, Student First Name or Student Last Name columns.
Column names may be in any order.
More than one parent email or more than one student email on one line are not allowed. Each line of the CSV should establish a 1:1 mapping between student and parent.
CSVs containing more than 70,000 lines may run into issues when uploading. If this happens, please contact support@securly.com for assistance.

Refer to the examples below for details.

Correct Formatting

Header line: Parent First Name, Parent Last Name, Parent Email, Student First Name, Student Last Name, Student Email
Subsequent lines: Will, Smith, willsmith@gmail.com, Sam, Tyrell, samtyrell@schooldomain.com

Incorrect Formatting

Header line does not separate first and last names.
- Header line: Parent Name, Parent Email, Student Name, Student Email
- Subsequent lines: Will, willsmith@gmail.com, Sam, samtyrell@schooldomain.com
Admin email is provided as parent email or student email
- Header line: Parent Name, Parent Email, Student Name, Student Email
- Subsequent lines: Will,admin@schooldomain.com,Sam, samtyrell@schooldomain.com
Multiple students on one line
- Header line: Parent Name, Parent Email, Student Name, Student Email
- Subsequent lines: Will,willsmith@gmail.com,Sam,samtyrell@schooldomain.com,Jon,jonsnow@schooldomain.com

Click here to download a blank copy of the template.