How to create QR codes in bulk from a spreadsheet

Five hundred table tents, asset tags or product labels all need their own QR code, and generating them one by one is a day lost. Paste a spreadsheet instead: Qreator parses the rows, renders every code with the same design and hands you a ZIP with matching file names.

1. Prepare the spreadsheet

Export your sheet as CSV with a header row. Only one column is required — the destination — and two optional columns control naming and the caption printed under each code. Commas, semicolons and tabs all work as separators, and quoted fields are handled.

Without a header row the first column is read as the value and the second as the name, and you get a warning saying so. Rows with an empty value are skipped and counted, so the row total you see is always the number of codes that will actually be produced.

2. Paste the rows and check the count

Open the bulk generator, paste the CSV into the box or press Upload CSV to load the file. The parser runs on every keystroke: the line under the box tells you how many codes are ready, and any problem — a missing value column, skipped rows, rows beyond your plan's limit — appears as plain text right there.

Batch size depends on your plan: 25 rows per batch on Free, 250 on Pro and 500 on Business, which is also the hard maximum for a single run. Larger lists are not rejected — only the first allowed rows are generated, so split a long sheet into successive runs.

3. Choose format, size and colours

Pick SVG or PDF when the files go to print: both are vector, so the artwork stays sharp at any size, which is what decides whether a small label still scans. SVG drops straight into a layout program; the PDF arrives at a fixed 40 mm with a quiet-zone margin, ready to hand to a print shop as is. PNG is for proofs, screens and slide decks — the pixel size only affects PNG, and the two colour pickers apply the same foreground and background to every code in the run.

4. Verify the ZIP before it goes to print

1. Open manifest.csv in the ZIP: one line per file with the value it encodes. Spot-check a handful against your source sheet.
2. Scan three codes from the set — the first, one in the middle and the last — to catch an off-by-one column mapping.
3. Confirm file names match what your print supplier expects; the name column is what lands in the layout template.

5. When to use a dynamic bulk import instead

On a paid plan, Bulk import in the dashboard turns each row into a saved dynamic code with its own short link. The printed artwork points at that short link, so you can change the destination later and read scan analytics per code. The CSV there uses name and url columns.

A dynamic import consumes your dynamic-code quota, one code per row, so a 25-row import on Pro uses the whole allowance. If the numbers do not add up, the import stops before creating anything and tells you which limit was hit.