CSV File Samples for School Data Sync

Here we have small examples of each CSV file for each file format. Note that 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 additional assistance or explanation please reach out to your Deployment Manager. If you do not have a Deployment Manager please either sign up at https://sds.microsoft.com or submit a ticket at http://aka.ms/sdssupport and choose "School Data Sync" from the drop down.

SDS Format CSV File Samples

student.csv

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

teacher.csv

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

school.csv

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

section.csv

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

studentenrollment.csv

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

teacherroster.csv

csv-files-for-school-data-sync-SDS-6.png

UK Format CSV File Samples

student.csv

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

teacher.csv

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

school.csv

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

section.csv

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

studentenrollment.csv

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

teacherroster.csv

csv-files-for-school-data-sync-UK-6.png

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