Schoology Learning
Schoology Learning
Breadcrumbs

Import schools with a CSV or XLS file

Import schools into Schoology using a CSV or XLS file. School imports can create new schools or update existing schools using a School Code.

Import file requirements

The XLS or CSV file for import must contain the required fields.

Field

Requirement

Description

Name

Required

Name of the school.

Address Line 1

Optional

Primary street address for the school.

Address Line 2

Optional

Additional address information for the school.

City

Optional

City associated with the school.

State

Optional

State or province associated with the school.

Country

Optional

Country associated with the school.

Zip Code

Optional

Postal code associated with the school.

Phone

Optional

School phone number.

Website

Optional

School website address.

School Code

Optional


School import considerations

Update existing schools

You can create new schools or update existing schools during an import.

Use one of the following options:

  • Don't update existing schools to create new school records from the import file.

  • Update existing schools using School Code to update existing schools by matching the School Code in the import file to the School Code in Schoology.

To update an existing school, the import file must include the correct School Code.

Import course enrollments

Select file

  1. Select Tools and choose School Management.

  2. Select Import.

  3. Select Schools.

  4. Upload the CSV or XLS file.

  5. Select an updating option.

  6. Select Continue.

Match columns

  1. Match each Schoology field to the corresponding column in the import file.

  2. Verify the mappings using the preview.

  3. Select Preview

Preview and confirm

Review the import preview before running the import.

The preview displays:

  • Created Schools for new schools that will be added.

  • Updated Schools for existing schools that will be updated

  • Errors for issues that must be reviewed.

If the information is correct, select Run to complete the import.

Status log

After the import runs, use Status Log to:

  • Monitor import progress.

  • Review import messages.

  • Download the original import CSV file.