Meeting attendance sheet: a free template (and how to automate it)
Whether it's a weekly class, a standup, or a support group, a tidy meeting attendance sheet turns “I think everyone was there” into a record you can actually trust. Below is a free template you can rebuild in Google Sheets or Excel in about two minutes — the right columns, a Present/Late/Absent dropdown, and a corrected attendance-rate formula — plus a faster way to fill it in when your meetings are online.
A meeting attendance sheet should have seven columns: Date, Name, Email, Status (Present/Late/Absent), Join time, Leave time, and Notes. To make one, type those headers in row 1 of Google Sheets or Excel, add a dropdown on the Status column with data validation, then total attendance with a COUNTIF formula.
Date · Name · Email · Status · Join · Leave · Notes
Key takeaways
- Use seven columns: Date, Name, Email, Status, Join time, Leave time, Notes. Date, Name, and Status are the bare minimum.
- Add a Present/Late/Absent dropdown with Data validation (Sheets) or Data Validation → List (Excel) so a status can never be mistyped.
- For the attendance rate, prefer the explicit COUNTIF-over-COUNTIF formula — it's more robust than dividing by COUNTA, which can over-count.
- For online calls, Trackr auto-fills the same columns from a Google Meet and exports to CSV or Sheets.
What columns should a meeting attendance sheet have?
A meeting attendance sheet should have seven columns: Date, Name, Email, Status (Present/Late/Absent), Join time, Leave time, and Notes. That set stays small enough to fill quickly yet handles classes, cohorts, standups, and group sessions. Here's the layout with two example rows so you can see it filled in:
| Date | Name | Status | Join time | Leave time | Notes | |
|---|---|---|---|---|---|---|
| 2026-06-08 | Ana Ruiz | ana@example.com | Present | 09:00 | 10:02 | — |
| 2026-06-08 | Marcus Lee | marcus@example.com | Late | 09:14 | 10:00 | Joined 14 min in |
Date, Name, and Status are the must-haves. Email gives you a unique key when two people share a name; Join time and Leave time let you tell a latecomer from someone who stayed the whole hour; and Notes is where excused absences and one-off reminders live.
How do I make one in Google Sheets?
To make a meeting attendance sheet in Google Sheets, type the seven headers in row 1, freeze that row, then add a dropdown to the Status column with Data validation. Step by step:
Type Date, Name, Email, Status, Join time, Leave time, Notes across A1–G1.
Select the Status cells, then Data → Data validation → + Add rule.
Criteria: Dropdown → enter Present, Late, Absent → set Reject input → Done.
- In row 1, type the headers across columns A–G: Date, Name, Email, Status, Join time, Leave time, Notes.
- Select row 1, then View → Freeze → 1 row so the headers stay put while you scroll.
- Select the Status cells, open Data → Data validation, click + Add rule, set the criteria to Dropdown, and enter the three options: Present, Late, Absent. Optionally set Reject input so only those values are allowed, then click Done. Every Status cell is now a clean dropdown you can't mistype.
- Optional: with the same range selected, use Format → Conditional formatting to colour Present green and Absent red at a glance.
Want to reuse it every week? Duplicate the tab (right-click the sheet name → Duplicate) instead of clearing rows, so each meeting keeps its own dated record.
How do I make one in Excel?
To make a meeting attendance sheet in Excel, enter the same seven headers, then add the Status dropdown through Data → Data Validation → List. The clicks differ slightly from Sheets:
- Enter the same seven headers in row 1, then select the range and press Ctrl/Cmd + T to turn it into a proper Table (this keeps formatting and formulas tidy as rows grow).
- Select the Status cells, open the Data tab → Data Validation → Settings, set Allow to List, and in the Source box type
Present,Late,Absent(comma-separated). Keep In-cell dropdown checked, then click OK. That gives you the same dropdown. - Format the Join time and Leave time columns as Time so entries sort and subtract correctly.
If you ever need to move data between the two, just File → Download → CSV from Sheets, or Save As → CSV from Excel — both open cleanly in the other.
How do I calculate the attendance rate?
To calculate the attendance rate, divide the number of Present rows by the total number of statuses with COUNTIF. The same formula works in both Google Sheets and Excel; just format the result cell as a percentage. Use the explicit version below:
=COUNTIF(D2:D100,"Present")/(COUNTIF(D2:D100,"Present")+COUNTIF(D2:D100,"Late")+COUNTIF(D2:D100,"Absent"))
Replace D2:D100 with your actual Status range, and exclude the header row (start at D2). COUNTIF is case-insensitive, so present and Present both count. If a late arrival should count as attended, add Late to the numerator too:
=(COUNTIF(D2:D100,"Present")+COUNTIF(D2:D100,"Late"))/(COUNTIF(D2:D100,"Present")+COUNTIF(D2:D100,"Late")+COUNTIF(D2:D100,"Absent"))
You'll often see =COUNTIF(D2:D100,"Present")/COUNTA(D2:D100) instead. It's valid but fragile: COUNTA counts a stray header cell or any formula-blank (a cell that looks empty but holds ""), which inflates the denominator, and it ignores how Late should be treated. The explicit COUNTIF-over-COUNTIF version above only counts the three real statuses, so the trade-off is a slightly longer formula for a number you can trust.
For the bigger picture — comparing methods across Google Meet, Zoom, and Teams — see our roundup of the best ways to track online meeting attendance in 2026.
Skip the typing: auto-fill the sheet
The template is great. Filling it by hand, every meeting, is not. For in-person meetings a paper sheet is fine, but for online calls you end up alt-tabbing to a spreadsheet, squinting at the participant list, and still missing whoever slipped in at minute fourteen.
The fix for online meetings: let an extension fill the same columns for you. See our full walkthrough on how to track attendance in Google Meet.
Trackr is a free Chrome extension that watches your Google Meet participant list and records the exact columns above — name, join time, leave time, and a Present/Late/Absent status it sets automatically based on when each person joined. When the call ends you rename the meeting, fix any nicknames, and export to CSV or Google Sheets in one click. No formulas to copy, no late arrivals missed, and it works on free and paid Google accounts alike. If you run a classroom, the Google Meet attendance tracker for teachers walks through the same flow with rosters and weekly reports.
Let the sheet fill itself.
Install Trackr and your next Google Meet auto-populates the same columns — name, times, status — ready to export. Free, local-only, no sign-up.
Frequently asked questions
These answers are marked up as FAQ structured data. Google retired FAQ rich results for most sites in 2025, so don't expect the expandable snippet in search — we keep the markup because AI answer engines still read it to extract clean, direct answers.
What columns should a meeting attendance sheet have?+
Seven columns cover almost every use case: Date, Name, Email, Status (Present/Late/Absent), Join time, Leave time, and Notes. Date, Name, and Status are the bare minimum; the join and leave times let you flag late arrivals and early leavers, and the Notes column is handy for excused absences or anything you want to remember later.
How do I add a Present/Late/Absent dropdown in Google Sheets?+
Select the Status cells, open Data → Data validation, click “+ Add rule,” set the criteria to “Dropdown,” and enter Present, Late, Absent. Optionally set “Reject input” so only those values are allowed, then click Done. In Excel it is Data → Data Validation → Allow: List, with Source set to Present,Late,Absent.
What formula calculates the attendance rate?+
Use =COUNTIF(D2:D100,"Present")/(COUNTIF(D2:D100,"Present")+COUNTIF(D2:D100,"Late")+COUNTIF(D2:D100,"Absent")), where D2:D100 is your Status column (header excluded). This explicit denominator is more robust than COUNTA, which can inflate the count by including the header or formula-blanks. Format the result cell as a percentage.
Is there a way to fill the attendance sheet automatically?+
Yes. For online meetings a free extension like Trackr watches the Google Meet participant list and fills the same columns for you — name, join time, leave time, and a Present/Late/Absent status — then exports straight to CSV or Google Sheets. That removes the typing entirely and captures late arrivals you would otherwise miss.