Import Pupils from an Excel Spreadsheet

Updated 9 months ago by Kelly Venables

You can import an Excel Spreadsheet into Insight to:

  • Add new pupils
  • Archive pupils who've left the school
  • Update FSM, Pupil Premium and SEN records
  • Update contextual pupil information such as Ethnicity
  • Update your classes / registration groups
To import end of key stage assessment data and/or update attendance records you'll need to import pupils from a CTF.

1. Create your Excel Spreadsheet

Create a spreadsheet containing all your pupils. If you use SIMS, you can save your spreadsheet directly from there.

You'll need to have column headings in Row 1 and your pupil information starting in Row 2.

The following columns are required for each pupil:

  • Unique Pupil Number
  • First Name
  • Last Name
  • Date of Birth
  • Gender
  • SEN Stage

These optional columns may also be included:

  • Class
  • Eligible for free meals
  • English as additional language
  • Pupil Premium
  • Service Child

An example spreadsheet is below.

2. Import your Spreadsheet into Insight

Navigate to the Admin page and choose Manage Pupils:

Click the Update Pupils button:

Click the Excel File button:

Click the Choose file button, navigate to your spreadsheet and click Open.

Once you've chosen your file, review the changes that will be made. Insight will show which pupils will be added, updated and archived (if any):

You can choose not to apply a set of changes by un-ticking in the appropriate box:

When you're ready, click Apply the Selected Changes to finish.


How did we do?