Import Courses with a CSV/XLS File (Enterprise)

Importing Courses

The second tab in the Import area enables you to import courses into your school.

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 at least the following columns:

  • Course Name
  • Course Code
  • Section Name
  • Section Code or Section School Code
  • Grading Period

Course codes and Section School Codes must be unique within your entire school or district. Section codes must be unique across courses and grading periods. For example, if you have a course section with the following codes in Grading Period 1:

  • Course Code: CC101
  • Section Code: SC101

You may also have another course section with the same course and section codes the following Grading Period 2. This system allows you to have the same classes in following years without duplicating courses listed in Course Listing.

School

If there is more than one school in your Schoology account (For example, Schoology District, Schoology High School, and Schoology Middle School), you’ll see a field for the School, into which you may import users. If you do not see this field in your import area, you may ignore this section.

The school designated in this field will associate courses in your file to the selected school. Alternatively, you may add a School column in your file to associate courses to a particular school by selecting Use Import File.

Grading Period(s)

If you have selected Select Periods in the Grading Period(s) area of this screen, the grading periods listed are the grading periods you’ve created through System Settings > Grade Settings. The grading periods you select during this import will associate the courses in the file to all selected grading periods.

Alternatively, you can select Use Import File to map values in your .CSV file to the Grading Periods you have created in Schoology through System Settings> Grade Settings. 

 A Note About Grading Periods and Sub-Periods

If you have sub-periods within any of your grading periods, you only need to map your .csv file to the main grading period(s). For example, mapping your file to the year-long period will automatically associate the course with all sub-periods such as semesters and quarters. 

So, if your school's grading periods include one year-long grading period, with semester-long sub-periods, like this:

Then, in your import file, you can add only the year-long period:

And you can map the file only to the year-long grading period in the Import screen:

When the course is created via import, it will be associated with the year-long grading period AND the subperiods:

 Select File

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

Update existing records

Selecting this option will locate existing course sections by Course Code and Section Code/Section School Code, and update new information from the XLS or CSV file. Importing an empty column will not remove information from Schoology. For example, if you import a file with no course description, the update will not remove existing course descriptions from Schoology.

Note: The school and grading period with which the course is associated cannot be updated through an import. Schools and grading periods must be updated or added manually from Edit Users or Course Listing, respectively.

Step 2—Match Columns

  1. In the second step of the import process, you can match the information listed in each column to create courses in Schoology.
  2. If the first row of your XLS or CSV file contains headers, please select the First Row is Headers option for a more streamlined importing experience.
  3. Match each Schoology Field to a column in the XLS or CSV file.
  4. Once each field is matched to the appropriate column, click Preview for an overview of new courses and sections.

Import_Courses_Match_Fields.PNG

Step 3—Preview/Confirm

New courses and sections will be indicated by an orange label, new. If you see a yellow message at the top of the screen, please adjust the course and/or section information in your school account, and if needed, adjust your import file. If all information appears correct, click Confirm to complete the import process.

Powered by Zendesk