How to set up your files for a CSV format 1.0 sync

For administrators with Remind Hub using CSV format 1.0. If you are setting up a CSV sync for the first time, we highly recommend you use CSV format 2.0.

 

A CSV 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, and Remind will handle necessary additions, deletions, and updates for recurring syncs.

This articles covers the following topics: 


How to format your Remind CSV files

There are five Remind CSV files:

  1. schools.csv
  2. teachers.csv
  3. students.csv
  4. classes.csv
  5. enrollments.csv

Notes

All teachers and students must have a unique user ID in the respective students.csv and teachers.csv files. Also, all active classes and schools must have a unique ID in the respective classes.csv and schools.csv files.

  • All IDs below should be provided by the SIS or created by the school or district.
  • All IDs are case-sensitive.
  • There should not be any quotations in any field. 

1. schools.csv

  • The schools.csv file provides school information to Remind. This file is required for a Remind CSV sync.
  • This CSV should include only the paid Remind schools connected to your Remind account that need to be SIS-linked.
  • Downloadable template here: schools.csv

*This field is used to make connections between files (e.g. assigning a student to a school will link a student ID to a school ID). Take care to ensure that all schools have a unique ID.

Header Names

Required Field?

Notes 

school_id

YES*

The school_id must be unique across the district. A school_id can include any combination of characters and numbers. Used in the teachers.csv, students.csv, classes.csv, and enrollments.csv files to match users, classes, and enrollments to the corresponding school.

school_name

YES

Name of the school.


2. teachers.csv

  • The teachers.csv file provides teacher account information to Remind. This file is required to create teacher accounts.
  • 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.
  • We highly recommend that you share preferred language data for all teachers. Messages that teachers receive will be translated into their preferred language.
    • If you choose to not share preferred language data with Remind, the preferred language for all accounts will be blank and default to English.
    • Teachers can add a preferred language to their account at any time. When the preferred language of a teacher is manually changed by the teacher or administrator, their update will take precedence over the data in the CSV file.
  • Download template here: teachers.csv

*This field is used to make connections between files. Be sure all teachers and schools have a unique ID in the respective teachers.csv and schools.csv file.

Header Names

Required Field?

Notes 

teacher_id

YES*

ID  must be a unique and constant identifier for each teacher. Teacher ID should not match a student ID. ID can include any combination of characters and numbers. It must be unique across the school. It will be used in the classes.csv to match classes with the corresponding teacher.

school_id

YES*

Must correspond to a school ID  provided in the schools.csv file. A teacher can be at multiple schools. The teacher would need a separate row per school for each school_id.

teacher_first_name

YES

Teacher’s first name.

teacher_last_name

YES

Teacher’s last name.

teacher_email

YES

Teacher’s email.

teacher_mobile_phone

NO

Teacher’s mobile number. Phone numbers can be in most formats, including with/without parentheses around the area code, with/without hyphens, and with/without international code.

preferred_language

NO

Recommended: User’s preferred language for message. The only values we accept for preferred_language are any two-letter ISO-639-1 or BCP-47 code, or three-letter ISO-639-2 code you can obtain from this list here


3. students.csv

  • The students.csv file provides student account information to Remind.
  • 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 account to be created in Remind, at least one contact point (mobile phone number or email address) is required.
  • Students and parents cannot share contact information. Email and phone devices must be unique to each user. 
  • We highly recommend that you share preferred language data for all students and parents. Messages that students and parents receive will be translated into their preferred language.
    • If you choose to not share preferred language data with Remind, the preferred language for all accounts will be blank and default to English.
    • Students and parents can add a preferred language to their account at any time. When the preferred language of a student or parent is manually changed by the user, teacher or administrator, their update will take precedence over the data in the CSV file.
  • The following resource shows how students can add their student mobile numbers to their provisioned accounts after the sync: Add mobile numbers to SIS rostered accounts.
  • Download template here: students.csv

*This field is used to make connections between files. Double check that students have a unique user ID in the students.csv file, and schools have unique IDs in the schools.csv file.

Data required to create student and guardian accounts:

Header Names

Required Field?

Notes 

student_id

YES*

ID must be a unique and constant identifier for each student. No student_id can match a teacher_id. IDs can include any combination of characters and numbers. Must be unique across the district. Will be used in the enrollments.csv file to match the student with their corresponding classes.

school_id

YES*

Must correspond to a school ID provided in the school.csv file.

student_first_name

YES

Student’s first name. 

student_last_name

YES

Student’s last name.

dob

YES

Student date of birth. MM/DD/YYYY or YYYY/MM/DD format.

grade

NO

Recommended: Student grade level. For students only, enter the student's grade. Permitted grade values are PK, KG, 01 through 12, and Other. A student can only be associated with one grade. 

Each student can only be associated with one grade.

student_email

NO

Student’s email.

student_phone

NO

Student’s mobile number.  Phone number must be unique. Student phone number and the guardian phone number must not be the same. Phone numbers can be in most formats, including with/without brackets around the area code, with/without hyphens, and with/without international code.

student_number

NO

Recommended: Student number. An optional field for a student ID that the student has access to if different from the student_id field.

If student_number is not provided, we will default to
using the user's student_id.

preferred_language

NO

Recommended: User’s preferred language for message. The only values we accept for preferred_language are any two-letter ISO-639-1 or BCP-47 code, or three-letter ISO-639-2 code you can obtain from this list here

guardian_first_name

NO

Guardian’s first name.

guardian_last_name

NO

Guardian’s last name.

guardian_email

NO

Guardian’s email.

guardian_phone

NO

Guardian mobile number. Phone number must be unique. The guardian phone number and student phone number must not be the same. Phone numbers can be in most formats, including with/without brackets around the area code, with/without hyphens, and with/without international code. 

guardian_preferred_language

NO

Recommended: User’s preferred language for message. The only values we accept for guardian_language are any two-letter ISO-639-1 or BCP-47 code, or three-letter ISO-639-2 code you can obtain from this list here


4. classes.csv

  • The classes.csv file provides class information to Remind. This file is required to create classes in Remind.
  • 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). The class_name and class_id cannot be the same.
  • There is a limit of 100 classes per user account. The limit does not include archived classes.
  • 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.
  • Download template here: classes.csv

*This field is used to make connections between files. Ensure all active classes and schools have unique IDs in the respective classes.csv and schools.csv files. Also, make sure that all teachers have unique user IDs in the teachers.csv files.

Header Names

Required Field?

Notes 

class_id

YES*

Class ID must be a unique and constant identifier for each class. Class ID can include any combination of characters and numbers. Must be unique across the district. Will be used in the enrollments.csv file to match an individual class to the corresponding students.

teacher_id

YES*

Must correspond to a teacher ID provided in the teachers.csv. You can add multiple class co-owners to each class.

school_id

YES*

The school ID. Must correspond to a school ID provided in the schools.csv file.

class_name

YES

Class name should be unique for each class period. 


5. enrollments.csv

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

Download template here: enrollments.csv

*This field is used to make connections between files. Be sure that each class, student, and school ID is unique in the respective classes.csv, students.csv, and schools.csv file.

Header Names

Required Field?

Notes 

class_id

YES*

Must correspond to a class ID provided in the classes.csv file.

student_id

YES*

Must correspond to a student ID provided in the students.csv file.

school_id

YES*

Must correspond to a school ID provided in the schools.csv file.


Downloadable CSV templates

  1. schools.csv
  2. teachers.csv
  3. students.csv
  4. classes.csv
  5. enrollments.csv

Formatting FAQ

Highlighted information is unique in each cell. All other information is repeated.

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:

teacher_id

teacher_first_name

teacher_last_name

teacher_email

school_id

teacher_mobile _phone

teach1

Octavia

Butler

kindred@hotmail.com

school1

 

teach1

Octavia

Butler

kindred@hotmail.com

school2 

 

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.

student_id

school_id

student_first_name

student_last_name

dob

guardian_first_name

stu123

school1

JK

Rowling

7/31/1965

Peter

stu123

school1

JK

Rowling

7/31/1965

Anne 

guardian_last_name

guardian _phone

guardian _email

Rowling

111-111-1111

 

Rowling

999-999-9999

anne23@gmail.com

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. The maximum number of owners you can assign per class is twenty. 

In this example, for the class English 101, there are three class owners: teachers with the IDs, teach1, teach2, teach3.

class_id

class_name

teacher_id

school_id

class1

English 101

teach1

school1

class1

English 101

teach2

school1

class1

English 101

teach3

school1

 

Return to top