Microsoft School Data Sync CSV format

Many student information systems offer a Microsoft School Data Sync (SDS) export of teacher, student and class setup. These files are usually used to update Microsoft Teams, but Literatu can also use these files to set up your classes, teachers and students.

Student information systems that offer SDS exports include Synergetic, Canvas, Compass and many more. For a full list, please go to https://sds.microsoft.com/ and click ‘Supported SISes’ on the top menu.

Please export the following files to use in the import.

• Section.csv

• Student.csv

• Teacher.csv

• Studentenrolment.csv

• Teacherroster.csv

​Click here for more information about School Data Sync export format.

When extracting your CSV please make sure you include the fields marked Yes in the 'Required?' field AND the fields marked "Yes (only if creating users)"

If the username is not an email address, please include the secondary email.

Once the files are exported they can be uploaded to Literatu:

1. Open a web browser and go to www.literatu.com.

2. Login with your community administrator account.

3. Click the hamburger menu at the top left of the screen, and select Manage -> Import school data.

4. Choose Microsoft School Data Sync format as the import format

5. On the import screen, either drag-and-drop your file(s) onto the upload frame, or click ‘Browse files’ to locate them.

6. Click Next to proceed. The importer will validate your file(s). If any issues are encountered, you will see a message and the import will not proceed. Please send your files to [e-mail] in this case.

7. If the format is OK you will see a summary & detailed view of the data we are about to import. Please check this screen and make sure the information is correct. You can cancel at this point if needed.

8. Click ‘Import data’ to start the import.

9. You will see a confirmation when done.