ClassSync is a solution that integrates and manages Google Workspace for Education and Microsoft 365. Based on teacher and student rosters, it automatically creates class-based groups in Google Workspace and Microsoft 365, allowing easy group selection and user addition in Google Classroom and Microsoft Teams. It also supports integration with https://sds.edu.cloud.microsoft by providing functionality to generate School Data Sync CSV v2.1 files. The app includes a Google Classroom Sync feature that automates the creation of Classroom classes. Managing educational data has never been easier.
Simplify transitions for teachers moving between schools.
When a school transfer occurs due to personnel changes, ClassSync provides a secure file transfer feature that seamlessly migrates all files stored in OneDrive, Teams Class Materials, and Google Drive from the previous school to the new school’s OneDrive — without temporarily storing any data on external cloud services.
Drive File Transfers Overview
Source
Destination
Contents Migrated
OneDrive (Old School)
OneDrive (New School)
Personal files, teaching materials
Teams Class Materials
OneDrive (New School)
Class notebooks, assignments, shared resources
Google Drive
OneDrive (New School)
Docs, Sheets, Slides, folders
1-1. OneDrive to OneDrive
1-2. Teams Drive to OneDrive
💡 To view files stored in a team owned by the user, administrator approval is required. When a tenant administrator logs into the drive source, an approval page will be displayed. Once the approval is completed, the user will be able to view and copy files stored in the team they own.
1-3. Google Drive to OneDrive
2. View Destination List
Compare the source list and the destination list, and if the file name and file size are the same, deselect the source.
class groups for both Microsoft Teams and Google Classroom
ClassSync automatically creates class-based groups in Google Workspace and Microsoft 365 using teacher and student rosters. These groups can then be selected in Google Classroom and Microsoft Teams to quickly add users, streamlining collaboration and management for educational institutions.
All data is stored locally on the device, ensuring maximum privacy and compliance.
We do not store your roster data on our servers. All rosters managed through the ClassSync app are processed and stored locally on your device. We take your privacy very seriously and ensure that it is never misused. Learn more
Teacher Roster
This screen provides functionality for managing the teacher roster. You can view and manage basic information such as each teacher’s name, email ID (OneID), subject, and assigned class. The email ID (OneID) is used for Google Workspace and Microsoft 365 accounts. Additionally, class information is utilized for creating class groups in both platforms and is also used when generating student rosters in bulk based on class details and student counts. By using the Google ID Match and Microsoft ID Match features, you can retrieve user IDs from the cloud (Google Workspace, Microsoft 365) that match the names in the teacher roster and display them on this screen.
Student Roster
This screen provides functionality for managing the student roster. You can view and manage information such as student ID, name, email ID (OneID), assigned class, and grade level. It includes the default input fields for School Data Sync (see: Default list of values – School Data Sync | Microsoft Learn). The student roster serves as key data for Google Workspace and Microsoft 365 accounts, class group creation, and Classroom/Teams synchronization. Additionally, by using the Google ID Match and Microsoft ID Match features, you can retrieve user IDs from the cloud (Google Workspace, Microsoft 365) that match the names in the student roster and display them on this screen.
Class Roster : Manage rosters based on established classes and courses
This screen manages rosters based on the established classes and courses, with class information mapped from the teacher roster. It is utilized for subject-level data mapping when generating Microsoft SDS CSV files. Additionally, the roster is used for synchronizing Microsoft Teams class teams and Google Classroom classes.
Enrollee Roster : Manage rosters based on established courses and enrolled students
This screen manages rosters based on the established courses and the students enrolled in them. The roster is utilized for subject-level data mapping when generating Microsoft SDS CSV files and is also used for synchronizing Microsoft Teams class teams and Google Classroom classes.
SDS V2.1 CSV File Format (Save to the folder selected by the user)
This screen provides functionality for generating CSV files in the Microsoft School Data Sync (SDS) v2.1 format. In the upper section, you can configure the school year, school name, school ID, domain, and academic session dates (start and end). There are options to add subject teachers directly to Teams class teams and to include class rosters or enrollee rosters. After completing the settings, clicking the Create SDS Files button generates CSV files compliant with SDS standards. The lower section displays the list of generated files, which include: orgs.csv, users.csv, roles.csv, classes.csv, enrollments.csv, courses.csv, academicSessions.csv , relationships.csv, demographics.csv, and userflags.csv. A search bar on the right allows you to quickly locate specific files.
Maintain a single roster to manage both platforms effortlessly.
ClassSync enables schools to manage teacher, student, and class rosters internally, automatically generating Microsoft SDS CSV v2.1 files. These files can be uploaded to Microsoft School Data Sync to synchronize Teams class teams. Additionally, the Google Classroom Sync feature connects to the SDS CSV v2.1 files as a data source to synchronize classes in Google Classroom. Administrators can view class lists, archive or delete classes—all through an intuitive interface.
1. Support for Microsoft School Data Sync (SDS) CSV v2.1 File Format
1-1. Create School Data CSV v2.1 Format Files
1-2. Microsoft School Data Sync Upload SDS CSV v2.1 Files
2. Create Google Classroom Classes Using SDS CSV v2.1 File Format
Google Classroom Sync is a feature that automatically creates and manages Google Classrooms based on your school’s class data. By loading SDS (School Data Sync) files, you can review class information and create or update Classrooms with just one click. It also allows you to archive or delete existing Classrooms and export data to CSV for efficient management.
Key Features:
Automatically create and sync Google Classrooms by class
Integrates with SDS (School Data Sync) for accurate data mapping
Enter the following items in the ClassSync app settings screen: District ID, District Name, School ID, School Name, Start Grade, and End Grade.
Only users who have either Global Administrator or User Administrator permissions and are assigned a teacher license can log in and complete the initial setup in ClassSync.
It is recommended to use official NCES data for accuracy. However, the app does not validate the values entered for NCES IDs or school names, so users must ensure correctness manually. When you click the “Register to use the school domain” button, the entered settings are saved.
Code Example
District ID : 2900017 / District Name : Academie Lafayette
School ID : 290001703331 / School Name : Academie Lafayette Armour Ims
Start Grade : 06 / End Grade : 08
Enter initial password
First-Time Setup: Required Values
Academic Year
Example: 2025
Used to organize data by school year.
District ID & Name
Example: CA123 – Los Angeles Unified School District
Identifies the school district for SDS and reporting.
School ID & Name
Example: 0622710 – Lincoln High School
school code and official name for accurate mapping.
Grade Level
Example: 9th Grade, 10th Grade, etc.
Used for grouping and class assignments.
Administrator Domain
Example: lincolnhs.k12.ca.us
This information is required for configuring the user’s UPN (User Principal Name), and the domain included in the administrator’s UPN will be registered automatically.
Initial User Password
Example: Welcome2025!
Default password for first login (users should change it after login).
Note: For new users created via SDS, the password set in the SDS configuration screen will be applied.
ID Prefix for Teachers and Students
Example: tch_ for teachers, stu_ for students
Microsoft School Data Sync
In the school data list creation feature, the entered values are used when generating the Microsoft School Data Sync v2.1 CSV Files
Creating a learning environment that enriches students’ experiences
ClassSync is a unified management solution for educational Google Workspace and Microsoft 365. It automatically creates class-based groups and enables easy user additions in Google Classroom and Microsoft Teams. With support for SDS integration through School Data Sync CSV v2.1 file generation and automated class creation via Google Classroom Sync, managing educational data becomes simpler than ever.
Create Cloud OneIDs : Manage Google Workspace and Microsoft 365 Education Accounts Using a Single School ID Data Source
App Access & Role-Based Features
Users with Global Administrator permissions and a teacher license can:
Complete the initial setup of ClassSync
Register and manage school domain settings
Manage user accounts and group provisioning
Generate and upload SDS CSV v2.1 files
Manage integration with Microsoft Teams and Google Classroom
Users with User Administrator permissions and a teacher license can:
Complete the initial setup of ClassSync
Register and manage school domain settings (requires global administrator approval)
Manage user accounts
All users can:
No initial setup is required to use the file copy feature
ClassSync provides a file transfer feature for teachers and students who are moving to a different school. This allows them to securely copy and transfer their teaching materials, learning resources, and class-related files to their new school environment, ensuring continuity and minimizing setup time.
