Formatting Remind CSVs for Direct Sync

Available to administrators with a Remind School Plan or District Plan. You can learn more about these plans here.

A Direct Sync can contain up to five CSV files. Be sure to include all required fields in your CSVs. Your files should always include a full snapshot of active school data; Remind will handle necessary additions, deletions, and updates for recurring syncs.

This article covers the following topics:

  1. How to format your Remind CSV files
  2. Downloadable CSV templates
  3. Formatting FAQ

How to format your Remind CSV files

Fields highlighted in yellow are IDs used to make connections between files (i.e. enrolling a student to a class would occur with linking a student ID to a class ID). Take care to ensure that all teachers and students have unique user IDs in the respective students.csv and teachers.csv. Also, ensure all active classes and schools have unique IDs in the respective classes.csv and schools.csv.

schools.csv

The schools.csv file provides school information to Remind. This file is required for a Remind Direct Sync.

Notes

  • This CSV should include only the paid Remind schools connected to your Remind account that need to be rostered.

Screen_Shot_2018-07-19_at_10.33.35_AM.png

Downloadable template here: schools.csv

teachers.csv

The teachers.csv file provides teacher account information to Remind. This file is required to create teacher accounts.

Notes

  • If a teacher should be added to multiple schools, repeat the teacher information for each school ID. There must be a separate row for each school that the teacher belongs to. See example below.

Screen_Shot_2018-07-19_at_10.34.59_AM.png

Download template here: teachers.csv

students.csv

The students.csv file provides student account information to Remind. This file is required to create student accounts. You can include 1) student information only OR 2) student and guardian information.

Data required to create student accounts:

Screen_Shot_2018-07-25_at_10.23.42_AM.png

Download template here: students.csv

*This resource shows how students can add their student mobile numbers to their provisioned accounts after the sync.

Data required to create both student and guardian accounts:

Notes

  • If a student has multiple guardians, repeat the student information for each guardian in a new row. See example below.
  • An account will be created for every parent/guardian included in your students.csv. We strongly recommend excluding any emergency contacts as well as any individuals prohibited from contacting students.

Screen_Shot_2018-07-25_at_10.27.49_AM.pngDownload template here: students.csv

*This resource shows how students can add their student mobile numbers to their provisioned accounts after the sync.
** For a guardian account to be created in Remind, at least one contact point is required. Having two contact points (email and phone number) is not required.

classes.csv

The classes.csv file provides class information to Remind. This file is required to create classes in Remind.

Notes

  • class_name is visible to class owners and participants on Remind. The class name should be unique for each class period or section so that each class is easily identifiable (i.e. English 101 Section 3).
  • There is a limit of 100 classes per user account.
  • If a class has multiple class owners, repeat the class information for each unique teacher ID. There must be a separate row for each class owner. See example below.
  • Remind classes will be created for every section included in your files. We strongly recommend excluding any sections that should not be created in Remind.

Screen_Shot_2018-07-19_at_10.37.24_AM.png

Download template here: classes.csv

enrollments.csv

The enrollments.csv file provides enrollment information to Remind. This file is required to enroll students and guardians in classes.

Screen_Shot_2018-07-19_at_10.37.59_AM.png

Download template here: enrollments.csv

Downloadable CSV templates

  1. schools.csv
  2. teachers.csv
  3. students.csv
    students.csv
    (with guardians)
  4. classes.csv
  5. enrollments.csv

Formatting FAQ

How do I upload teachers that teach at multiple schools?

  • Repeat the teacher information in another row for every additional school IDs in the schools.csv.
  • In this example, Octavia Butler will be enrolled in two schools in Remind.

Screen_Shot_2018-07-19_at_10.39.53_AM.png

How do I format students with multiple guardians?

  • Repeat the student information in another row for every additional parent or guardian in the students.csv.
  • In this example, JK Rowling will be linked as a student to parent Peter Rowling and parent Anne Rowling in Remind. 

    Screen_Shot_2018-07-19_at_10.41.23_AM.png

How do I format a class with multiple class owners?

  • Repeat the class information in another row for every additional class owner in the classes.csv.
  • In this example, for the class English 101, there are three class owners: teachers with the IDs, teach1, teach2, teach3.

Screen_Shot_2018-07-25_at_3.26.36_PM.png