Formatting files for a CSV 1.0 sync
For administrators with Remind Hub using CSV format 1.0.
Follow the instructions below to properly format the 5 CSV files required every time you share rostering data with Remind via SFTP.
This article contains the following sections:
- Tips to avoid common problems
- How to format your CSV 1.0 Files
- Downloadable CSV templates
- Formatting FAQs
Remind will handle necessary updates that occur during a maintenance sync.
Known Student Information Systems (SIS) that are compatible with this format.
- Infinite Campus
Tips to avoid common problems
Some files may require data while others don't, such as the classes.csv and enrollments.csv. You still need to upload all five files with the correct headers. Please be sure to upload your files at least once every 90 days.
|
How to format your Remind CSV files
1. schools.csv
This required file establishes school_ids which are used in the other rostering files to associate users and classes to the correct school.
- The schools.csv file provides school information to Remind.
- This CSV should only include paid Remind schools connected to your Remind Hub account that will need to be SIS-linked.
- Downloadable template here: schools.csv
CSV Headers
school_id (data required)
- A unique ID used in subsequent CSV files to match users and classes to schools.
- There must be a unique ID for every school in the district; the file cannot contain multiple schools with the same ID.
- Can include any combination of characters and numbers.
school_name (data required)
- Name of the school, used internally to match the data with the correct school in your Remind Hub.
- Can include any combination of characters and numbers. Note that the name cannot exceed 60 characters.
2. teachers.csv
The teachers.csv file provides teacher account information to Remind. This file is required to create teacher accounts.
- All teachers listed in this file must have a valid email address included.
- 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 the example in Formatting FAQ.
- We highly recommend that you share preferred language data for all teachers.
- Preferred language will automatically translate any message to the user's preferred language.
- If preferred language data is not shared with Remind, all accounts will default to English,
- Teachers can add a preferred language to their account at any time..
- Download template here: teachers.csv
CSV Headers
teacher_id (data required)
- ID must be a unique and constant identifier for each teacher.
- Teacher ID should not match a student ID.
- Can include any combination of characters and numbers.
- It must be unique across the schools
- It will be used in the classes.csv to match classes with the corresponding teacher
school_id (data required)
- Must match to a school_id 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.
- If a teacher has classes at multiple schools, be sure to assign them to each school they own a class in.
teacher_first_name (data required)
- Teacher’s first name.
teacher_last_name (data required)
- Teacher’s last name.
teacher_email (data required)
- Teacher’s email.
- Teacher’s cannot share email addresses.
teacher_mobile_phone
- Teacher’s mobile number.
- Phone numbers can be in most formats, including with/without parentheses around the area code, with/without hyphens
Preferred_language (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 or ISO-639-3 code you can obtain from this list here.
- If this is left blank, then the default language is set to English.
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 the example in Formatting FAQ.
- Students and parents cannot share contact information. Email and phone devices must be unique to each user.
- An account will be created for every parent/guardian included in your students.csv file, if they have a unique contact point. 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 unique contact point (mobile phone number or email address) is required.
- 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.
- We strongly caution against rostering student phone numbers as these are often shared with their guardians. Instead, use the following resource to guide students on how to add their student mobile numbers to their provisioned accounts after the sync: Add mobile numbers to SIS rostered accounts.
Download template here: students.csv
CSV Headers
student_id (data required)
- 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
school_id (data required)
- Must correspond to a school ID provided in the school.csv file
student_first_name (data required)
- Student’s first name.
student_last_name (data required)
- Student’s last name.
dob (data required)
- Student date of birth.
- MM/DD/YYYY or YYYY/MM/DD format.
Grade (recommended)
- Student grade level.
- Permitted grade values are PK, KG, 01 through 12, and Other.
- A student can only be associated with one grade.
- Required for grade level messaging.
student_email
- Student’s email.
- An account with no contact information will be created in order to connect parents to classes.
student_phone
- Student’s mobile number.
- Phone number must be unique.
- Phone numbers can be in most formats, including with/without brackets around the area code, with/without hyphens, and with/without international code.
- Student phone number and the guardian phone number must not be the same.
- Only recommended for Higher Education.
student_number (recommended)
- Student number
- 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 (recommended)
- User’s preferred language for messages.
- 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
- Guardian’s first name.
guardian_last_name
- Guardian’s last name.
guardian_email
- Guardian’s email.
Guardian_phone
- Guardian mobile number.
- Phone number must be unique.
- Phone numbers can be in most formats, including with/without brackets around the area code, with/without hyphens, and with/without international code.
- The guardian's phone number and student's phone number must not be the same.
guardian_preferred_language (recommended)
- User’s preferred language for messages.
- 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 the 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 (e.g. Lunch, Study hall).
- Download template here: classes.csv
CSV Headers
class_id (data required)
- 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.
- We caution against reusing the same Class ID when rolling over to a new school year.
teacher_id (data required)
- Must correspond to a teacher ID provided in the teachers.csv
- You can add multiple class co-owners to each class.
school_id (data required)
- The school ID.
- Must correspond to a school ID provided in the schools.csv file.
class_name (data required)
- Class names should be unique for each class period.
- Class name length should not exceed 60 characters.
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
CSV Headers
class_id (data required)
- Must correspond to a class ID provided in the classes.csv file
student_id (data required)
- Must correspond to a student ID provided in the students.csv file.
school_id (data required)
- 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 are in 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:
- Repeat the teacher information in another row for every additional school IDs in the schools.csv.
| 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 |
| Rowling |
- 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.
- Repeat the student information in another row for every additional parent or guardian in the students.csv.
| 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.
- 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.
| 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 data 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.