QRStickerly Blog · May 2026

How to Generate Bulk QR Codes from Excel

One QR code takes ten seconds to make. Five hundred — for event tickets, product labels or asset tags — would take a day by hand. The right way is bulk generation: a spreadsheet goes in, a ZIP of QR code images comes out. Here's the complete process, free, with no signup.

What you'll need

Just a spreadsheet — Excel (.xlsx), the older .xls, or a plain CSV — and a browser. Our bulk QR code generator reads the file and generates every code locally on your computer; your data never touches a server, which matters when the spreadsheet contains customer links or internal asset IDs.

Step 1: Format the spreadsheet

The format couldn't be simpler:

Column A — the content of each QR code, one per row. Usually a URL (https://yoursite.com/ticket/0001) but any text works.
Column B (optional) — the file name for that code's image, e.g. "ticket-0001". Leave it blank and files are auto-numbered qr-001, qr-002…

No headers needed; if you have a header row, just delete it or let the first "code" be a throwaway. Building sequential links fast is a job for Excel itself: put your base URL in a formula like ="https://yoursite.com/item/"&ROW() and drag down 500 rows.

Step 2: Upload and check the preview

Drop the file into the generator. It immediately shows how many codes it found and previews the first rows — a ten-second sanity check that catches the classic mistake of uploading the wrong sheet. Up to 1,000 codes per file are supported; split bigger jobs into multiple files.

Step 3: Pick a size and generate

Choose the image resolution: 300 px is fine for screens, 800 px for anything that will be printed. Click generate, watch the progress bar, and a single ZIP downloads with every QR code as a named PNG.

Step 4: Print them (the part most guides skip)

Identical codes (same link on every sticker) — skip the spreadsheet entirely and use the sticker sheet maker, which tiles one code onto a print-ready A4 PDF.
Unique codes — use Word's Mail Merge with labels, or any label software (Avery templates, Brother/DYMO apps), pointing it at your folder of PNGs. Match the label size to our print size guide — 25 mm minimum for handheld scanning.

Real-world uses

Event tickets — one validation link per attendee from your registration sheet.
Product labels — each SKU links to its own page; pairs naturally with retail barcodes (see barcode vs QR).
Asset tags — laptops, tools and library books, each pointing to its record.
Table numbers — table-1 through table-40, each opening the menu with the table pre-selected.
Certificates — a verification link per certificate number.

Pro tips

Test rows 1, 2 and the last row before printing the whole batch.
Keep URLs short — shorter content makes sparser, easier-scanning codes at small sizes.
Keep the spreadsheet; it's your master record of which code points where.