QR codes from a spreadsheet, ready for labels
- In Excel, format asset IDs as Text before entering leading zeroes. Choose File → Save As → CSV UTF-8 (comma delimited). Export the needed sheet only; this tool does not read Excel workbooks.
- Open the local CSV, paste spreadsheet cells, or enter one value per line. Map payload, optional caption, filename and copies. Check the exact values; no trimming, number conversion or URL rewriting is applied.
- Fix row errors or explicitly exclude rows. Confirm repeated payloads if they are intentional. Choose a sheet and mark used positions on its first page.
- Download the calibration PDF and print on plain paper at 100%. Adjust offsets if necessary. Preview the label PDF, then download the vector PDF or code images with their manifests.
A partly used sheet, without wasting the rest
The original sample has four inventory rows and five labels because asset 000042 needs two copies. On a Letter Avery 5160 sheet, mark slots 1, 2 and 5 as used. The five labels occupy slots 3, 4, 6, 7 and 8 on page 1. Later sheets start at slot 1. The downloadable example PDF shows this exact placement.
Download label PDFPrint at Actual size / 100%. Turn off Fit, Shrink and browser headers/footers. Use the matching paper size and single-sided printing. Measure the 50 mm calibration rule, then hold the plain-paper sheet over your stock. Adjust offsets and repeat before using labels.
Tested batch limits
Desktop: up to 1,000 total codes for SVG ZIP and PDF; 200 for PNG ZIP. Narrow/mobile browsers: 200 SVG/PDF or 100 PNG. Copies count toward each limit. CSV: UTF-8, up to 1 MB, 1,000 rows, 32 columns; payload: up to 1,200 UTF-8 bytes; 1–100 copies per row. These are browser lab limits; physical printing and real-phone scans are not yet verified.
Questions before you print
Are these QR codes free and permanent?
They are static QR codes with the exact payload inside them. No Taskono redirect or subscription is involved. A link still depends on its destination staying available.
What happens to Unicode and leading zeroes?
Payload strings, row order and Unicode are preserved. JSON manifests keep exact values. CSV manifest text cells are prefixed with an apostrophe to protect spreadsheet users from formulas and automatic number conversion; use JSON for exact round trips. The included caption font supports Latin, Greek and Cyrillic; unsupported caption glyphs block PDF generation until edited or captions are turned off.
Does a stock preset guarantee alignment?
No. The Avery 5160 preset follows the original vendor geometry, but printer feed, nonprintable areas and scaling can vary. Check the calibration on plain paper. Generic grids are not a stock compatibility claim.
How can I reuse a partly used sheet?
Mark the missing labels in the first-sheet slot selector, preview the actual PDF, and check the manifest for each row’s page and slot. Follow your printer and stock manufacturer’s advice about feeding a used sheet.
Can I cancel a large export?
Cancel terminates the local worker and discards its incomplete output. Rows and settings stay available for a clean retry. Nothing is saved automatically or uploaded.