Attendance Sheet Template: Free Excel, Google Sheets and PDF

Manolete · 1 Sept 2026 · 8 min
In brief:
  • Three free attendance sheet templates, ready to use: a daily sign-in sheet, a weekly tracker and a monthly tracker, in Excel, Google Sheets (make a copy), PDF and Word.
  • The Excel and Google Sheets versions count sessions attended, absences and late arrivals on their own, colour the P / A / L / E codes and work out an attendance rate.
  • A template is only as good as its fields: session title and date, facilitator, participant identity, hours actually attended and one signature per half day.
  • Past a few sessions a week, the spreadsheet becomes the bottleneck. Digital attendance produces the same signed, time-stamped record without a file to chase.

Download the attendance sheet templates

Pick the layout that matches how your sessions run, then open it in the tool your team already uses. No sign-up, no email gate.

TemplateBest forExcelGoogle SheetsPDFWord
Daily sign-in sheet
One row per participant, time in, time out, signature
One-day workshops, classes, meetings, in-person sign-inDownload .xlsxMake a copyDownload .pdfDownload .docx
Weekly attendance tracker
Monday to Friday, morning and afternoon, automatic totals
Courses and programmes that run over several days a weekDownload .xlsxMake a copyDownload .pdfn/a
Monthly attendance tracker
Days 1 to 31, totals by status, attendance rate
Long programmes, apprenticeships, recurring groupsDownload .xlsxMake a copyDownload .pdfn/a

The Google Sheets link opens one file with the three layouts as tabs. Click Make a copy to get your own editable version in your Drive. The Excel files use plain formulas (COUNTIF, SUM) and open in LibreOffice and Numbers as well.

Daily attendance sheet template with participant name, time in, time out, hours and signature columns
Daily sign-in sheet: one line per participant, a signature next to each name, the facilitator signs at the bottom.

What should be included in an attendance sheet?

An attendance sheet has one job: showing, later, that a named person was in a named session for a given number of hours. Everything on the template serves that. Leave a field out and the record is harder to defend when a client, a funder or an auditor asks for it.

Field categoryInformation to recordWhat it is for
SessionTitle, date, start and end time, room or meeting link, facilitator nameTying the proof to one identified session
ParticipantFull name, company or department, email addressIdentifying the person without ambiguity and following up
TimeTime in, time out, hours actually attendedJustifying the hours invoiced, funded or credited
VerificationParticipant signature, facilitator signature, per half day for multi-day sessionsMaking the record hold up as evidence
StatusPresent, absent, late or excused (P / A / L / E), with a noteSpotting repeated absences before they become a problem

Two details are easy to forget. First, the facilitator's signature: it confirms the sheet was closed by someone accountable. Second, the time slot: "present on Tuesday" is weaker than "present from 9:00 to 12:30 on Tuesday 4 March", which is what funders and compliance reviews actually check.

Daily, weekly or monthly: which template should you use?

The three layouts record the same thing at different scales. Choose by how long the group stays together, not by habit.

  • Daily sign-in sheet when every session has its own audience: a one-day workshop, a public class, a safety briefing, an event. It is the only layout with a signature column, which makes it the right one whenever the record has to be signed on site.
  • Weekly tracker when the same group meets several times a week. Each half day gets a P, A, L or E; the sheet counts sessions attended and absences per participant, and present participants per session.
  • Monthly tracker for programmes that run for weeks or months: apprenticeships, evening classes, bootcamps, recurring team training. Totals by status and an attendance rate per participant give you the figure most reports ask for.
Weekly attendance tracker template with Monday to Friday morning and afternoon columns and automatic totals
Weekly tracker: one code per half day, totals calculated automatically in the Excel and Google Sheets versions.
Monthly attendance tracker template with days 1 to 31, totals by status and an attendance rate per participant
Monthly tracker: days 1 to 31, totals by status, attendance rate per participant and present participants per day.

How to make an attendance sheet in Excel

If you would rather build your own, the structure below is the one used in the weekly and monthly templates. It takes about fifteen minutes the first time.

  1. Set the header block. Rows 1 to 4: title, programme or class, facilitator, period. Keep the data table separate, starting a few rows down, so you can sort it without dragging the header along.
  2. Define the columns. Participant name, one column per session (or per day), then the totals: present, absent, late, excused. Add a notes column at the end.
  3. Restrict what people can type. Select the session columns, then Data › Data Validation › List and enter P,A,L,E. Typos disappear and the totals stay reliable.
  4. Count with COUNTIF. In the Present column: =COUNTIF(C7:L7,"P"). Same formula with "A", "L" and "E" for the other totals. For an attendance rate: =Present/(Present+Absent), formatted as a percentage.
  5. Colour the codes. Home › Conditional Formatting › Highlight Cell Rules › Equal To: green for P, red for A, amber for L. Absences become visible without reading row by row.
  6. Freeze and save. Freeze the header row and the name column (View › Freeze Panes), then save the file as an Excel template (.xltx) so each new month starts from a clean copy.

How to make an attendance sheet in Google Sheets

Google Sheets wins as soon as several people need the same file at the same time: the facilitator on a tablet in the room, the coordinator at their desk, the registry at month end. Start from the template copy, or rebuild it with the same steps as in Excel: data validation is under Data › Data validation, conditional formatting under Format › Conditional formatting, and the COUNTIF formulas are identical.

Attendance sheet template opened in Google Sheets with Daily, Weekly and Monthly tabs
The Google Sheets version: three tabs (Daily, Weekly, Monthly), drop-down codes and automatic totals.

Share the copy with "Editor" access only to the people who record attendance, and "Viewer" access to everyone else. One caveat if you attach a Google Form so participants register themselves: a form proves that a name was typed, not that a person was in the room. Keep a signed sheet, or a check-in that identifies the participant, whenever attendance has to hold up as evidence.

How to make an attendance sheet in Word

Word is the right tool when the sheet will be printed and signed with a pen. Insert › Table with seven columns: number, participant name, company or department, time in, time out, hours, signature. Give the signature column the most width and set the row height to at least 0.8 cm so there is room to sign. Add the session title, date, facilitator and location above the table, and a line for the facilitator's signature below it. The Word template above is exactly that, formatted for US Letter paper.

For a printable version that cannot be edited after the session, export the finished sheet to PDF (File › Save As › PDF), or use the PDF sign-in sheet directly.

Good habits that make the sheet hold up

Pre-fill the names before the room opens. If participants registered in advance, their names and companies should already be on the sheet: no queue at the door, no illegible handwriting to decode later.

Give the sheet to one named person. A sheet passed from hand to hand comes back incomplete, with signatures against the wrong line. Someone stationed at the door records the real arrival time and marks absences as they happen.

Close the sheet the same day. A paper sheet scanned in the evening is archived; the same sheet left in a bag is lost. Store the signed original with the session file, and keep the spreadsheet as the index, not as the proof.

When a spreadsheet is no longer enough

These templates solve the layout. They do not solve the volume. From a few sessions a week, the file becomes the bottleneck: several versions in circulation, missing signatures, consolidation on Friday evening, and a signature that is hard to tie to a time slot.

That is the point where digital attendance earns its place: the sheet is generated from the session, participants sign on their phone or on the facilitator's tablet, in-person check-in works by QR code, link or NFC badge, and the signed, time-stamped record is archived without anyone scanning anything. Absence alerts reach the organiser during the session rather than at the end of the month. Teams that run sessions across several sites will find the matching setup on the Edusign for enterprise page.

Frequently asked questions

The session (title, date, start and end time, location, facilitator), the participant (full name, company or department, email), the time actually attended (time in, time out, hours) and a verification (participant signature, facilitator signature). For multi-day sessions, add a status per half day: present, absent, late or excused.

Start with a table of seven columns: number, participant name, company or department, time in, time out, hours, signature. Add the session title, date and facilitator above it, a line for the facilitator's signature below it, and print it. The daily sign-in template on this page is exactly that, in Excel, PDF and Word.

Put one participant per row and one session (or day) per column. Restrict the session cells to the codes P, A, L and E with Data Validation, count them with COUNTIF (for example =COUNTIF(C7:L7,"P")), colour them with Conditional Formatting, freeze the header row and the name column, then save the file as a template. The weekly and monthly templates above already do this.

Insert a table (Insert › Table) with a column for the number, the name, the company or department, time in, time out, hours and the signature. Widen the signature column, set the row height to at least 0.8 cm, add the session details above the table and the facilitator's signature line below. Export to PDF once the sheet is final so it cannot be edited afterwards.

A spreadsheet proves that a row was filled in. What makes attendance hold up is the signature attached to an identified participant, an identified session and a recorded time slot. If the spreadsheet is your only record, keep a signed sheet alongside it, or use a check-in method that identifies the participant.

That is the safest rule, and the one most funders and compliance reviews expect. One signature per half day shows that the person was there for the morning and the afternoon, not just at some point in the day. The weekly and monthly templates have one column per half day for that reason.