Visitor & Contractor Log

QR code visitor and contractor log to Google Sheets — no receptionist software

The free way to run visitor sign-in with QR codes is a Google Form behind a QR poster at reception, and QR to Sheets fits when reception should scan each visitor's or contractor's pass instead, on arrival and on the way out, or when visitors scan their pass at a tablet kiosk. Every visit logs to your own Google Sheet with the time and the entry point, with no app and no visitor accounts. If you must screen ID, check watchlists or print photo badges, a dedicated visitor management system is the better buy.

Free for your first 300 scans on one phone, no card needed.

Updated

Which visitor sign-in setup fits your reception?

The Google Form is free and is the right first try. The middle two rows are QR to Sheets, which we make, so weigh the table with that in mind.

Visitor sign-in setups compared: Google Forms, a QR to Sheets scanner link, a QR to Sheets kiosk and a visitor management system
WorkflowWhat it recordsBest fitLimit
QR poster at receptionGoogle Form (free)Whatever each visitor types on their own phone, with the submission time, in a linked Google SheetA quiet reception and first-time visitors who would type their details anywaySign-out is a second form most visitors skip, and a submission made with no signal is lost rather than queued
Reception scans a visitor passQR to Sheets scanner linkOne row per scan, on a Check in link and a Check out link: pass code, time and entry pointStaffed desks, regular contractors, fire registersA record, not a lock: no ID checks or badge printing, and names come from a lookup tab or manual entry
Visitors scan their pass at a kioskQR to Sheets scanner link on a shared tabletThe same rows, with the visitor holding their pass up to a tablet by the doorUnstaffed lobbies with regular visitorsThe tablet has to stay mounted and charged, and one-off visitors still need a pass
Visitor management systemDedicated visitor softwareVisitor details, usually with ID scans, photos and host alerts, in the vendor's own systemSites that must screen ID, check watchlists or print photo badgesCosts more and takes longer to set up than a sheet, and the data lives with the vendor

Signing families in at a school event rather than an office? See school open day check-in with QR codes for registered and walk-in queues. For a shared tablet by the door, see how to run a QR check-in kiosk on a shared tablet. For a graduation ceremony with one ticket per guest, see graduation guest check-in. Running a fire drill headcount for students at the assembly point? See fire drill headcount in Google Sheets.

Replace your paper sign-in book with a QR code

Pass scanned → Google Sheets row. Every visit timestamped, searchable, and exportable.

A QR pass for every visitor

Regular contractors carry a reusable QR badge. One-off visitors are handed a numbered QR pass at reception. Print both from the free bulk QR generator, with no badge printer to buy.

Visitors install nothing

Reception scans the pass with the scanner link open in a phone browser. The visitor needs no app, no account and not even a phone of their own.

Precise arrival and departure timestamps

Create a Check in link and a Check out link. Know exactly when each visitor or contractor arrived and left, as timestamped rows in Google Sheets.

One link per entry point or floor

Create separate scanner links for reception, the car park barrier, server room access, or each floor. Each row names the link, so you know which entrance every scan came through.

Complete visitor history in Google Sheets

Every visit is a searchable row in your Google Sheet. Filter by date, location, or pass number, and export it when an audit or a fire drill asks for the list.

Visitors never access your Google account

The admin connects Google Sheets once. The scanner screen shows the scan result and nothing else: no spreadsheet, no other visitors, no admin settings.

Your digital visitor register in four steps

01

Connect your visitor log spreadsheet

Sign in with Google and pick the spreadsheet you use for visitor records. Configure columns for pass code, timestamp, and entry point in under two minutes.

02

Create a Check in and a Check out link

Point both at the same spreadsheet, and add a pair per entrance if you have more than one. Each row names the link it came through, so the direction is never guessed.

03

Print badges and numbered visitor passes

Print a reusable QR badge for each regular contractor and a stack of numbered passes for one-off visitors. Hand a pass out on arrival and collect it on the way out.

04

Scan in, scan out

Reception scans the pass on the Check in link on arrival and on the Check out link when it comes back. Each scan is a timestamped row, ready for fire registers and contractor records.

Visitor check-in and check-out, and the free way to do it

The free route is a Google Form behind a QR code poster: each visitor scans it with their own phone and types their name, and responses land in a Google Sheet with a timestamp. It suits a quiet reception and first-time visitors who would be typing their details anyway. It breaks on sign-out, which is a second submission most visitors never make, and on signal, because a submission attempted in a basement lobby is lost rather than queued. Our guide to replacing a paper sign-in sheet with a QR code covers both setups honestly.

A visitor log answers who is in the building only if check-out is recorded as reliably as check-in. That is why the setup above uses two links and ties check-out to handing back the pass. For the two-link layout and the formula that lists who has not left yet, see QR code check in and check out in Google Sheets.

Common questions

Is there a QR code for visitors to check in and check out?+

Yes. Create two scanner links, Check in and Check out, both writing to the same Google Sheet, and give each visitor a QR pass. Reception scans the pass on the Check in link on arrival and on the Check out link on departure, so each visit becomes two timestamped rows. If you would rather visitors scan a poster themselves, a free Google Form behind a QR code does that, with each visitor typing their own details on their own phone.

How do visitors sign out?+

They hand their pass back at reception, and it is scanned on the Check out link before it goes back in the drawer. Tying sign-out to returning the pass is what makes it happen: a separate form that visitors are trusted to fill in on the way out is the step most people skip. Any pass scanned in but not out by the end of the day is your list to chase.

Should visitor passes refuse duplicate scans?+

No. Passes are reused, so the same code is scanned again for the next visitor, the same day and the next. Once ever would refuse every later use of a pass, and Once a day would refuse its second use that day. Keep the link's Accept duplicate scans setting at Always, the default, and repeats are saved and flagged rather than refused.

Do visitors need to install an app?+

No. Reception scans the visitor's pass with the scanner link open in any phone browser. The visitor installs nothing, creates no account and does not need a phone.

Can I use this as a fire register?+

Yes, as far as people check out. A formula on a second tab that lists passes scanned in but not yet scanned out gives you who is still in the building. Share a view-only link with your fire warden so they can open it on their phone during an evacuation, and keep your paper procedure too: the list shows only the scans that have reached the Sheet, and a real emergency may have no signal.

Can I have separate logs for different entry points?+

Yes. Create a link per entry point. Each can write to its own tab, and every row names the link, so you always know which entrance was used.

Can the log show which receptionist scanned each pass?+

Yes. Turn on Staff sign-in for the link and invite each receptionist to your workspace: they sign in once with their own Google account, and each row records the email of the receptionist who scanned, in place of the link name. If you also need the entrance, give each entrance's link its own tab.

Can I collect contractor or visitor details alongside the scan?+

The scan records the pass code and the time. Keep a tab that maps each contractor's badge to a name and company. For one-off visitors, reception can use the scanner's manual entry to type a name, or visitors can pre-register on a form that emails them a QR code to show at reception.

Is this access control?+

No. A visitor log is a record, not a lock: it does not open doors or stop anyone entering. It tells you who came, when, and whether they left. If you need enforcement, you need access-control hardware.

Also included

No code to scan? Collect it with a form instead.

Sign-in is a scan, but pre-registration is not. Let visitors register before they arrive, email them a QR code, and scan it at reception instead of typing their details at the desk.

Build a form, share the link or embed it on your own page, and every submission lands as a row in the same Google Sheet and fires a webhook the moment it arrives, so Zapier, Make, n8n or your CRM picks it up in real time. Each person can get their own QR code by email, which you scan to record their arrival. Included with the paid plan; the free plan covers one form and ten submissions.

How forms and check-in fit together

Related guides

Replace your sign-in book with Google Sheets today

Free to start. No credit card. No app for visitors or contractors.

Start for free