Import schools with a CSV/XLS file

Import schools into your account from the Schools tab on the Import page.

1. Select the file.

   • The XLS or CSV file for import must include the Name column.

   • The following additional columns may also be included to add further information to the schools you import:

     • Address Line 1

     • Address Line 2

     • City

     • State

     • Country

     • Zip Code

     • Phone

     • Website

     • School Code

2. Click Attach File and browse to select the spreadsheet on your computer.

3. In the Updating section, select:

   1. Don't update existing Schools: create new entries for each School in the spreadsheet.

   2. Update existing Schools using School Code: overwrite the information for a school already in your account. Match the schools using the School Code column.

4. Click Continue to add the Schools in the file to your account.

5. Match columns. Match the information from a Schoology Field to each column in the spreadsheet to create your Schools.

6. Preview and confirm. New and updated schools display in the Created Schools and Updated Schools fields, respectively. Any errors that occurred during the import display in the Errors field.

   • Click Status Log if all information appears correct.

   • Click Run to complete the import process.

7. After running the import, click Status Log to monitor the import process, view any messages from the import, or download the original import CSV file.

8. Administering schools. Review the Administering Multiple Schools help topic for additional information.