CSV V1 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. Using the SDS V1 CSV file format to ingest the data categories below enables you to light up core SDS capabilities for provisioning. It also allows you to enhance experiences for the Microsoft 365 (M365) products and features listed below.

core capabilities chart for SDS CSV V1.

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. CSV files must be in UTF-8 format. The only absolutely required fields are highlighted in green below. This also ties over to the example information on our CSV File Samples page. 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.

student.csv

teacher.csv

school.csv

section.csv

studentenrollment.csv

teacherroster.csv

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

Each CSV file must contain all required fields highlighted in green below. Each CSV file may also contain any of the optional fields listed as well. 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. This however will not remove "white spaces" which are also not valid. The tables below list the required and optional attributes on a file by file basis:

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

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

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

Note

If you are using Education Insights Premium, with the Sync to Insights option enabled on your sync profiles, and you wish to pass grade values for students and/or teachers, you must use the correct ENUM. If you do not use the correct ENUM, you will receive separate errors or warnings during the SDS for Insights validation processing. For more information, see SDS for Insights Data Health and Monitoring.

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-7.png.

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