Free tool — no signup

Bulk QR code generator with printable label sheets

The free QR to Sheets bulk generator turns a pasted list — or a column straight out of Google Sheets — into a QR code for every row. Print them as a label sheet or download them all. No account, no watermark, and the codes never expire.

Generated in your browser — your list is never uploaded Avery-compatible label grids

Updated

1. Paste your list

One code per line. Commas stay part of the code, so "Smith, Jane" is one code. Student names, asset tags, SKUs, room numbers, seat numbers: anything you want a scannable code for. Paste a column straight out of Google Sheets and it will work; if you copy several columns, the first column becomes the code and the rest are ignored.

0 codes ready

What people print these for

Classroom attendance

One code per student, printed onto ID cards or taped inside a planner. The teacher scans the class in as they arrive.

Asset and equipment tags

One code per laptop, camera, tool, or instrument, so check-out and check-in is a scan instead of a signature.

Stock and shelf labels

Codes on bins, shelves, and pallets so a stock count is walking the aisle with a phone.

Library and device loans

Codes on textbooks and Chromebooks, scanned out to a student and scanned back in on return.

Room and seat numbers

Codes on doors or desks, so a maintenance round or a seating check is logged by location.

Event badges and passes

One code per guest, printed on badges and scanned at the door.

Printing cards that people carry? The free QR code ID card and badge maker lays out credit-card size cards with a name and ID on each, and the free attendance sheet generator builds a Google Sheets register that marks P when a card is scanned. Every free tool is listed on the free QR tools page.

A QR code does not record anything by itself

Worth being clear about, because it trips people up: a printed QR code just holds text. Something still has to read it and write it down. If you scan one of these with your phone camera, you will see the text — and nothing will be saved.

That is the part QR to Sheets does. You connect a Google Sheet, create a scanner link, and share the URL with whoever is scanning. They open it in a phone browser and every scan writes a timestamped row into your Sheet. No app install, and no accounts for them to create — which matters when it is thirty students, a rotating crew, or temporary staff.

See how to scan QR codes into Google Sheets, free routes included, or how to make the codes inside Google Sheets with a formula instead.

Printed one code per student or employee? Next, read how to take QR code attendance in Google Sheets: one staff phone scans each card, and the people on the list need nothing.

Scan these codes into a Google Sheet

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

A second door, booth or classroom is a second phone

Free covers one phone and one scanner link. Premium lets several phones scan at the same time, one per door, booth or classroom, into the same Sheet: $7 per phone per month. Running several classes, events or lists from one phone? Premium on that one phone is $7 a month, with a separate scanner link for each. Paid yearly, it is $70 per phone per year (2 months free).

How many phones will scan at the same time?

$7 x 2 = $14 a month

Sign in with Google and, on the free plan, the billing page opens with this choice. Nothing is charged until you confirm the card checkout, and you can change the number of phones later.

Questions

How do I generate QR codes from a Google Sheets column?+

Select the column in Google Sheets, copy it, and paste it into the box on this page. Each row becomes its own QR code; if you copy several columns, the first column is used. Then press Print for a label sheet, or download every code as a PNG file in one ZIP.

Is there a limit on how many QR codes I can make?+

500 per sheet, which covers a class list, a stockroom shelf, or a full asset register. There is no daily limit and no account needed.

Do these QR codes expire?+

No. They are static codes that contain your text directly, so there is no redirect and nothing to expire. They will still scan in ten years. Many free generators create dynamic codes that stop working when a trial ends — these are not that.

Is it really free, with no signup and no watermark?+

Yes. No account, no email, no watermark, no usage cap on this tool. The codes are generated in your browser, so your list is never uploaded to us.

What label sheets does the print layout support?+

On A4, the 3 x 8 layout matches Avery L7159 address labels and 2 x 4 matches L7165 shipping labels. On US Letter, 3 x 10 matches Avery 5160 address labels and 2 x 5 matches 5163 shipping labels. The 4 x 6 and 5 x 10 grids print on plain paper with cut guides. Print at 100% scale, not Fit to page.

How do I record the scans somewhere?+

A QR code on its own just holds text — something has to read it and write it down. QR to Sheets gives you a link that your team opens in a phone browser to scan these codes into a Google Sheet, with no app install and no accounts for them.

Will these codes scan reliably when printed?+

Yes, if you keep them at a reasonable size. The print layout never renders a code below about 18mm, which is the practical floor for a phone camera at arm's length. Print in black on white and avoid scaling the page down.