Event badges, product labels, asset tags, table numbers, tickets. Any time you need a QR code for every row of a list, making them one at a time gets old fast. Here’s how to do the whole list at once, and print them so they scan.
Step 1: Get your list ready
Put everything you want to turn into a QR code in a single column. One row per code. It can be anything you can type:
- Web links:
https://example.com/ticket/1042 - Product or stock codes:
SKU-00931 - Names, seat numbers or short messages
A few things to tidy up first:
- Remove the header row. Otherwise you’ll get a QR code that says “URL”.
- Remove empty rows. Each blank line would become a blank code.
- Sort the list the way you’ll print it. The files are numbered in the order you paste them.
Step 2: Copy and paste
Select the cells in your column and copy them. In Excel, Google Sheets and Numbers, pasting a column into a text box gives you one value per line, which is exactly what you need.
Paste the list into the batch QR generator. It makes up to 500 codes at a time. For a longer list, split it into chunks of 500.
Step 3: Pick a size and strength
| Setting | Choose | Why |
|---|---|---|
| Image size | 512 px for print, 256 px for screens | A bigger image stays sharp when you resize it in a label or badge template |
| Error correction | Medium for most uses. High for labels that get scuffed, or if you’ll put a logo on top. | Higher settings still scan when part of the code is damaged, but make a denser pattern |
Step 4: Download and match them up
You get a ZIP with one PNG per row. Each file is named after its number and its value:
001-https-example-com-ticket-1042.png
002-https-example-com-ticket-1043.png
003-sku-00931.pngThe number keeps the files in the same order as your spreadsheet. The value tells you which is which at a glance. If you add the images to a mail merge or a label template, sort them by file name and they’ll line up with your rows.
Printing codes that scan
- Don’t print them too small. About 2 cm (0.8 inch) across is a safe minimum for scanning at arm’s length. Codes that hold long links need more room.
- Keep a blank border. Leave a margin of white around each code. Text or a box edge pressed against it can stop phones reading it.
- Dark on light. Black on white is safest. Light codes on a dark background fail on many phones.
- Keep links short. A shorter value makes fewer, bigger squares, which scan faster and survive smaller printing.
- Test one sheet first. Print it, then scan a few codes with two different phones before printing the rest.
Make yours now
The batch QR generator turns a pasted list into a ZIP of QR codes. There’s no sign-up and no watermark, and your list stays on your device. Need just one code, or an SVG you can resize to any size for print? Use the QR code generator. To check what a code says, use the QR code reader.