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 article covers the following topics:
How to format your Remind CSV files
There are five Remind CSV files:
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 |
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.
- A class name should not exceed 255 characters including spaces
- 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. The class name should not exceed 255 characters including spaces |
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
Formatting FAQ
Highlighted information is unique in each cell. All other information is repeated.
How do I upload teachers and/or students 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 |
Repeat the student information in another row for every additional school IDs in the students.csv.
In this example, JK Rowling will be enrolled in two schools in Remind:
student_id |
school_id |
student_first_name |
student_last_name |
dob |
guardian_first_name |
stu123 |
school_id1 |
JK |
Rowling |
7/31/1965 |
Peter |
stu123 |
school_id2 |
JK |
Rowling |
7/31/1965 |
Anne |
guardian_last_name |
|
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 |
How do I upload people to schools without rostering classes?
You can roster people to schools without completing the classes.csv or enrollments.csv file. Simply complete the required fields in the teachers.csv or students.csv file according to the participant's role. You will also need to make sure to complete the information in the schools.csv file. Once you're done, upload all five files as outlined in our CSV sync via SFTP Overview article. Please note that the classes.csv and enrollments.csv files must have the header rows, but do not require any other information in them.
Can I create staff accounts?
You cannot add the staff role to a user's account via CSV 1.0 at this time.