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.

students.csv

teachers.csv

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

Note that certain student attributes have recently been deprecated. Please see article on Simplifying Student Schema for more details.

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

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