How to Generate QR Codes From a CSV
A CSV is a reliable source for a QR batch only when the identifiers survive spreadsheet editing and every output is tested before the full print run.
By Tools for Labels · Reviewed 18 Aug 2026 · 7 min read
Open Bulk QR Code Generator from CSV →Design the source data before generating
Keep the encoded value separate from the text a person will read. A useful source has columns such as asset_id, display_name, and qr_value; the QR value can be a URL, identifier, or plain text.
Treat IDs as text. Spreadsheet software can remove leading zeroes or change long identifiers before the CSV reaches the generator. Re-open the exported CSV in a text editor and inspect representative rows.
asset_id,display_name,qr_value
0042,North pump,https://example.com/assets/0042
0043,South pump,https://example.com/assets/0043Map and inspect the batch
Upload the CSV to the Bulk QR Code Generator and choose qr_value for QR content and display_name for visible text. The visible label does not change the encoded payload.
Inspect empty values, repeated URLs, unusually long payloads, and non-ASCII text. Scan at least one preview from each distinct data pattern rather than assuming the first row represents the batch.
- Confirm the destination is live and uses HTTPS where applicable.
- Check that redirects do not lead to an unexpected login or expired link.
- Keep an immutable copy of the source CSV with the print job.
Choose PNG, ZIP, or a printable PDF
Use individual PNG files when another layout application will place the codes. Use ZIP for a batch of named images. Use the generated A4 or US Letter PDF when the grid is already suitable.
DENSO WAVE specifies a clear quiet zone four modules wide on every side of a QR symbol. Do not cover that margin with borders, cut marks, text, or the edge of the label.
| Output | Best for | Check before use |
|---|---|---|
| PNG | One-off artwork | No resizing that removes the clear margin |
| ZIP | Mail merge or external label design | Filenames still map to the source rows |
| Direct sheet printing | Paper size and Actual size/100% printing |
Run a physical acceptance test
Print a small sheet on the production printer and stock. Scan codes from the centre and edges, under the expected lighting, using the actual device or app. A screen preview proves the payload exists; it does not prove the final print process is reliable.
Common mistakes
- Letting a spreadsheet remove leading zeroes
- Printing dense payloads in very small cells
- Trimming into the four-module quiet zone
- Changing destination URLs after labels are distributed