Login
Register
4Matrix 4Matrix Support Knowledgebase 4Matrix Cloud
How to import attendance data
Suggested knowledgebase articles:

Summer Holidays Support Hours

From Monday 20th July to Wednesday 2nd September, our support services (tickets, live chat and telephone) will be available from 9am to 3pm.

We will provide extended support hours during results days as follows:

  • Wednesday 12th August (GCE Results): 8:00am to 5:00pm
  • Thursday 13th August (GCE Results): 8:00am to 5:00pm
  • Wednesday 19th August (GCSE Results): 8:00am to 5:00pm
  • Thursday 20th August (GCSE Results): 8:00am to 5:00pm

 

How to import attendance data

4Matrix Cloud

Pupil Attendance is linked to a series and must be imported using a spreadsheet.  The following data columns must be included in the spreadsheet: 

  • Surname 

  • Forename 

  • Sex

  • UPN 

  • Attendance percentage 

  • Unauthorised absence percentage (optional) 

  • Authorised absence percentage (optional) 

Import via Admin > Import Data.  Select ‘Upload file’ and drag and drop your spreadsheet into the box.  At Step 2 ensure the bullet is selected for ‘Results’ and select the appropriate academic year and series. In Map Data, all columns should auto-map. Complete the import wizard. 

The attendance data can be viewed in the Admin > Series tool, by selecting the series the data was imported into and in the screen that opens, choosing the Pupils tab. 

 

18/09/2025

Was this article helpful? Yes | No

Article Details

Article ID:
293
Category:
4Matrix Cloud
Date added:
18/09/2025 10:07:58
Views:
333
Rating (Votes):
(0)

Related articles