Import Course Enrollment with a CSV/XLS File (Enterprise)

Importing Course Enrollments

Provision users into courses at your school from the Course Enrollments tab on the Import page.

Note: Schoology is optimized to process imports and exports (auto or manual) most quickly between the hours of 7pm to 6am Eastern Time (ET) from Monday to Sunday. Imports or exports that are run outside of this window will be slower to complete. Schoology strongly recommends performing or scheduling all imports, exports, and bulk deletions during this time frame, including manual imports as well as scheduled auto-imports, for optimal performance.

Step 1—Select file

The XLS or CSV file for import must contain the following columns:

  • Course Code
  • Section Code or Section School Code
  • User Unique ID

Additionally:

  • Enrollment Type is a required column if you select Use Import File in the Enrollment Type drop-down menu.
  • Grading Periods is a required column if you select Use Import File above the Grading Period(s) menu.

Tip: You may export a CSV of course sections from the Export area for a list of courses in your school with both a course code and section code/section school code.

Enrollment Type

Use the Enrollment Type drop-down menu to determine whether the users in your spreadsheet are members (student) or admins (teacher) of a course. If your spreadsheet only has one type of user, you can select that type in the menu. For example, if the spreadsheet only has students, select Member in the menu.

If, however, your spreadsheet has users who will be assigned different enrollment types in Schoology, select Use Import File in the menu. The Schoology Enrollment Types (Admin or Member) display in the left column; enter the equivalent type from your spreadsheet in the fields in the CSV Value column.

In this example, Admins and Members are designated as 1 and 2, respectively, in the spreadsheet.

Import_Course_Enrollment_File.PNG

Grading Period(s)

Select the grading period(s) with which the course sections listed in the import file are associated. Two options are available: 

  • Click Select Periods to choose from a list of your Schoology grading periods. In the following example, the selected enrollment types are applied to the three selected grading periods.

  • Click Use Import File to match your Schoology grading periods to their equivalent values in your import file. In the following example, the existing Schoology grading periods display in the left column, and each equivalent from the spreadsheet has been added in the fields in the right column.

Tip: You may export a CSV of course sections from the Export area for a list of courses associated with a particular grading period. Please note that users are enrolled in course sections, and course sections are associated with grading periods. If a section is associated with multiple grading periods, enrolling a user in that section will enroll that user in all grading periods associated with the section. To create unique rosters by grading period(s), please create course sections associated with appropriate grading periods. See Importing Courses above for more information.

Clear Enrollments Not in File

Selecting this option will locate existing course sections by Course Code and Section Code/Section School Code, clear existing enrollment in the course, and replace admin and members with users from the XLS or CSV file. Adding the same user back into the course will restore content created by that user in the course.

Tip: To clear only the teacher in the course, import a file for the Enrollment Type, Admin. To clear only the students of the course, import a file for the Enrollment Type, Member.

Select File

Please select the XLS or CSV file that contains the enrollment information for import.

Step 2—Match Columns

In the second step of the import process, match the information from a Schoology Field to each column in the spreadsheet to provision users into course sections in Schoology.

Confirm the match by verifying the Preview columns list the correct information.

Step 3—Preview/Confirm

If you see a yellow message at the top of the screen, please adjust the information selected in Step 1 of the import process, and if needed, adjust your import file. If all information appears correct, click Run to complete the import process.

Import_Course_Enrollment_Preview.PNG

Powered by Zendesk