Google Forms Attendance: How to Take and Track It (Teacher Guide)
Dvir Atias
Jul 14, 2026
Google Forms Attendance: Take It and Track It
To take attendance with Google Forms, build a short form with a dropdown of student names and a field for the class or period, then post it so students mark themselves present at the start of class. Every submission is automatically stamped with the date and time, so your linked Google Sheet becomes a running attendance log you can sort and total by student. It is free, works on any phone or Chromebook, and takes about ten minutes to set up.
The catch, and this guide is honest about it, is that a plain Google Form cannot prove who pressed submit. Without sign-in required, one student can mark a friend present. This walkthrough covers building the form, using the timestamp, tracking attendance in the sheet, whether to reuse one form all semester, and the real ways to reduce buddy-punching.
Set up a daily attendance form, step by step
- Start a Blank form in Google Forms and title it for the class, like "Period 3 Biology Attendance".
- Add a Dropdown question named Student name and enter your class roster as the options, one student per line. A dropdown is faster than free typing and keeps names spelled consistently in your sheet.
- Add a short-answer or dropdown question for Period or Class if one form covers several classes. Skip this for a single class.
- Optionally add a Multiple choice question for status: Present, Tardy, Remote, so you capture more than just "here".
- Do not add a date question. The submission timestamp handles the date for you (more on this next).
- Click Send and share the link or QR code at the start of class.
Mark the name question Required so no submission is blank. Keep the form short; students should complete it in a few seconds before class starts.
Why the response timestamp is your best friend
Every Google Forms response is automatically saved with the date and time it was submitted. You do not need to ask students for the date, and you should not, because a typed date can be wrong or faked. The timestamp is recorded by Google, not the student, so it reliably reflects when the form was submitted.
This has two practical payoffs:
- The date is done for you. Reuse the same form every day and the timestamp column separates each day's attendance automatically.
- You can spot lateness. If class starts at 9:00 and a submission is stamped 9:14, that is a visible tardy. If you want a hard cutoff, close the form a few minutes after the bell so late submissions do not go through.
Track attendance over time in the linked Sheet
Connect your form to a Google Sheet from the Responses tab (click the Sheets icon). Now every submission is a row with a timestamp, the student name, and any other fields, which is your raw attendance record for the term.
To turn rows into a per-student summary without manual counting, use a pivot table:
- In the linked sheet, select your data columns and go to Insert, then Pivot table.
- Set Rows to the student name field. Each student gets one line.
- Set Values to the same name field and summarize by COUNTA. That counts each student's submissions, which is their present-day total.
- To break it down by day or status, add the status field or a date grouping to Columns.
The pivot table updates as new responses come in, so a glance tells you who is under their expected count. If you would rather not build formulas, sorting the sheet by the name column groups each student's submissions for a quick manual scan.
One form all semester, or one per day?
Reusing a single form for the whole semester is the simpler setup for most teachers. The timestamp keeps days apart, everything lands in one sheet, and there is a single link or QR code to remember. The tradeoff is a long response sheet you filter by date.
A fresh form per day gives you a clean, self-contained sheet and makes it obvious the form is for today only, which cuts down on stray late submissions. The cost is more setup and more links to manage. For daily roll, one reusable form is usually the better call. Save a new form per day for special cases like a one-time event or a substitute who needs a form tied to a single date.
Take attendance fast with a posted QR code
Typing a link every morning is friction. A QR code removes it: print one, tape it by the door or drop it on the projector, and students scan it as they walk in. The form opens on their phones and roll takes itself while you start class. Turn your attendance form link into a scannable code for free with the Google Form QR code generator, then reuse the same printout all term since the link does not change.
The honest limits on Google Forms attendance
Before you rely on this for anything graded, know what a plain form cannot do:
- It cannot stop buddy-punching by itself. If sign-in is not required, any student can pick a friend's name from the dropdown and mark them present. The form has no way to know who is holding the phone.
- It does not sync your roster. The dropdown is a static list you typed. New students, transfers, and drops are not updated automatically; you edit the options by hand.
- It has no live "who is missing" view. You see who submitted, not who did not. Compare the response list against your roster yourself, or let a pivot table surface the gaps.
The main fix for buddy-punching is to require sign-in. In Settings, turn on Collect email addresses and set it to Verified, or restrict the form to your school's Google Workspace domain and limit to one response per person. That ties each submission to a signed-in school account, so marking a friend present means doing it from their own logged-in account. It is not foolproof, a student can still hand over an unlocked phone, but it moves attendance from "anyone can submit anything" to "each entry is tied to a real account". For high-stakes days, the reliable backstop is still a quick visual scan against the submitted list.
Quick answers
Does Google Forms record the date automatically for attendance? Yes. Every response is stamped with the submission date and time by Google, so you never need a date question. Reuse one form daily and the timestamp separates each day.
How do I stop students from marking each other present? Require sign-in: turn on Collect email addresses set to Verified, or limit the form to your school domain with one response per person. That ties each entry to a real account. It reduces buddy-punching but a shared unlocked phone can still get around it.
Can I use one attendance form for the whole semester? Yes, and it is usually the easiest setup. The timestamp keeps each day's responses distinct in the linked sheet, so one form and one QR code cover the term.
How do I total attendance per student? Build a pivot table in the linked sheet with the student name in Rows and a COUNTA of the name field in Values. It counts each student's submissions and updates automatically.
Does Google Forms take attendance on phones? Yes. The form opens in any mobile browser, so students can mark themselves present by scanning a posted QR code, no app required.
Can Google Forms show me who is absent? Not directly. It shows who submitted, not who did not. Compare the response list to your roster, or use a pivot table to see which students have low submission counts.
Ready to transform your documents?
Convert Google Docs, PDFs, and spreadsheets into Google Forms in one click.
Start free →Or go straight to a converter: Google Docs to Forms, PDF to Google Form, Word to Google Form, Google Forms Quiz Generator
The bottom line
Google Forms is a fast, free way to take and track attendance: a dropdown of names, the automatic timestamp for the date, and a linked Sheet with a pivot table for running totals. Reuse one form all semester and post a QR code so roll takes itself as students arrive. The one thing to be clear-eyed about is verification, because a plain form cannot prove who submitted. Requiring sign-in ties each entry to a real school account and handles most of the buddy-punching problem; a quick visual check covers the rest on the days it matters.
Ready to transform your documents?
Convert Google Docs, PDFs, and spreadsheets into Google Forms in one click.
Start free →Or go straight to a converter: Google Docs to Forms, PDF to Google Form, Word to Google Form, Google Forms Quiz Generator