Attendance register
One row per person per scan, for classes, shifts and roll call.
Attendance codes are usually a single ID with nothing to split, so this template only gives that ID a clear column name. The scan time and the scanner link are always written in columns A and B, so they need no column of their own. Keep one row per scan rather than one row per person: it gives you an audit trail, and a pivot table still gets you the daily count.
A code like this
Becomes this row
| A | B | C | D |
|---|---|---|---|
| scanned_at | scanner | device_id | student_id |
| 2026-08-23 09:14:02 | link:Gate A | iPhone-a91c | STU-4417 |
Columns A–C are the tracking prefix. Your mapped columns start at D.