Google Meet attendance template (that fills itself in) — 2026
If you searched for an attendance sheet template for your online classes, you have probably already lost a few evenings to copy-pasting names, fixing broken formulas, and filling the same grid in by hand after every session. This page gives you the exact column layout a good Google Meet attendance sheet needs — and then shows you the shortcut: a free add-on that generates that exact sheet automatically, for every meeting, with the data already filled in.
The columns every online class attendance template needs
Whether you build the sheet yourself or let software do it, a defensible attendance record needs more than a name and a checkbox. Here is the layout that holds up when a student, parent, or administrator asks questions later:
| Column | Why it matters |
|---|---|
| Name | The student's display name, matched against your roster. |
| The stable identifier — names change, get abbreviated, or repeat; emails don't. | |
| Status | Present / Late / Left Early / Absent / Excused / Guest — a plain checkmark can't capture the difference between "showed up on time" and "arrived 20 minutes in." |
| Attendance % | Minutes attended ÷ class length. The fairest single number for participation grades. |
| Duration (min) | Total active minutes, so a 5-minute drop-in doesn't count like a full session. |
| Join Time | Proof of when they actually arrived — the basis for late flags. |
| Leave Time | Catches early leavers, not just late arrivers. |
| Rejoins | Distinguishes an unstable connection (many rejoins, honest attendance) from someone who left and came back at the end. |
| Notes | Room for context: excused reasons, tech issues, make-up work. |
Google Meet Attendance Spreadsheet Template (With Built-in Formulas)
Don't waste time rebuilding this by hand. Make a copy of our pre-formatted Google Sheets attendance template below — complete with active formulas for duration calculation, automated status flags (Present / Late / Absent), and attendance rate percentages.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Name | Join Time | Leave Time | Duration (min) | Status | Attendance % | Rejoins | Notes | |
| 2 | Sarah Jenkins | sarah.j@school.edu | 09:00 AM | 10:00 AM | 60 | Present | 100% | 0 | Full session participation |
| 3 | David Chen | d.chen@school.edu | 09:18 AM | 10:00 AM | 42 | Late (+18m) | 70% | 0 | Joined 18m past start |
| 4 | Maria Rodriguez | m.rodriguez@school.edu | 09:01 AM | 09:35 AM | 34 | Late (34m) | 57% | 2 | Left early (Wi-Fi dropped) |
| 5 | James Wilson | j.wilson@school.edu | — | — | 0 | Absent | 0% | 0 | Unexcused absence |
| 6 | Elena Rostova | elena.r@school.edu | — | — | 0 | Excused | 0% | 0 | Doctor appointment (excused) |
| 7 | Class Summary (5 Enrolled) | Avg: 27m | 1 Pres · 2 Late · 2 Abs | Rate: 40% | 2 rejoins | Auto-calculated summary | |||
How the template formulas work
If you want to customize your spreadsheet or add these calculations to an existing gradebook, here are the exact formulas running in the template above:
Column E Duration Calculation Formula
D2 - C2) returns the elapsed time as a fraction of a 24-hour day. Multiplying by 1440 (24 hours × 60 minutes) yields exact active minutes. If join time is blank, it defaults cleanly to 0.
Column F Dynamic Status Formula
Present; between 15–44 minutes flags as Late (partial attendance); 0 minutes flags as Absent (or Excused if marked in column I without being unexcused).
Column G Individual Attendance Rate %
E2) by the scheduled meeting duration (60 minutes). MIN(1, ...) caps the rate at 100% so students who stay after class don't skew grading formulas. Format column G as Percentage.
Row 7 Overall Class Attendance Rate
⚠️ The Manual Template Hassle
- Constantly stare at Google Meet's People panel during class
- Manually jot down join times while trying to lecture
- Miss students who drop out at minute 35 due to connection drops
- Accidentally overwrite sheet formulas when pasting student lists
- Spend 10–15 minutes after every single call doing data entry
✨ The Auto-Filled Shortcut
- Official Google Meet add-on tracks participants in background
- Roster matches students to your Google Classroom list in 1 click
- Detects exact active duration and multiple rejoins automatically
- Direct 1-click export to Google Sheets, CSV, or PDF reports
- Includes semester summary tabs rolled up across all dates
The problem with any manual template
A template solves the formatting problem. It does nothing about the real cost of attendance: collecting the data. With a manual sheet you still have to call roll (or scan the People panel), notice who arrived late, notice who quietly left at minute 40, and type it all in — every single session. In a class of 30+ students on Google Meet, that's minutes of lost teaching time and a record that's only as accurate as your peripheral vision.
And Google Meet itself won't fill the template in for you: unless your school pays for a specific premium Workspace edition, Meet keeps no attendance report you can access at all.
Get the same sheet, auto-filled: 3 steps
- Install the add-on (free): Open the Attendance Tracker Marketplace page and click Install. It works with personal
@gmail.comaccounts and school Workspace accounts alike — no Education Plus required — in Chrome, Edge, Firefox, Safari, and on Chromebooks. - Open it in your meeting: In Google Meet, click the Activities icon, choose Attendance Tracker, and press Start. The side panel live-sorts everyone into Present, Late (with a threshold you configure), Absent, and Guests. Optionally create a Class Roster first — paste your list or import it from Google Classroom in one click — so absentees show up too.
- Export the finished sheet: When class ends, download the CSV instantly, save a PDF report, or export to Google Sheets. Every column from the table above is already filled in for every attendee.
Recurring classes: one spreadsheet, tabbed by session
For a class that meets on a recurring Google Calendar invite, the Google Sheets export doesn't scatter files across your Drive. Each session lands as its own tab in one spreadsheet, and a cumulative summary tab rolls up each student's attendance percentage across the whole semester automatically — sessions attended, sessions missed, running percentage. That summary is exactly the "term overview" page template-seekers usually try to build with fragile VLOOKUP formulas.
Need it in your gradebook instead? Per-session Moodle and Canvas gradebook CSVs are free, too.
When a manual template still makes sense
Honesty corner: if you teach in person, or on a platform other than Google Meet, an add-on that reads Meet's roster can't help you — build the nine-column sheet above in Google Sheets and fill it in by hand or with a form. A manual template is also fine for a one-off meeting with five people, where roll call takes ten seconds. The automation earns its keep when classes are online, recurring, or big enough that watching the participant list becomes a job of its own.
Frequently asked questions
Is the auto-filled sheet free?
Real-time tracking, PDF reports, per-session Moodle/Canvas gradebook CSVs, and 2 exports per month across Google Sheets, CSV, or Excel (for classes up to 25 attendees, plus 1 large-class grace export) are free. Unlimited exports come with Pro (a $14.99/year Educator Pass, $4.99–$7.99/year regional, or a one-time $29 Lifetime Pass, $9.99–$19 regional).
Do students need to install anything?
No. Only the person tracking attendance needs the add-on. Students just join the Meet as usual.
Can it mark students absent, not just record who came?
Yes — that's what the Class Roster is for. Add your student list once (or import from Google Classroom), and anyone on the roster who never joins is recorded as Absent, with an Excused status available when you know why.
What if I forget to open the panel?
Pro includes hands-free Auto-Capture: meetings you host are exported automatically within a few hours of ending, even if you never opened the side panel.
Skip the template. Get the finished sheet.
Free to install, works with any Gmail or Workspace account, auto-fills all nine columns for every meeting.
Install Attendance Tracker from Marketplace