Skip to content

Import children or staff in bulk

Bulk Import is available to DSL, Deputy DSL, Headteacher and SAEL Administrator roles. Prepare a clean spreadsheet and decide which setting should receive the information. The supported workflow is review-before-save: SAEL maps the columns, checks the rows and lets you inspect the results before confirming.

  1. Open Command → Organisation → Data & imports.
  2. Select Start a bulk import.
  3. If you are a SAEL Administrator, choose the target setting in the setting picker before uploading. Check the setting name and type shown in the working-setting banner. Use Change setting if you selected the wrong one.
  4. A setting-level DSL/Deputy DSL/Headteacher account is already scoped to its own setting.
  1. Select one of the import tabs: Children, Staff, Contacts, Injuries or Concerns.
  2. If the selected tab offers more than one sheet/entity type, open Which sheet are you importing? and choose the correct one.
  3. Follow the recommended order when linked sheets are involved: start with the primary sheet, then import related sheets that refer to SAEL numbers or legacy references.
  1. Choose your CSV, Excel or JSON file in the uploader.

Upload step for a Contacts import showing the empty drop zone for a CSV, Excel or JSON file

  1. Review the fields SAEL detects and map each source column to the correct SAEL field. Do not map a column based only on a similar-looking heading; check what the values actually contain.

Column mapping step showing how to match spreadsheet columns to SAEL fields for Contacts import

  1. Review required fields and any rows SAEL marks as incomplete, duplicated or invalid.
  2. Correct the source spreadsheet where appropriate, then upload/review again. Do not force questionable data through merely to complete the import.
  3. Inspect the full review/preview. Check the target setting, record type, row counts and any warnings.

Bulk Import review step for a Children import showing 156 rows flagged with validation errors such as a missing date of birth, with the Upload, Map, Review, Import and Done progress steps above

  1. Only when the preview is correct, select the final confirm/import action.
  2. Wait for the result and inspect the imported records in their normal SAEL areas.

Nothing should be saved merely because a file has been uploaded or its columns mapped. The final confirmation is the point at which you authorise the import. Keep the original spreadsheet securely and follow your data-protection procedures for temporary working files.