CSV File Format for SDS

You can use CSV (comma separated value) files in the SDS format to synchronize your School Information System (SIS) with Office 365. When using SDS format CSV Files for School Data Sync, the files must be appropriately formatted. This section describes the formatting requirements for use with SDS. You must have the following 6 CSV files named exactly as detailed below. To review and download sample set of CSV files in the SDS format, see the SDS GitHub Repository.

school.csv

student.csv

teacher.csv

section.csv

studentenrollments.csv

teacherroster.csv

School-Data-Sync-format-CSV-files-for-SDS-1.png

Each CSV file must contain all required fields highlighted in blue. Each CSV file may also contain any of the optional fields listed as well. The tables below list the required and optional attributes on a file by file basis. If your CSV files contain any unsupported characters, they can be replaced inline during sync, by selecting the Replace Unsupported Special Characters option within the SDS Sync Profile Setup Wizard.

School-Data-Sync-format-CSV-files-for-SDS-2.png

School-Data-Sync-format-CSV-files-for-SDS-3.png

School-Data-Sync-format-CSV-files-for-SDS-4.png

School-Data-Sync-format-CSV-files-for-SDS-5.png

School-Data-Sync-format-CSV-files-for-SDS-6.png

School-Data-Sync-format-CSV-files-for-SDS-7.png