SDS V2.1 CSV File Format
Core SDS capabilities and Microsoft 365 features by ingestion method
You can use CSV (comma-separated value) files in the SDS V2.1 format to sync your School Information System (SIS) with Office 365. Using the SDS V2.1 CSV file format to ingest the data categories below enables you to light up core SDS capabilities for provisioning. It also helps you enhance experiences for the Microsoft 365 products and features listed below. The SDS V2.1 CSV file format will continue to expand the data categories it supports.
Note
Current customers of CSV V2 format may continue to use until May, 2022. We recommend using the CSV V2.1 format with its additional capabilities.
When using the SDS V2.1 format, the files must be appropriately formatted. Upload all five files, named exactly as detailed below. Files and column headers are case-sensitive. CSV files must be in UTF-8 format. To review and download sample set of SDS V2.1 CSV files, see the SDS GitHub Repository.
Each CSV file must contain all required fields highlighted in green below. The fields not highlighted are optional. While the content of certain attributes may be optional, the column headers are required. The attributes with defined enumerated values as marked in the Types column have a specific set of values they support. The supported set of enumerated values for each attribute are in the next section.
*To filter on 'school' only
*If creating users
The username field requires the domain in order to be accepted by SDS. For example, cbean@domain.com.
FamilyName, givenName, and email are required for users that have guardian roles in relationships.csv.
Expect phone and sms to be in E.164. SDS provisioning won't error phone or sms if it isn't aligned with E.164. It will strip out () -, space and ., and preserve + if it's present at the front of the value provided.
*Will only sync one value with SDS Provisioning if multiple values are found on the record.
Enumerated Values Supported
In the SDS V2.1 format, there are attributes defined as enumerated values, which means you can only provide a selected set of values within the CSV files. Anything other than values specified will result in an error during sync processing. The section below defines the enumerated values supported in the SDS V2.1 Format.
The users.csv contains the “role” attribute and supports the enum values below.
| User Org Roles | ||
|---|---|---|
| Student | TeacherAssistant | Principal |
| Proctor | Staff | SpecialServices |
| Teacher | Professor | Coach |
| ItAdmin | Researcher | assistant |
| OfficeStaff | Lecturer | Chair |
| Nurse | Affiliate | Adjunct |
| OccupationalTherapist | Alumni | Substitute |
| Instructor | Advisor | Paraprofessional |
| PhysicalTherapist | Faculty | Administrator |
| SpeechTherapist | VisionTherapist | Other |
The orgs.csv contains the “type” attribute and supports the enum values below.
| Org Types | ||
|---|---|---|
| School | MinistryOfEducation | LocalAuthority |
| Department | University | Region |
| District | College | Division |
| Local | Campus | Province |
| State | AdultEducation | ResearchCenter |
| National | Municipality | Program |
| DepartmentOfEducation | AcademicTrust |
The demographics.csv contains the “birth state” attribute and supports the enum values below.
| State | ||
|---|---|---|
| AK | LA | OR |
| AL | MA | PA |
| AR | MD | PR |
| AS | ME | PW |
| AZ | MH | RI |
| CA | MI | SC |
| CO | MN | SD |
| CT | MO | TN |
| DC | MP | TX |
| DE | MS | UT |
| FL | MT | VA |
| FM | NC | VI |
| GA | ND | VT |
| GU | NE | WA |
| HI | NH | WI |
| IA | NJ | WV |
| ID | NM | WY |
| IL | NV | AA |
| IN | NY | AE |
| KS | OH | AP |
| KY | OK |
The academicSessions.csv contains the academic session “type” attribute and supports the enum values below.
| Academic Session Types | ||
|---|---|---|
| SchoolYear | Semester | Term |
The demographics.csv contains the “sex” attribute and supports the enum values below.
| Sex | ||
|---|---|---|
| Male | Female | NotSelected |
The academicSessions.csv contains the “school year” attribute and supports the enum values below.
| School Year | ||
|---|---|---|
| 2021 | 2025 | 2029 |
| 2022 | 2026 | 2030 |
| 2023 | 2027 | 2031 |
| 2024 | 2028 |
The relationships.csv contains the “relationship role” attribute and supports the enum values below.
| Relationship Roles | ||
|---|---|---|
| Parent | Guardian | Aide |
| Relative | Child | Administrator |
| Doctor | Other |
The enrollments.csv contains the “role” attribute and supports the enum values below.
| Enrollment Roles | ||
|---|---|---|
| Student | VisionTherapist | Substitute |
| Aide | Paraprofessional | Principal |
| Proctor | TeacherAssistant | SpecialServices |
| Teacher | Professor | Advisor |
| Administrator | Lecturer | Coach |
| OccupationalTherapist | Affiliate | Assistant |
| PhysicalTherapist | Adjunct | Staff |
| SpeechTherapist | Instructor |
The Courses.csv contains the academic session “subject” attribute and supports the enum values below.
| Course Subject | |
|---|---|
| 01 | English Language and Literature |
| 02 | Mathematics |
| 03 | Life and Physical Sciences |
| 04 | Social Sciences and History |
| 05 | Visual and Performing Arts |
| 07 | Religious Education and Theology |
| 08 | Physical, Health, and Safety Education |
| 09 | Military Science |
| 10 | Information Technology |
| 11 | Communication and Audio/Visual Technology |
| 12 | Business and Marketing |
| 13 | Manufacturing |
| 14 | Health Care Sciences |
| 15 | Public, Protective, and Government Service |
| 16 | Hospitality and Tourism |
| 17 | Architecture and Construction |
| 18 | Agriculture, Food, and Natural Resources |
| 19 | Human Services |
| 20 | Transportation, Distribution, and Logistics |
| 21 | Engineering and Technology |
| 22 | Miscellaneous |
| 23 | Non-Subject-Specific |
| 24 | World Languages |
The userFlags.csv contains the “flag” attribute and supports the enum values below.
| User Flags | |
|---|---|
| FreeLunch | Free Lunch |
| ReducedLunch | Reduced Lunch |
| Homeless | Homeless |
| GiftedOrTalented | Gifted or Talented |
| 504 | Section 504 Placement |
| ELL | English Language Learner |
| LEP | Limited English Proficiency |
| IEP | Special Education Services / Independent Education Plan Eligible |
The demographics.csv contains the “ethnicity” attribute and supports the enum values below.
| Ethnicity | |
|---|---|
| HispanicOrLatinoEthnicity | Hispanic or Latino ethnicity |
The demographics.csv contains the “race” attribute and supports the enum values below.
| Race | |
|---|---|
| AmericanIndianOrAlaskaNative | American Indian or Alaska Native |
| NativeHawaiianOrOtherPacificIslander | Native Hawaiian or Other Pacific Islander |
| BlackOrAfricanAmerican | Black or African American |
| DemographicRaceTwoOrMoreRaces | Designates multiple races |
| Asian | Asian |
| White | White |
The roles.csv contains the “grade” attribute and supports the enum values below.
The Courses.csv contains the academic session “grade” attribute and supports the enum values below.
| Grade | |
|---|---|
| IT | Infant/toddler |
| PR | Preschool |
| PK | Prekindergarten |
| TK | Transitional Kindergarten |
| KG | Kindergarten |
| 01 | First grade |
| 02 | Second grade |
| 03 | Third grade |
| 04 | Fourth grade |
| 05 | Fifth grade |
| 06 | Sixth grade |
| 07 | Seventh grade |
| 08 | Eighth grade |
| 09 | Ninth grade |
| 10 | Tenth grade |
| 11 | Eleventh grade |
| 12 | Twelfth grade |
| 13 | Grade 13 |
| PS | Postsecondary |
| UG | Ungraded |
| Other | Other |
| PS1 | Postsecondary freshman |
| PS2 | Postsecondary sophomore |
| PS3 | Postsecondary junior |
| PS4 | Postsecondary senior |
| Undergraduate | undergraduate |
| Graduate | graduate |
| Postgraduate | Graduate with an emphasis on research |
| Alumni | alumni |
| AdultEducation | Adult Education |