QR code labels: print sheets from Excel
One QR code per row of your spreadsheet, printed next to its name and ID on the label sheets you already have. Static codes with no subscription and no expiry.
- 100% free
- No usage limits
- No sign-up
- Nothing uploaded: runs in your browser
No file at hand? .
Layout and text
Printer alignment
Print the PDF at 100% (“Actual size”), not “Fit to page”.
| Row | Problem | Content |
|---|
How to print QR code labels from Excel
- Add your list. Choose an Excel or CSV file, or paste one link or ID per line.
- Say what goes in the QR code and beside it. A link, an ID, or a pattern such as https://example.com/assets/{Asset ID}, plus up to three text lines.
- Choose your label sheet. On wide labels the text goes to the right of the code; on square ones, underneath. The preview shows the first sheet.
- Create the PDF and print it at 100%. Each code is read back and compared with your data before you download.
What people use them for
- Storage bins and moving boxesScan the lid to see what is inside without opening it.
- Asset tagsLaptops, tools and furniture with their inventory number and a link to the record.
- Inventory and warehouse locationsA code per shelf, bin or pallet position.
- Products and packagingA link to the manual, the ingredients or a reorder page on each unit.
- Events and classroomsA personal link or ID for each attendee, student or piece of equipment.
Label sheets included
- US Letter (Avery)5160/8160 (30 per sheet), 5161 (20), 5162 (14), 5163 (10), 5164 (6) and 5167 (80).
- A4 (Avery)L7651 (65 per sheet), L7159 (24), L7160 (21), L7161 (18), L7162 (16), L7163 (14), L7173 (10) and L7165 (8).
- A4, edge to edgeThe sizes sold by APLI, Herma and store brands: 70 × 37 mm (24), 70 × 35, 70 × 42.4, 105 × 37, 105 × 57, 105 × 148, 52.5 × 29.7, 48.5 × 25.4, 38 × 21.2 and more.
- Label printersOne label per PDF page for thermal and roll printers: 40 × 30, 50 × 30, 58 × 40, 100 × 50 and 100 × 150 mm, 2.25 × 1.25 in and 4 × 6 in.
- Anything elseType the measurements printed on your box: label size, columns, rows, margins and gaps.
Print a test page first
Set your printer dialog to 100% or “Actual size”. “Fit to page” shrinks the sheet by a few percent, and by the last row the print is off by several millimetres.
Print the first page on plain paper with “Print the outline of each label” turned on, and hold it against a label sheet in front of a window. If the whole grid is shifted, enter the difference in “Shift right” and “Shift down”; negative numbers move it left or up. Then turn the outlines off and print on the real sheet.
Sizing a QR code for a small label
The more a code contains, the more dots it needs and the smaller each dot prints. Keep the content short: an ID or a short link instead of a long address with tracking parameters. Error correction L gives the largest dots; choose a higher level only for labels that will get scratched or dirty. Rows whose dots would print under 0.25 mm are flagged before you print.
Private by design
Asset lists, locations and internal links stay on your device. Your browser reads the spreadsheet and builds the PDF in a background worker.
Known limits
- Codes are static: the content cannot be edited or tracked after printing. To change destinations later, point the code at a page you control.
- With more than 5,000 QR codes, a regular sample of 5,000 is read back instead of all of them, and the result says so. The read-back does not replace scanning a printed label with a phone.
- A QR code holds up to about 2,900 bytes at level L. Longer rows are reported rather than truncated.
- Reading the codes back takes time on large lists: in a test on a laptop, 6,000 QR codes at error correction H took about two minutes.
- The templates follow the measurements published for each sheet; they have not been checked against every physical product. Printers also shift by a millimetre or two, so print a test page first.
- Most desktop printers cannot print on the outer 3–5 mm of the paper. On edge-to-edge sheets, the labels on the border keep their content inside a small inner margin, but check your first print.
- Roll formats give a PDF with one label per page. Your label printer’s driver must be set to the same label size; this has not been tested on every printer model.
- Text lines use a standard Western European font. Other alphabets print as “?” in the text, although the QR codes themselves can contain any character.
- The whole PDF is built in memory. A million labels is the hard ceiling for one file, and very large batches depend on the memory of your device.
- Password-protected workbooks must be unlocked first.
Frequently asked questions
Is it really free?
Yes. It is 100% free, with no usage limits, no account, no sign-up, no watermark and no paid plan. There is no cap on rows or labels.
Is my spreadsheet uploaded?
No. Your spreadsheet is read inside your browser and the PDF is built on your own device; nothing leaves it. The page only downloads its own code from this site. If you accept analytics cookies, Google Analytics receives anonymous usage data such as page views, never your files, their names or the contents of your labels.
How do I print QR codes on Avery labels?
Add your Excel file or paste a list, pick the column that goes in the QR code and the text lines, and choose your sheet, for example Avery 5160 or L7160. Create the PDF and print it at 100% on the label sheet.
Do the QR codes expire or need a subscription?
No. They are static: the link or text is stored in the pattern itself, with no redirect through this site or any other service. They work for as long as the content inside them is valid.
How do I make QR labels for storage bins or moving boxes?
List the boxes in a spreadsheet with a name and, if you want, a link to a document or photo album with the contents. Put the link or the box ID in the QR code and the name in the text line. Scanning the label then opens the list of what is inside.
How small can a QR code label be?
It depends on how much the code contains. A short ID or link fits on 38 × 21 mm labels. The page measures the dot size for every row and flags the ones that would print smaller than 0.25 mm per dot, which phones struggle to read.
The print does not line up with my labels. What can I do?
Print at 100% or “Actual size”, never “Fit to page”: scaling is the usual cause. Then print one test page on plain paper with the outlines option on, and hold it against a label sheet in front of a light. If everything is shifted by the same amount, correct it with the horizontal and vertical offsets, in millimetres.
Can I use a sheet that already has some labels peeled off?
Yes. Under “Printer alignment”, set the position of the first label to use, counting from left to right and top to bottom. The preview shows the skipped positions in grey.
Can I add a logo or colours?
No. Labels are printed in black on white, which is what scans most reliably on small stickers. For a single coloured code, use the QR code generator on this site.
Analytics: only if you accept cookies, the page loads Google Analytics (through Google Tag Manager) to count visits and see which tools are used. It never receives your files, your text or the contents of your codes. You can change your choice at any time with “Cookie settings” at the bottom of the page.