Bulk QR Code Generator from Excel List (Free)
Built by Najeeb · last updated August 13, 2026 · checked against our testing process
Paste your list from Excel or Google Sheets
One QR code per row. Two columns work too: Label [TAB] Value: copy two columns straight from Excel and the first becomes the printed label, the second becomes the QR content (URL, text, SKU, anything). Single-column rows use the value as both.
Related: QR campaign tracker spreadsheet · all QR code tools
How to generate QR codes from an Excel list
- Prepare two columns in Excel or Google Sheets: column A: the label to print under each code; column B: the URL or text the QR should contain. One column also works.
- Copy the rows: select both columns and copy (Ctrl+C). Excel puts a tab between columns, which this tool reads automatically.
- Paste into the box and click Generate: up to 200 QR codes per batch, created instantly in your browser.
- Download or print: each code has its own PNG download, or use Print All for a label sheet with names under every code.
- Nothing is uploaded: the entire process runs locally; your product lists and URLs never leave your device.
Bulk QR codes straight from a spreadsheet
If you manage inventory, event tickets, asset tags, or product links, your data already lives in Excel, and generating QR codes one at a time is miserable. This tool takes a straight copy-paste from Excel or Google Sheets and turns every row into a labeled QR code: up to 200 per batch, each downloadable as a PNG, all printable as a single sheet.
The two-column trick
When you copy two spreadsheet columns, Excel separates them with a tab character. This tool reads that: the first column becomes the human-readable label printed under the code, the second becomes the QR content. Asset tag + URL, product name + SKU, guest name + ticket link: any pairing works. Single-column paste works too; the value doubles as its own label.
What people batch-generate
Inventory and asset tags: SKU labels that scan to an internal sheet or product page. Event check-in: one code per guest linking to their ticket. Restaurant tables: table-numbered codes to the same menu URL. Field equipment: serial-numbered codes to maintenance logs. Anything you'd mail-merge, you can QR-merge.
Private by design
Most bulk QR services want a CSV upload: meaning your product database, client list, or asset register lands on someone's server. Here, generation happens entirely in your browser with JavaScript. Close the tab and nothing persists. That's not a policy promise; it's how the tool is built.
Related QR tools
Single codes with more options: our WiFi QR generator for guest networks, or the QR code generator for labels. Need to check what's inside a code? Use the safe QR scanner: it checks links against threat databases before you open them.
Newer QR tools
Also try the LinkedIn QR code generator, the QR code for PDF, and the transparent QR code generator.
Generating QR codes from an Excel column, step by step
- Open your workbook and select the single column holding the values: URLs, SKUs, asset tags, serial numbers. One value per row.
- Copy the column. Headers can be included; blank rows are ignored.
- Paste into the box above. Each row becomes one code.
- Add a second column first if you want each code labelled underneath. The label is printed with the image, which is what makes a sheet of them usable.
- Download the set as a ZIP. Filenames follow the label so they stay matched to their rows.
Nothing is uploaded. The codes are drawn in your browser, which matters when the column contains customer URLs, internal asset numbers, or anything else you would rather not paste into someone else’s server.
The same process in Google Sheets
Sheets works identically: select the column, copy, paste. It is worth knowing what the alternative costs you. The commonly shared Sheets trick builds an image formula pointing at a third-party chart service:
=IMAGE("https://example-chart-api/?chs=200x200&cht=qr&chl="&A2)
Three problems come with that approach. Every cell sends its value to an external server. The images are live requests rather than files, so they disappear if the service changes or goes away, and the best known one was deprecated years ago. And you cannot easily export the results as real image files for a print run.
Why not an Excel add-in
Add-ins can work, but they carry the usual costs: an install, macro permissions, and in a managed workplace an IT approval. For a one-off batch of labels that is a lot of process. The practical dividing line is repetition: if you generate codes weekly as part of a documented workflow, an add-in earns its setup. For a batch of asset tags this afternoon, pasting a column is faster.
Choosing settings for a print run
| Use | Error correction | Why |
|---|---|---|
| Screen or PDF only | L or M | Nothing will damage it; keep the pattern simple |
| Paper labels, indoors | M | The usual default, tolerates light wear |
| Asset tags, workshop or outdoor | Q or H | Survives scuffing, dirt and partial damage |
Higher correction means a denser symbol for the same data, so it needs either more physical space or a shorter value. Shortening the URL is usually the better lever. It reduces the module count directly and makes the code easier to scan at small sizes.
Frequently Asked Questions
How do I make QR codes from an Excel file?
Open your sheet, select the label and value columns, copy, paste into the box above, and click Generate. No file upload needed: the paste carries the data.
Is there a limit on how many QR codes I can generate?
200 per batch to keep your browser responsive. For larger lists, paste in chunks: there's no total or daily limit.
Is my spreadsheet data uploaded anywhere?
No. Codes are generated locally in your browser with JavaScript. Nothing is sent to our server or stored.
Can I print them as labels?
Yes: Print All lays out every code with its label underneath. For Avery-style label sheets, set your printer scale to 100% and use the browser's print preview to check alignment.
Do these QR codes expire?
Never. They're static codes: the data is encoded directly in the image, with no redirect service behind it. They work as long as the content (like a URL) itself stays valid.