CSV Guidelines & Tips

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.