Format Remind CSVs for direct sync

Available to administrators with a School and District plan.

A direct sync can contain up to five Remind 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 (e.g., enrolling a student to a class would link 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 files. Also, ensure all active classes and schools have unique IDs in the respective classes.csv and schools.csv files.

There are the Remind CSV files:

  • schools.csv
  • teachers.csv
  • students.csv
  • classes.csv
  • enrollments.csv

schools.csv

Downloadable template here: 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-10-16_at_3.18.48_PM.png

teachers.csv

Download template here: 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 in Formatting FAQ.

Screen_Shot_2018-10-16_at_3.18.57_PM.png

students.csv

Download template here: students.csv

The students.csv file provides student account information to Remind.

Data required to create student and guardian accounts:

Notes:

  • If a student has multiple guardians, repeat the student information for each guardian in a new row. See example in Formatting FAQ.
  • An account will be created for every parent/guardian included in your students.csv file. We strongly recommend excluding any emergency contacts as well as any individuals prohibited from contacting students.
  • For a parent or guardian accounts to be created in Remind, at least one contact point (mobile phone number or email address) is required.

Screen_Shot_2018-11-02_at_11.23.45_AM.png

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

classes.csv

Download template here: 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 (e.g., 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 in Formatting FAQ.
  • 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-10-16_at_3.21.39_PM.png

enrollments.csv

Download template here: 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-10-16_at_3.22.09_PM.png

Downloadable CSV templates

  1. schools.csv
  2. teachers.csv
  3. students.csv
  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