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. This section describes the formatting requirements for use with SDS. 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 5 CSV files named exactly as detailed below. The admins.csv is not accepted for use in SDS.
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: