Bulk QR code generator: a spreadsheet in, labelled codes out

How to generate QR codes in bulk

This batch QR code generator makes one code per row of your list and hands you a single ZIP. It is free, needs no sign-up, and is private by default: we don't keep your list.

1. Add your list. Paste links or text, one per line, or paste or upload a spreadsheet. The separator and the header row are detected for you.
2. Choose the look. Pick colours and an optional logo, or use the style you saved in the QR code generator.
3. Check the preview. Every row is shown with its row number and label. Bad rows are flagged and skipped, and each code is read back with a scanner to prove it works.
4. Create the ZIP. Choose PNG, SVG or both, and optionally a printable label sheet. Press Create and the codes are made on your device.

How do I tell the QR codes apart?

With hundreds of codes, the hard part is knowing which is which. Four things help, and you can use them together:

• File names. Each file is named from the filename column, else the label, else the row number with leading zeros (0001). A repeat becomes -2, -3, so nothing is overwritten.
• Text under each code. Switch on Show Text Under Each Code and pick where the text comes from: the label column (with an optional sub-label), the file name, the content or the row number. It is printed in the PNG and the SVG, and the code keeps its quiet zone.
• index.csv in every ZIP. One line per row with the file name, its path in the ZIP, content, label and status, ready for a mail merge or a stock list.
• proof-sheet.pdf in every ZIP. A contact sheet of every code with its row number and label, to check a batch at a glance.

Need a numbered series, such as tables 1 to 40? The Number Generator takes a prefix, start, end or count, step, zero padding and suffix, and writes the same number into the code (where you put {n}), the file name and the printed label, so they always match.

Spreadsheet format for bulk QR codes

Only content is required. Put these headers in the first row, in any order. Common alternatives such as url, link, text or data for content, name for filename, title for label and qty for copies work too.

• content: the link or text in the code (required).
• filename: the file name, without the extension.
• label and sublabel: up to two lines printed under the code.
• copies: how many labels to print for this row on a label sheet.
• fg_color and bg_color: optional hex colours for one row, such as #1a3c8b. They override the batch colours, and low contrast is flagged.

Download the example spreadsheet to start from a working file. The old two-column format, content then file name, still works. In Excel or Google Sheets, save as CSV or upload the .xlsx file. Our guide to QR codes in Excel and Google Sheets also shows how to put the images back into the spreadsheet.

Print QR codes on Avery label sheets

Tick Printable Label Sheet and the ZIP also contains sheet.pdf, laid out for your stickers. You can also download just the sheet.

• Sheets: A4 and US Letter, with presets for Avery L7160, L7163, L7651, 5160, 5163 and 5167, or a custom grid with your own columns, rows, margins and gaps.
• Start at label N: skip the labels already used on a part-used sheet.
• Copies: the copies column prints extra labels for a row.
• Cut marks and label outlines, for plain paper and alignment tests.

Print at 100% (“Actual size”), not “Fit to page”, and try one sheet on plain paper first. For bulk barcodes on label sheets, use the bulk barcode generator, or the barcode label generator.

What each row can hold

Each row becomes one QR code. Most people use web addresses: product pages, menu links, review links or unique ticket pages. Plain text works too, such as a serial number, an asset ID or a short message, and a phone camera will show that text when it scans the code. If you need a contact card or calendar code, make it one at a time in the QR code generator, where each type has its own form. A Wi-Fi code can be pasted as WIFI:T:WPA;S:name;P:password;;.

Bulk QR code generator with logo

Many mass QR code tools charge extra for bulk or for styled codes. Here, every code in the batch uses the look you set: code and background colours, an optional logo, and the dot shapes, corners and frame from your saved style. When a logo is present, error correction is raised automatically so each code still scans, and the page tells you how much text one code can then hold.

Every code is read back with a scanner before you download, and the preview shows how many scan OK. Still test one printed code with your phone or the QR code scanner, and test the code with the longest link as well, because longer content makes a denser code.

PNG or SVG for bulk QR codes

• SVG: vector files that stay sharp at any size. Best for print shops, signage, labels and packaging.
• PNG by print size: choose millimetres and 150, 300 or 600 dpi, and the file records its print size. Or choose a width of 500 to 3000 px for web pages, emails and slides.
• Both: they go in png and svg folders in the same ZIP.

For printed sizes, follow our guide to QR code size for printing: at least 2 × 2 cm for close-up scanning.

Can one QR code hold multiple links?

No. A QR code opens one thing when it is scanned. If you want a single code that leads to several links, put the links on one web page, such as a link-in-bio page or a page on your own site, and make a QR code for that page with the link to QR code tool.

If you want many codes, one for each link, that is what this page is for. Paste the list and you get a separate code for every line.

Tips for printing a batch of QR codes

• Name files to match the print layout. Names such as table-01 or sku-4471 make it easy to place each code in the right spot, and index.csv lists them all.
• Pad numbers with zeros. table-01 to table-40 sort in the right order in any folder.
• Keep links short. Shorter content makes a less dense code that scans from further away.
• Print a proof page. Use the proof sheet in the ZIP, and scan a few codes from the first printed sheet before you run the whole job.

Most label and layout programs, such as InDesign data merge or Word mail merge, can place images by file name, so named files save a lot of manual work.

Popular uses for bulk QR codes

• Restaurant tables: one menu or ordering link per table, named by table number. See QR codes for restaurants.
• Events and weddings: a code per guest, seat or session page. See QR codes for weddings and events.
• Stock and assets: a code per item that opens its record, or holds its ID as plain text.
• Products and packaging: one code per product page or manual.
• Classrooms and training: a code per worksheet, video or form.

Bulk QR codes for developers

If you need codes generated automatically, for example one per order or per new product, a script is a better fit than a manual batch. Our guide to generating QR codes in Python, PHP, Java and Node shows the libraries to use and how to keep the codes readable.

Free, no sign-up, private by default

The bulk generator is free with no sign-up and no watermark, up to 1,000 codes per batch. Run another batch if you need more. The codes are made in your browser, and the tool is private by default.

Every code is static: the link or text is stored in the code itself, so there is no service behind it to switch off. The trade-off is that you cannot change a code after printing. Editable dynamic codes with scan analytics are coming soon with NeoReader Pro. Read static vs dynamic QR codes to decide which you need.