How to import learners in bulk

How to import learners in bulk

Bulk importing allows schools to enrol large numbers of learners simultaneously using an Excel template. This is particularly useful at the start of a new year or when migrating from another system.

My School > People > Learners > Learners > Learners: Import Learners

How do I import learners in bulk?

  1. Navigate to Import Learners.

  2. Click Download Template to get the Excel import file.

  3. Complete the required fields in the template. Use country codes without the "+" symbol (e.g., 27 for South Africa).

  4. Save the completed file and upload it using the Import button.

  5. Open the Imported Data tab to review results. Errors are highlighted by colour code — correct any flagged rows and re-upload.

Note: Do not change or rename any column headings in the template. Changing them will cause the import to fail.

Note: Ethnicity and gender are mandatory fields required for LURITS/CEMIS compliance.

Note: Learners can be linked to existing family accounts by including the correct family code in the template.

Frequently asked questions

Why are some rows showing errors after import?

Common causes include missing mandatory fields (ethnicity, gender), incorrect phone number formats, or duplicate ID numbers. Correct the flagged rows and re-upload the file.

Can I change the column headings in the template?

No. The column headings must remain exactly as provided. Changing them will cause the import to fail.

When should I use bulk import?

Bulk importing is most useful at the start of a new year or when migrating from another system where large numbers of learners need to be enrolled at once.

Last updated: April 2026 | Version 2.1

© Copyright d6 group (Pty) Ltd.

    • Related Articles

    • Learners

      Overview The Learners module is the central administrative hub of the d6 school management solution. It facilitates the capture and management of learner demographics, medical data, parent/guardian contact information, and financial billing ...

    • How to Import Learners Using the Excel Template

      The Bulk Learner Import lets schools upload a pre-formatted Excel file to add multiple learners to d6 in one step. Ideal for new setups or year-start enrolments, this article covers the full Spreadsheet Import process including compulsory fields, ...

    • How to import assets in bulk

      Assets can be entered in bulk on an Excel template and then imported into the d6+ Asset list, where they display per item. My School > System > Assets > Manage: Import Assets Important: If you need to add additional items after a previous import, ...

    • Bank Statement Import

      The Bank Statement Import function allows you to import electronic bank statements into the system for reconciliation. Finance > Cashbook > Bank Statement Import How do I import a bank statement? Obtain an electronic copy of your bank statement from ...

    • How to import LURITS files

      The Import LURITS Files function allows schools to import XML feedback files from the Department of Education to update learner and educator LURITS numbers in d6+. My School > d6 Initiatives > Compliance > Compliance: Import LURITS Files Important: ...