Welcome to Microsoft School Data Sync

School Data Sync (SDS) is a free service in Office 365 for Education that reads the school and roster data from a school's Student Information System (SIS). It creates Office 365 Groups for Exchange Online and SharePoint Online, class teams for Microsoft Teams and OneNote Class notebooks, school groups for Intune for Education, and rostering and SSO integration for many other third party applications. Key app integration scenarios that SDS enables include:

  • Teams for Education – SDS enables automatic Class Team creation based on SDS-created O365 Groups and Rostering.
  • OneNote Class Notebooks – SDS enables automated OneNote Class Notebook provisioning within Teams for Education. When enabled, each Class Notebook will have sections created and permissions set based on SDS class rostering data imported during sync.
  • Exchange Online and SharePoint Online –SDS creates Office 365 Groups for online messaging, file sharing, and collaboration.
  • Intune for Education – SDS creates schools-based Security Groups for granular device policy and can also provide automated bulk licensing of Intune for Education for all students and teachers synced.
  • 3rd Party Apps – SDS integrates with numerous apps within the Microsoft Store and enables Rostering and Single Sign-On (SSO) app integration.

SDS saves time for IT admins and teachers, and enables SIS vendors, app partners, and system integrators to scale, differentiate, and personalize offerings for their customers. SDS benefits many audiences.

School IT Administrators

School IT Administrators can save time by automating creation of online classrooms and users, and simplify security with a single, compliant source for user profiles and rosters that all classroom applications can use. SDS mirrors data from a school’s Student Information System (SIS) into Office 365 and Azure Active Directory, automates provisioning of online classrooms and teacher and student accounts, and enables any classroom application to access the encrypted cloud-based data through the no-cost API.


Teachers can spend less time creating classes, managing rosters and troubleshooting access to apps and shared online resources, and use that time to plan and deliver amazing lessons. It enables the easy creation of Teams for Education, OneNote Class Notebooks, Office 365 Groups for online messaging, file sharing, and collaboration, and integrates with many other education offerings and apps.

SIS Vendors

SIS Vendors can support and connect to more apps through a single, no-cost API. With SDS, they can quickly and easily provide app partners with access to student data, allowing them to focus on differentiation, not app integration.

App Partners

App Partners can provide customers with a single sign on to their applications that “just works”. SDS enables them to spend less time integrating with different SIS systems, and more time creating personalized experiences for teachers and students. The no-cost API works with multiple SIS providers, operating systems, and devices.

System Integrators

System integrators can save schools time by integrating their SIS with Office 365. They can build export/import processes for each customer, or write cloud connectors that can scale across multiple schools and districts, helping schools keep their user profiles and class rosters up to date.

To learn more about how customers are using SDS, please visit https://sds.microsoft.com.

School Data Sync Overview

Planning School Data Sync

Deploying School Data Sync with CSV files

Deploying School Data Sync with Clever File Format

Deploying School Data Sync with OneRoster CSV files

Deploying School Data Sync with Powerschool SIS API

Deploying School Data Sync with OneRoster API