You create comma-separated values (CSV) files so you can synchronize data from your school information system to Classroom and Google Workspace for Education. When you set up your sync, you’ll enter a link from Google School Directory Sync (SDS) to the CSV files.
CSV file format
- You name and format the files according to IMS OneRoster v1.0 specifications. You must keep all the files in the same directory as SDS.
- The OneRoster standard includes 7 files, but only 5 are required for SDS.
- The files must have these exact names for SDS to import them.
- Make sure you're importing the correct number of users. If you import more users than you have Google Workspace for Education licenses for, you might get errors during synchronization. For details, see Licences.
- When configuring the users.csv file, use your school's primary domain for teacher and student email addresses. SDS does not support secondary domains.
Note: The "/" character isn't allowed in names of organizational units. If you use Google Cloud Directory Sync, Google Workspace Admin SDK, or School Directory Sync to create or rename an organizational unit, the "/" automatically replaced automatically by "_" (underscore).
File | Required for School Directory Sync? |
---|---|
orgs.csv | Yes |
users.csv | Yes |
courses.csv | Yes |
classes.csv | Yes |
enrollments.csv | Yes |
academicSessions.csv | No (will be ignored if included) |
demographics.csv | No (will be ignored if included) |
Next steps
Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.