Clear search
Close search
Google apps
Main menu

Create CSV files

You create comma-separated values (CSV) files from your school information system. Google School Directory Sync (SDS) then synchronizes the CSV files with Classroom and G Suite for Education.

CSV file format

You name and format the files according to IMS OneRosterTM 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 School Directory Sync.

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)


Note: The files must have these exact names for SDS to import them.

When you configure the settings in Configuration Manager, you’ll enter a link from the CSV files to SDS.

Number of users—Confirm you're importing the correct number of users. If you import more users than you have G Suite for Education licenses for, you might get errors during synchronization. For details, see Licences.

Was this article helpful?
How can we improve it?
Sign in to your account

Get account-specific help by signing in with your G Suite account email address, or learn how to get started with G Suite.