Badge attendance with Scanlist
This page opens in New row each scan mode with a Location column suggested, for recording who was present at a shift start, a toolbox talk or a training session. Each badge scan becomes a row with the time; set the location to the room or site once and every row carries it. Export the list as CSV or Excel for the attendance record.
- Name the list after the session, for example Night shift 12 Nov or Forklift refresher, and set its default Location (Pro) to the room or site.
- Tap Start scanning and hold each badge up to the camera. Code 128 and Code 39 on printed ID cards, and QR codes on badges or phone screens, are all read.
- A badge that will not read, or someone without one, can be typed into the box under the scanner with their staff number; the row is added like a scan.
- Scan badges again at the end if you want a sign-out time: the second scan is its own row with its own time in the same list.
- Export the list when the session ends. Each row is one person, the time they were scanned and the location. To find who was expected but absent, use Compare with expected stock (Pro) with the roster saved as CSV.
What to know
A badge barcode usually holds the employee number or the card's own ID, not a name, so the list records that number and the time; join it to your staff sheet with XLOOKUP, or write the name in the note while the person is in front of you. New row each scan is the right mode because attendance is a timed event: a badge scanned at the start and again at the end gives an in and an out row for the same number, both in the same export. Scanlist does not work out hours or check a badge against a database; it records what was scanned, when and where.
Printed badges are laminated and reflect the light, so tilt the badge a little rather than holding it flat to the lens; a QR code shown on a phone needs the screen brightness up and the phone held still a hand width from the camera. Pro can warn when a badge is already in the list and skip it, which stops one person being recorded twice at a single session; leave that off when you want sign-out rows. Continuous scanning (Pro) reads badge after badge without a tap between people, which matters at a shift start with a queue at the door.
To list absentees, Compare (Pro) takes the roster as a CSV. It looks for a column named code, barcode, item, asset, tag or ticket and otherwise uses the first column, so put the badge number in the first column or name that header code before saving. Numbers on the roster that were never scanned are listed as missing; scans that are not on the roster are extra. Free allows three exports a day of 25 rows each, enough for a small team or a training group; a larger shift needs Pro, which also keeps a named list per session.
Updated · Cosmovex
Questions
Does the scan record the person's name or their number?
Whatever the badge barcode contains, which is normally the employee number or a card ID. Add the name in the note on the row if you need it in the export, or match the number to your staff sheet afterwards.
Can I record sign-out as well as sign-in?
Yes. Scan the badge again at the end of the shift; in New row each scan mode the second scan is its own row with its own time. Sort the export by code to see each person's in and out times together.
How do I see who did not turn up?
With Pro, press Compare with expected stock and choose the roster saved as CSV, with the badge numbers in the first column or under a header named code. Numbers that were not scanned are listed as missing.
What if a badge is scanned twice at the same session?
It appears as a second row with its own time, so nothing is lost. Pro can warn when a code is already in the list and not add it, which is useful for a single sign-in with no sign-out.
Can the badge be a QR code on a phone instead of a card?
Yes. QR codes on a phone screen read well with the brightness turned up and the phone held still. Code 128, Code 39, Data Matrix and PDF417 on printed cards are read too.
Where is the attendance list stored?
On the phone that scanned it, until you export the file. Nothing is uploaded; only an export count with a random browser ID is sent, to apply the free limit. Keep the exported file where your attendance records belong.
The free plan covers everything on this page. Scanlist Pro ($5/mo, billed monthly) is described on the Scanlist page.
More ways to use Scanlist
- Scanlist, no preset
- Scan to Excel
- Excel on iPhone
- Scan to Google Sheets
- Retail stocktake
- Inventory count
- Serial numbers
- ISBN batch
- Goods-in receiving
- QR codes to CSV
- Asset audit
- Equipment sign-out
- Event check-in
- Pharmacy stock count
- Parcel dispatch log
- Returns receiving log
- Spare parts bin count
- Lab sample tube log
- Bar stocktake
- Order packing check
- Pallet label scanner
- USB scanner to CSV