CSV File Samples for School Data Sync

Here we have small examples of each CSV file for each file format. The Highlighted part is to reflect if the information is required for School Data Sync (SDS). We have sample files for SDS and UK Format CSV files available on our SDS GitHub Repository.

If you need more assistance or explanation, reach out to your Deployment Manager. If you don't have a Deployment Manager either sign-up at https://sds.microsoft.com or submit a ticket at https://aka.ms/sdssupport and choose "School Data Sync" from the drop-down.

SDS Format CSV File Samples

Note

Microsoft recommends using the ISO 8601 format for all dates fields in the SDS CSV files, in the form of YYYY-MM-DD or YYYYMMDD. SDS is planning to introduce features in coming months which will require this format within the Term Start and End Date fields noted below.

  • Students.csv > Birthdate
  • Sections.csv > Term StartDate
  • Sections.csv > Term EndDate

student.csv

student csv

teacher.csv

teacher csv

school.csv

school csv

section.csv

section csv

studentenrollment.csv

studentenrollment csv

teacherroster.csv

teacherroster csv

UK Format CSV File Samples

student.csv

student csv UK

teacher.csv

teacher csv UK

school.csv

school csv UK

section.csv

section csv UK

studentenrollment.csv

student enrollment UK

teacherroster.csv

teacherroster csv UK

Clever Format CSV File Sample

students.csv

csv-files-for-school-data-sync-Clever-1.png.

teachers.csv

csv-files-for-school-data-sync-Clever-2.png.

schools.csv

csv-files-for-school-data-sync-Clever-3.png.

sections.csv

csv-files-for-school-data-sync-Clever-4.png.

enrollments.csv

csv-files-for-school-data-sync-Clever-5.png.

Parent and Guardian CSV File Format

Note

The SIS ID field in the guardianrelationship.csv is tied to the students ID. If there is no Role associated the user will be assigned "Other" as a default role.

user.csv

csv-files-for-school-data-sync-PG-1.png.

guardianrelationship.csv

csv-files-for-school-data-sync-PG-2.png.