Generate static QR codes in Google Sheets with a formula, or make dynamic, editable ones in Busalab and link them to your Sheet, Form or Doc. Completely 100% free.
Yes. Google Sheets can generate QR codes right in a cell using an IMAGE formula that calls a QR-code web service — handy when you want a column of codes from a list, like asset tags or product links. It's a neat trick for bulk QR code Google Sheets work, but there's an important limit: those codes are static.
A static code has its link baked in, so it can't be changed once printed and it reports no scans. For anything you'll reuse or want to measure, you need a dynamic code. With Busalab you create a dynamic, editable code and can point it at a Google Sheet, a Google Form or a Google Doc — or anything else — and repoint it later.
Both approaches are covered below, and Busalab's dynamic codes are completely 100% free with no limits: unlimited codes, unlimited scans, no expiry.
Free, no sign-up tricks, ready in minutes.
Point the code at your Google Sheet, Form, Doc or any link.
Add your colours and logo, then export as PNG, SVG or PDF.
Use it anywhere — and edit or track it anytime.
A qr code for Google Form surveys and sign-ups people scan to open.
A code linking to a shared sheet — a schedule, price list or tracker.
A qr code for Google Docs so people open a shared document in a scan.
Point a code at a Drive file or folder you can swap later.
Use the Sheets formula for one-off batches of static codes.
Use a dynamic code when you need to edit or measure scans.
Change where a code leads anytime — the Sheets formula can't.
See scans, country and device, which static codes can't report.
Forms, Sheets, Docs or Drive — point a code and repoint later.
Unlimited codes and scans, no expiry, no credit card.
Add your colours and logo and download print-ready files.
Any phone camera opens the link — nothing to install.
To generate a QR code in Google Sheets, put your link in a cell and use an IMAGE formula that points to a QR-code web service, passing that cell's value as the data. Drag it down a column and you get a code per row — a quick way to create QR codes from Google Sheets in bulk for inventories, name tags or batch links.
It's genuinely useful for one-off static codes. Just remember what you're getting: a google sheets qr code made this way is static, so if a link changes you regenerate and reprint, and you can't see how many times any code was scanned.
The formula method bakes each link into its image, which is fine for something fixed and disposable. But for marketing, packaging, menus or anything printed in volume, static is risky: one wrong link means reprinting everything, and you never learn what got scanned.
That's where a dynamic code earns its place. It redirects through Busalab, so you can edit the destination after printing and get scan analytics — the two things a Google Sheets formula can't give you.
Create a dynamic QR code in Busalab in a minute: point it at any link, add your colours and logo, and download it. You can point it at a shared Google Sheet, a qr code for Google Form responses, or a qr code for Google Docs — so people scan to open your survey, sheet or document — and repoint it whenever you like.
It's the editable, trackable alternative to a spreadsheet full of static codes, and it's free with no scan limit.
Every Busalab code is free to create, host and update, with unlimited scans and no expiry. Whether you came looking to generate QR code in Google Sheets for a quick batch, or you want a single dynamic code linked to a Google file, you can do both for free.
For codes you'll reuse, measure or print at scale, the dynamic route saves you the reprints — and tells you what's working.