Clever format CSV files for SDS

You can use CSV (comma separated value) files in the Clever format to synchronize your School Information System (SIS) with Office 365. When using Clever 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 5 CSV files named exactly as detailed below. The admins.csv is not accepted for use in SDS.

schools.csv

students.csv

teachers.csv

sections.csv

enrollments.csv

Clever-format-CSV-files-for-SDS-1.png

Each CSV file must contain all required fields highlighted in blue. Each CSV may also contain any of the optional fields listed. The tables below list the required and optional attributes on a file by file basis:

Clever-format-CSV-files-for-SDS-2.png

Clever-format-CSV-files-for-SDS-3.png

Clever-format-CSV-files-for-SDS-4.png

Clever-format-CSV-files-for-SDS-5.png

Clever-format-CSV-files-for-SDS-6.png