Google Sheets QR Code Generator
Turn a shared Google Sheet into a QR code. Scan to open a live price list, a schedule, an inventory count, or a sign-up sheet from any phone.
Select QR Code Type
QR Type Guide
How Should You Use Google Sheets QR Codes?
Choose static when the encoded information will never change. Choose dynamic when you need to edit the destination after printing, track scans, pause a campaign, or keep a stable short link while the destination changes.
Best For
Campaigns where the scanner expects a focused destination and you may need analytics, design control, or a destination you can update later.
Not Best For
Cases where another QR type is more specific, such as PDF for files, vCard for contact saving, WiFi for network access, or menu QR for restaurant menus.
Before Printing
Test the final QR at real size, confirm the quiet zone, and use the size calculator when the code will appear on signs, packaging, menus, cards, or other printed material.
Share as Anyone with the link first
Open the spreadsheet, click Share, and set access to Anyone with the link before you generate the code. A Restricted sheet shows scanners a Request access screen instead of your data. Use Viewer for a read-only list, or Commenter if people should add notes. This page makes a QR code that opens a Sheet, not one built from a Sheet formula.
What a Google Sheets QR code does
A Google Sheets QR code is a scannable code that opens a shared spreadsheet when scanned. Point a phone at it and the live sheet loads, so a price list, roster, or stock count is always the current one, with no long docs.google.com link to type.
Because a Sheet updates in real time, the code stays accurate as the numbers change. Adjust a price, mark an item sold out, or add a name to a sign-up list, and the next scan shows it. That live quality is what sets a spreadsheet apart from a printed table, which is stale the moment it prints.
Build the code in the QR code generator, and if you make it dynamic you can swap the sheet behind it later and track scans in your dashboard. Note this is different from generating a QR image inside a cell with a formula; here you are making a code that opens the whole sheet.
Why open a spreadsheet with a QR code
Live numbers, not a printout
A printed price list is wrong the moment a price changes. A Sheets QR code opens the live sheet, so every scan shows the current figures.
Everyone reads the same source
Staff, customers, or volunteers all scan one code to reach a single sheet. No conflicting copies, no version confusion.
Let people add rows
Set access to Commenter or share an entry Sheet so people scan to sign up, log stock, or record a count from their own phone.
No link to mistype
Spreadsheet URLs are long. The code carries the whole thing, so it works on a sign or badge where a typed link would not.
How to make a Google Sheets QR code
Share the spreadsheet
Click Share in the Sheet, set access to Anyone with the link, choose Viewer or Commenter, and copy the link.
Paste the link
Drop the spreadsheets link into the field above and the code previews at once.
Brand and track
Add a logo, pick colors, and enable tracking to count scans and allow swapping the sheet later.
Download and post
Export a PNG, SVG, or PDF and place it on a shelf label, counter, noticeboard, or slide.
Printed table vs a Google Sheets QR code
One goes out of date on the shelf. The other updates live.
| What you get | Printed sheet | Google Sheets QR code |
|---|---|---|
| People see the data | Yes | Yes |
| Stays current as numbers change | No | Yes |
| People can add entries | No | Yes, with Commenter access |
| Track how many opened it | No | Yes, on dynamic codes |
| Swap for a different sheet later | No | Yes, on dynamic codes |
| Cost | Printing cost | Free, 5 dynamic codes included |
Where a Google Sheets QR code works
Price lists and menus
A code on a shelf or counter opens a live price sheet. Change a number in the Sheet and the next scan shows the new price.
Schedules and rosters
Staff scan a code in the back room to open the current shift roster or class timetable. Update the Sheet and everyone sees it.
Sign-up and RSVP sheets
Post a code so people scan to add their name to a volunteer slot, potluck list, or event RSVP directly in the sheet.
Inventory and stock counts
Warehouse and shop staff scan a code on a rack to open the stock sheet and update counts from their phone, no shared login to remember.
Order forms and trackers
A code on a supplier folder or job sheet opens a shared tracker where teams log orders, progress, or deliveries in real time.
Class and club data
Coaches and teachers share a stats or attendance Sheet by code, so players and parents check standings without hunting for a link.
Viewer, commenter, or a QR image in a cell
Two habits keep a shared sheet safe. Use Viewer access for anything public so numbers cannot be changed by a stranger, and reserve Commenter or Editor for people who genuinely need to add rows. Never hand a public QR code Editor rights across the whole spreadsheet.
If instead you were trying to generate a QR code image inside a spreadsheet cell using a formula, that is a different task; the Google Sheets and Excel QR code guide covers the formula method. For a shared document rather than a spreadsheet, use the Google Docs QR code, or the Google Drive QR code for a folder of files.
Google Sheets QR code FAQs
How do I make a QR code for a Google Sheet?
Share the spreadsheet as Anyone with the link, copy the link, and paste it into the generator above. Customize and download. A basic code is free and needs no account.
Why does my Google Sheets QR code ask for access?
The sheet is still Restricted. In Share, switch access to Anyone with the link and set Viewer or Commenter. Scanners will then open it without requesting permission.
Does the QR code show live spreadsheet data?
Yes. It opens the live sheet, so any change you make to prices, counts, or rows appears the next time someone scans.
Can people add rows by scanning the code?
Only if you allow it. Set access to Commenter, or share a dedicated entry sheet, so people can add sign-ups or counts. Keep it Viewer to make the sheet read-only.
Is the Google Sheets QR code generator free?
Yes, with no watermark. A free QRLynx account adds 5 dynamic codes for swapping the sheet later and tracking scans.
Can I change which sheet the code opens later?
Yes, on a dynamic code. It uses an editable short link, so you can point it at a different spreadsheet anytime and the printed code keeps working.
Can I track scans on a Google Sheets QR code?
Yes, on dynamic codes. QRLynx logs each scan with time and rough location in your dashboard so you can see how often the sheet is opened.
Is this the same as a QR code formula in Google Sheets?
No. This makes a code that opens your spreadsheet. Generating a QR image inside a cell with a formula is a separate method covered in our Google Sheets and Excel guide.
Does the person scanning need a Google account?
Not to view a sheet shared as Anyone with the link. A sign-in is only needed if you restrict access to specific people or require editing.
Will scanning expose my other spreadsheets?
No. The code only opens the one sheet you shared. Everything else in your Drive stays private.
Can one code work for a price list that changes often?
Yes. Point a dynamic code at your price Sheet and edit the Sheet whenever prices move. The printed code always opens the current list.