QR Label Sheet Generator
Create printable QR label sheets from CSV or text rows, with stock presets, payload-density checks, contrast warnings, and local exports.{{ summaryHeading }}
| # | Page | Slot | Label | Payload | Type | Status | Copy |
|---|---|---|---|---|---|---|---|
| {{ row.number }} | {{ row.page }} | {{ row.slot }} | {{ row.label }} | {{ row.payload }} | {{ row.type }} | {{ row.status }} |
| Check | Status | Detail | Copy |
|---|---|---|---|
| {{ row.check }} | {{ row.status }} | {{ row.detail }} |
| Line | Status | Detail | Copy |
|---|---|---|---|
| {{ row.line }} | {{ row.status }} | {{ row.detail }} |
Printing QR labels turns a digital destination into something that has to survive paper, ink, light, handling, and scanner distance. The encoded text may be valid, but the job still fails if the symbol is too dense for the sticker, the label grid drifts against the stock, or readable text crowds the blank border that QR readers need.
Useful sheets usually carry two kinds of information. The QR symbol stores the machine-readable payload, such as an asset URL, Wi-Fi string, service desk email, phone action, location, calendar record, or plain identifier. The readable label and note help people apply, sort, replace, and audit the sticker without scanning every item. That human layer is especially important on bins, racks, return desks, lab shelves, guest cards, equipment tags, and event materials.
| Factor | What changes | Common mistake |
|---|---|---|
| Payload length | Longer text usually needs a higher QR version with more modules. | Using long URLs or contact records on tiny labels without a scan test. |
| Error correction | Higher levels recover from more damage but leave less room for data. | Choosing the strongest setting for every job and making small labels dense. |
| Quiet zone | The blank border lets readers find the symbol boundary. | Putting text, artwork, or a cut edge too close to the QR modules. |
| Sheet geometry | Margins, gaps, rows, and columns decide where each label lands. | Printing at scaled-to-fit instead of actual size. |
The tightest labels reveal the main tradeoff. A short asset code can scan from a small square, while a long URL, Wi-Fi payload, or contact record may require a larger QR version with more modules. Error correction helps with dirt, scuffs, and wrinkles, but stronger recovery also leaves less room for data in the same printed area.
No layout check replaces a physical scan test. Printer scaling, glossy stock, fading toner, curved surfaces, poor lighting, and older phone cameras can all change the result. For a large batch, print one sheet at actual size, scan several labels from the expected distance, and continue only after the destinations and readable text are correct.
How to Use This Tool:
Start with the label rows, then choose the paper layout and scan checks that match the stock you will actually print.
- Paste values into Label rows, drop a CSV or TXT file, or use Browse CSV/TXT. A row in
label,payload,noteorder gives the clearest label text, and a one-cell row is treated as a payload with an automatic label. - Use Normalize after parsing if you want the rows rewritten into the same three-column order. If Parse Log reports Missing, add a payload such as a URL, asset code, Wi-Fi string, email action, or plain text to that row.
- Set Sheet title for recognizable CSV, DOCX, JSON, and HTML downloads. The title does not print inside each label unless you include it in the row text.
- Pick a Sheet preset. The built-in Avery 5160 / 8160, Avery 5163 / 8163, Letter square asset, and A4 3 x 8 presets fill in paper size, margins, gaps, rows, columns, and label cell dimensions.
Choose Custom label sheet only after measuring the stock, because the fit check uses the entered margins, gaps, rows, columns, and label size directly.
- Set Start position when the first sheet is partly used. The skipped cells stay blank on page 1, and Print Check marks First slot as Review so the offset is not missed.
- Choose Label content, Text position, Error correction, and Cut guides. Use QR-only or smaller text when the label cell is tight, and keep cut guides off for pre-cut stock unless you need a paper test.
- Open Advanced for margins, label gaps, quiet zone, QR scale, text size, foreground and background colors, header-row handling, and duplicate warnings. Print only after Print Check has no Blocked or Missing rows and the physical test sheet scans cleanly.
A Review print status can still be usable, but dense payloads, duplicate destinations, skipped first cells, low contrast, or a small QR side should be scan-tested before a production run.
Interpreting Results:
The summary status tells you whether the current batch is ready to test on paper. Print ready means the parsed rows, sheet fit, quiet-zone value, estimated QR size, contrast ratio, payload capacity, duplicate setting, and QR rendering status are acceptable. Review print means the batch can still be valid, but a warning should be checked before using paper. Print blocked means at least one hard failure should be fixed first.
- Printable Sheet is the visual output to print or download as standalone HTML.
- Label Layout maps every valid row to a page and slot, with label, payload, detected type, and row status.
- Print Check shows the main reliability gates: payload rows, sheet fit, first slot, quiet zone, QR print size, contrast, payload density, duplicates, and QR renderer.
- Parse Log explains skipped headers, missing payloads, duplicate warnings, and truncation above 300 valid rows.
- JSON captures the current sheet settings, QR settings, labels, print checks, and parse log for handoff or audit notes.
Do not read an OK status as proof that every destination is correct or safe. The tool checks payload shape, print geometry, density, and contrast; it does not visit URLs, validate Wi-Fi credentials, confirm email addresses, or inspect where a scanned link will send someone. Scan the printed sample and check the destination behavior before applying labels in bulk.
Technical Details:
QR planning has two separate size problems. The symbol itself grows by version, from 21 by 21 modules at version 1 to 177 by 177 modules at version 40, with four modules added to each side at every step. The printed label has its own fixed width and height. When the payload or error correction setting requires a higher version, more modules must fit inside the same printed square.
Sheet planning adds the physical grid. Margins, gaps, rows, columns, and label dimensions must fit inside the selected paper size, and the first-page start position reduces the usable slots on page 1. A partly used 30-label sheet with eight skipped cells still has 30 slots, but only 22 are available before page 2 begins.
Formula Core:
The core checks compare QR version, paper fit, and contrast against fixed rules. The sheet fit equations use inches because the presets and custom controls are measured as printed dimensions.
Here, V is the estimated QR version, C and R are columns and rows, W and H are one label cell's width and height, and Gx and Gy are the horizontal and vertical label gaps. Sheet fit passes only when the used width is at most the paper width and the used height is at most the paper height. For example, Avery 5160 with 3 columns, 10 rows, 2.625 in by 1 in labels, 0.1875 in side margins, 0.5 in top and bottom margins, and 0.125 in horizontal gaps uses exactly 8.5 in by 11 in.
Transformation Core:
Rows are interpreted as a small label record before any QR symbol is drawn. Header auto-detection can skip a first row such as label,payload,note. With headers present, payload-like columns such as URL, QR, code, value, or destination are used for the encoded value; otherwise, a one-cell row becomes a payload, and a multi-cell row normally reads as label, payload, then note.
| Preset | Paper | Grid | Label cell | Typical fit |
|---|---|---|---|---|
| Avery 5160 / 8160 address | US Letter | 3 x 10 | 2.625 in x 1 in | Short asset IDs, return bins, and compact links. |
| Avery 5163 / 8163 shipping | US Letter | 2 x 5 | 4 in x 2 in | Larger labels with notes or more scan distance. |
| Letter square asset labels | US Letter | 4 x 5 | 1.5 in x 1.5 in | Square tags where the QR symbol is the main element. |
| A4 3 x 8 labels | A4 | 3 x 8 | 2.3 in x 1.25 in | A4 office stock with moderate readable text. |
| Custom label sheet | US Letter or A4 | 1 to 8 x 1 to 14 | 0.25 in to 8 in wide, 0.25 in to 10 in tall | Measured stock that does not match a preset. |
Payload density is estimated from UTF-8 byte length and the selected error correction level. Byte mode keeps the rule predictable across URLs, Wi-Fi payloads, email actions, and plain text. A row becomes Review when it reaches 74% of the estimated capacity, Dense at 90% or higher, and Blocked when it would exceed the maximum version 40 capacity for the selected level.
| Check | Pass or warning rule | Why it matters |
|---|---|---|
| Payload rows | Missing until at least one valid QR payload row is parsed. | No printable symbol exists without encoded text. |
| Sheet fit | Blocked when calculated width or height exceeds the selected paper. | Oversized grids print off the label cells. |
| First slot | Review when Start position skips one or more cells. | The offset is valid, but page 1 capacity changes. |
| Quiet zone | OK at 4 or more modules, Review below 4. | QR readers need blank space around the symbol. |
| QR print size | OK at an estimated QR side length of 0.6 in or larger. | Smaller codes require cleaner printing and closer scanning. |
| Contrast | OK at 4.5:1 or higher, Review from 3:1 to 4.49:1, Blocked below 3:1. | Low light-dark separation can hide modules from a camera. |
| Duplicate payloads | Review when duplicate warnings are enabled and a payload repeats. | Repeated destinations may be intended, but they are easy to miss. |
Error correction levels L, M, Q, and H trade storage capacity for damage recovery. Higher levels are useful for rough handling, dusty shelves, and wrinkled labels, while lower levels leave more room for data on clean, larger labels. The default Q setting is a middle choice for printed labels because it adds more recovery than M without immediately using the densest H option.
Privacy Notes:
CSV and TXT files are read in the browser, and the printable sheet, table exports, JSON, DOCX files, and standalone HTML are produced from the current browser session. A browser QR renderer loads from a third-party CDN before symbols can be drawn or exported.
- Do not paste confidential URLs, credentials, or private contact records unless that CDN load and browser-session handling fit your data rules.
- Generated QR codes encode exactly the payload text you provide; they do not shorten, sanitize, or verify destinations.
- Downloaded HTML contains the QR images and readable label text needed for printing, so treat it like the source data.
Worked Examples:
Asset rack stickers on address stock
A facilities team pastes Asset 042,ASSET-042,Rack A, keeps Sheet preset at Avery 5160 / 8160 address, leaves Error correction at Q, and uses a 4-module Quiet zone. Label Layout should place the row on page 1, slot 1, with Type reported as Text and Status as Ready. Print Check should show Sheet fit, Quiet zone, QR print size, Contrast, and Payload density as OK before the test sheet is scanned.
A partly used first page
For 40 desk labels on Avery 5160 stock, eight cells have already been used. Setting Start position to 8 moves the first new label to slot 9. Because the first page now has 22 usable slots, the batch needs two pages. Print Check marks First slot as Review, which is expected and should match the physical sheet before printing.
A custom grid that cannot fit
A user chooses Custom label sheet on US Letter paper, enters 8 columns and 14 rows, and sets each label cell to 2 in x 2 in. The calculated width is wider than the paper, so Sheet fit becomes Blocked and the summary changes to Print blocked. Reducing columns, choosing smaller cells, or using different stock is required before Printable Sheet should be used.
A row with no payload
A CSV line such as Rack A, supplies a label but no encoded value. Parse Log shows Missing with the detail No QR payload found on this row. Adding a second cell such as an asset code, URL, mailto: action, tel: value, or Wi-Fi payload clears the parsing error.
FAQ:
What row format works best?
Use label,payload,note when you want readable text plus an encoded value. Header row set to Auto skips a first row such as label,payload,note, while Header row set to None treats row 1 as label data.
Why did a row become Review or Dense?
A row becomes Review when its payload approaches the selected QR capacity estimate, Dense at 90% or more, or Review when the payload repeats and duplicate warnings are enabled. Try a shorter payload, a larger label, or a lower error correction level if scan tests fail.
Can I use colored QR labels?
Yes, but keep strong light-dark separation. Contrast is OK at 4.5:1 or higher, Review from 3:1 to 4.49:1, and Blocked below 3:1. Always scan a printed sample because ink, paper, and lighting can change readability.
What happens if I load more than 300 rows?
Only the first 300 valid rows are included for browser rendering, and Parse Log adds a Review entry explaining that the list was truncated. Split larger label jobs into smaller sheets.
Does a successful scan mean the destination is safe?
No. A successful scan only means the printed symbol was readable and encoded the payload text. Check important URLs, Wi-Fi strings, email actions, phone numbers, and asset IDs before using the labels publicly.
Glossary:
- Payload
- The text encoded in one QR label, such as a URL, asset ID, Wi-Fi string, email action, phone number, or plain note.
- Module
- One square cell in a QR Code symbol.
- QR version
- The size class of a QR symbol, from version 1 at 21 by 21 modules to version 40 at 177 by 177 modules.
- Quiet zone
- The blank border around a QR symbol. Four modules on every side is the standard target used by the check.
- Error correction
- The L, M, Q, or H recovery setting that trades payload capacity for tolerance of dirt or damage.
- Sheet preset
- A stored paper and grid layout that sets label size, rows, columns, margins, and gaps.
- Start position
- The number of first-page label cells skipped before the first new QR label is placed.
References:
- Point for determining the code area, DENSO WAVE.
- Standard Address Label or Mailing Label, Avery.
- Understanding Success Criterion 1.4.3: Contrast (Minimum), W3C Web Accessibility Initiative.