Go to Settings > Attendance & Calendar > Import Attendance & Confirmations, choose Attendance, then Class or Homeroom. Download the CSV template, add one row per absence or late arrival, and upload it. Confirmed registers are protected unless you choose to override them.
For school admins: update many attendance records at once from a spreadsheet.
Why it helps
- Correct a whole term in one upload. Fix or back-fill class and homeroom attendance from a spreadsheet instead of editing registers one day at a time.
- Move from another system. Bring attendance records across when your school starts using ManageBac+ attendance.
- Confirmed registers stay safe. By default, rows on a confirmed register are left alone and reported, so signed-off attendance is not changed by mistake.
Where to find it
Go to Settings > Attendance & Calendar > Import Attendance & Confirmations. Choose Attendance at the top, then Class or Homeroom. The Confirmations tab is the existing confirmations import and is unchanged.
Import attendance
Go to Settings > Attendance & Calendar > Import Attendance & Confirmations and select Attendance.
Select Class or Homeroom.
In Step 1, select Download CSV Template. Keep the column headings exactly as they are.
Add one row for each attendance exception (see the columns below) and save the file as CSV.
In Step 2, choose the file and pick how existing attendance is treated: Override attendance, except on confirmed days (the default) or Override all attendance, including confirmed days.
Select Proceed and Upload, then read the results.
Class attendance columns
| Column | Required | What to enter |
|---|---|---|
| Class ID | Yes | The ManageBac+ class ID |
| Student ID or Student E-mail | One of the two | The Student ID shown on the student profile, or their email. If both are filled, the ID is used |
| Date | Yes | DD-MM-YYYY |
| Period | Yes | The period number as it appears on screen |
| Status | Yes | The attendance category name, for example Late. Capital letters do not matter; codes and abbreviations are not accepted |
| Notes | No | Up to 255 characters |
Homeroom attendance columns
The homeroom file has no class or period column. The student's own programme decides which homeroom register the row belongs to.
| Column | Required | What to enter |
|---|---|---|
| Date | Yes | DD-MM-YYYY |
| Student ID or Student E-mail | One of the two | As for class attendance |
| Status | Yes | The attendance category name |
| Notes | No | Up to 255 characters |
How confirmed registers are protected
| Row in your file | Default option | Override all |
|---|---|---|
| Status matches what the student already has | Unchanged | Unchanged |
| Status differs, register not confirmed | Changed | Changed |
| Status differs, register confirmed | Protected | Changed |
- A homeroom register counts as confirmed when the student's current homeroom advisor has confirmed it for that date. Students with no homeroom advisor are never protected.
- If your school does not use attendance confirmations, the two options are not shown. A warning explains that existing attendance will be overridden.
- Import attendance before you import confirmations. If the days are confirmed first, the default option protects every row and nothing changes.
Reading the results
Every row in the file is counted once, so the four totals add up to the number of rows.
| Badge | Meaning |
|---|---|
| Changed (green) | The row was applied |
| Unchanged (grey) | The student already had this status, so nothing was written |
| Protected (blue) | The row is on a confirmed register and was left alone |
| Skipped (orange) | The row was not applied. The reason is shown next to it |
Protected and skipped rows are listed with their row number, the values from your file and the reason. Duplicate rows for the same student, date and period are listed too.
Things to know
- Only include exceptions, such as Absent or Late. A student with no row counts as present.
- Rows on days that are not working days for the student's programme are skipped. This is expected if your old system recorded holidays.
- An empty Notes cell keeps any note already on the record. If the Notes cell has a different note from the one already stored, the whole row is skipped with the reason "Differs from original attendance note".
- Future dates are not accepted.
- Files must be CSV, up to 1 MB and 5,000 rows. Files with different headings, or over the limits, are rejected before any row is read.
- If an import stops part-way, nothing from that file is saved.
- An attendance change cannot be undone, so check the file before you upload it.
- Each import is recorded against the admin who ran it.
Who can use it
School admins, if your school uses Attendance. The Class tab needs class attendance switched on, and the Homeroom tab needs homeroom attendance switched on.
Developers can also update class attendance through the Public API. See the Faria Integrations Portal.