Trusted by 10,000+ communities
Up to 40% discount + 2 months free annually
Get Started
Back to News
Guide

How to Track Attendance with QR Codes for Free (No App to Download)

Build a free QR code sign-in sheet with a QR generator, a form, and a spreadsheet. Step-by-step instructions, plus where this method breaks down.

Illustration of a checklist with items being checked off

A clipboard at the door works until the sheet goes missing or nobody can read the handwriting afterward. If you want something better but aren't ready to pay for software, you can build a working QR code sign-in sheet in about twenty minutes using tools you probably already have: a free QR code generator, a form, and a spreadsheet.

This guide walks through the setup, shows the Excel-only version if you don't use Google, and explains where this free approach runs out of road so you know when it's actually worth upgrading.

What you need

  • A Google account (for Google Forms and Sheets), or Microsoft 365 if you prefer Excel
  • A free QR code generator website (most let you paste a URL and download a PNG)
  • A way to display the code: a printed sheet, a tablet, or a TV near the entrance

Step 1: Build the sign-in form

  1. Open Google Forms and create a new form titled with your event or group name
  2. Add a short-text field for "Full Name" and mark it required
  3. Add any other field you actually need, like "Phone Number" or "Which session are you attending"
  4. Skip fields you don't need. A name and a timestamp are enough for most groups, and Google Forms records the submission time automatically
  5. Click "Send" and copy the form's shareable link

Keep the form short. The more fields you add, the slower people are at the door and the more likely someone abandons it halfway through.

Step 2: Turn the link into a QR code

Paste the form link into a free QR code generator and download the image. Print it, or display it on a tablet or screen at your entrance. Test it yourself first: scan it with your own phone and submit a test entry to confirm the form opens correctly and the response shows up.

Step 3: Let responses fill in your spreadsheet

Google Forms links directly to a Google Sheet. In the form's "Responses" tab, click the Sheets icon to create one. From then on, every submission appears as a new row automatically, with name, timestamp, and whatever else you asked for. No typing required on your end.

Doing the same thing in Excel

Google Forms is the easiest route, but if your organization standardizes on Microsoft 365, Microsoft Forms works the same way:

  1. Create a form in Microsoft Forms with the same fields as above
  2. Generate a QR code from the form's share link
  3. Open the form's "Responses" tab and click "Open in Excel" to export, or set up the built-in Excel link so new responses land in a live workbook

The Excel version requires you to re-export or refresh manually unless you connect it through Power Automate, which is more setup than most small groups need for a weekly sign-in sheet.

Where this free method breaks down

This setup is enough for a handful of events. It starts to cost you time once a few things happen:

  • Name variants pile up. "John Smith," "J. Smith," and "Jon Smith" all look like different people, and nothing in a form or spreadsheet catches that
  • There's no live headcount. You find out who showed up by opening the sheet, not by glancing at a dashboard during the event
  • Arrival time is all you get. A form records when someone checked in, not when they left, so you can't measure time on site
  • Anyone with the link can submit from anywhere. The form doesn't know if the person filling it out is actually at your venue
  • Every event starts from zero. Each new form is its own spreadsheet, so you don't get a running attendance history per person without stitching sheets together yourself

For an occasional event, that's a fair trade for something free. For a weekly class, club, or recurring program, the manual cleanup adds up fast.

When it's worth switching to a dedicated platform

Purpose-built QR code attendance systems like EntriScan solve the specific problems the form-and-sheet method can't:

  • One QR code per event, generated automatically, with a check-in page that opens straight in the attendee's phone browser, no app to install
  • A live dashboard showing who's checked in as the event happens, not after you open a spreadsheet
  • Check-out tracking, so you get real time-on-site instead of just an arrival timestamp
  • Location verification, available on the Professional plan, which confirms an attendee is physically at your venue before the check-in counts
  • A member profile that carries over between events, so attendance history builds up automatically instead of living in separate spreadsheets

EntriScan has a free plan, so you can try the difference without committing to anything. If you're already comfortable with the Google Forms setup above, moving to a dedicated system mostly means trading twenty minutes of manual cleanup after every event for a few minutes of setup once.

Availability

Everything in Step 1 through Step 3 above works entirely with free tools. Location verification is the one feature mentioned here that requires EntriScan's Professional plan; QR check-in and real-time attendance are available on the Free plan.

Questions? Reach us at [email protected].

Ready to try it?

Sign up free and explore all features. Upgrade to Professional to unlock the latest additions.