Markdown Tools
Tool · New
18 free Markdown tools that run in your browser: an editor, slides, a README generator, Markdown to PDF, Word, Slack and Jira, a linter and more.
New
Tool
Print Labels from a Spreadsheet
Paste rows from a spreadsheet, pick your label sheet and download a PDF that lines up with it: every row becomes a label.
Loading the label maker…
Start from a ready-made setup
- Address Labels Mailing labels from a contact list, on Avery 5160 and other sheets.
- CSV to Labels Open a CSV or Excel file and print a label for every row.
- QR Code Labels A QR code on every label, from a column of links or IDs.
- Barcode Labels Code 128 barcodes for SKUs, part numbers and asset tags.
- Return Address Labels Your address on every label, 80 to a sheet.
- Name Tag Labels Stick-on name badges from a guest or attendee list.
How to print labels from a spreadsheet
- Copy the rows from Excel or Google Sheets, heading row included, and paste them in. Or open a CSV or .xlsx file.
- Pick your label sheet by its product code, such as 5160 or L7160. The layout fills itself in from your column names; edit it, or click a field to add it.
- Click any labels already used on your sheet, then download the PDF and print it at Actual size (100%).
Good to know
Each row of your list fills one label. Fields in curly brackets, like {Name}, take the value from that column, a line whose fields are all empty is left out, and long text shrinks to fit. Add a QR code or barcode from any column.
Questions
Do I need Word or Avery Design & Print?
No. This is a label mail merge in your browser: paste your list, choose the sheet and download a PDF. There's nothing to install and no account.
Is my list uploaded?
No. Your rows are read and the PDF is made in your browser, so names and addresses never leave your computer. They're remembered in this browser until you clear them.
My labels print slightly off. How do I fix it?
First make sure the print dialog says Actual size or 100%, not Fit to page. Then print the alignment test on plain paper and hold it against a label sheet up to the light. If every label is off the same way, move the content with Nudge; it's remembered for next time.
Can I use a sheet that's already partly used?
Yes. Click the labels that are gone in the preview, or enter how many are used, and printing starts at the next free label.
Is LabAnvil affiliated with Avery?
No. Avery is a trademark of Avery Products Corporation. Sheets are listed by their product codes so you can find yours, and any sheet with the same layout works just as well.
Label sheets it prints on
Find your sheet by the product code on the packet. Sheets in the same row share one layout, so any of them prints the same way. Not listed? Choose Custom sheet and enter the sizes from the packet.
| Sheet | Label size | Per sheet | Same layout |
|---|---|---|---|
| Avery 5160 | 1 × 2⅝ in | 30 | 8160, 5260, 5960, 8460, 18160, 18660, 5520, 8660, 15160 |
| Avery 5161 | 1 × 4 in | 20 | 8161, 5261, 5961, 8461, 18161 |
| Avery 5162 | 1⅓ × 4 in | 14 | 8162, 5262, 5962, 8462, 15162, 18162, 18662 |
| Avery 5163 | 2 × 4 in | 10 | 8163, 5263, 5963, 8463, 15163, 18163, 18663 |
| Avery 5164 | 3⅓ × 4 in | 6 | 8164, 5264, 8464 |
| Avery 5167 | ½ × 1¾ in | 80 | 8167, 5267, 8667, 15167, 18167, 18667 |
| Avery 5366 | ⅔ × 3⁷⁄₁₆ in | 30 | 8366, 5266, 5966, 8066 |
| Avery 5395 | 2⅓ × 3⅜ in | 8 | 8395, 5895, 15395 |
| Avery 5168 | 3½ × 5 in | 4 | – |
| Avery 5126 | 5½ × 8½ in | 2 | 8126, 5526, 18126, 15516 |
| Avery 8165 | 8½ × 11 in | 1 | 5165, 5265, 8465, 8665 |
| Sheet | Label size | Per sheet | Same layout |
|---|---|---|---|
| Avery L7160 | 63.5 × 38.1 mm | 21 | J8160 |
| Avery L7161 | 63.5 × 46.6 mm | 18 | J8161 |
| Avery L7162 | 99.1 × 33.9 mm | 16 | J8162 |
| Avery L7163 | 99.1 × 38.1 mm | 14 | J8163 |
| Avery L7165 | 99.1 × 67.7 mm | 8 | J8165 |
| Avery L7169 | 99.1 × 139 mm | 4 | J8169 |
| Avery L7651 | 38.1 × 21.2 mm | 65 | L7551, J8651 |
| Avery Zweckform 3474 | 70 × 37 mm | 24 | – |
| Avery Zweckform 3475 | 70 × 36 mm | 24 | 3490 |
| Avery L7167 | 199.6 × 289.1 mm | 1 | J8167 |
| Sheet | Label size | Use | Same layout |
|---|---|---|---|
| 4 × 6 in | 4 × 6 in | Shipping labels (Rollo, Zebra, MUNBYN…) | – |
| 2¼ × 1¼ in | 2¼ × 1¼ in | Product and barcode labels | – |
| 2 × 1 in | 2 × 1 in | Small product labels | – |
| Dymo 30252 | 28 × 89 mm | Address labels | 99010 |
| Dymo 99012 | 36 × 89 mm | Large address labels | – |
| Dymo 30336 | 25 × 54 mm | Multipurpose labels | – |
| Dymo 30334 | 57 × 32 mm | Multipurpose labels | 11354 |
| Dymo 30256 | 59 × 102 mm | Shipping labels | – |
About
A label mail merge that runs in your browser. Paste rows from a spreadsheet or open a CSV or Excel file, and every row becomes a label: mailing addresses, product and asset tags, name badges, or anything else you keep in a list.
Pick the sheet you bought by its product code, from Avery 5160 address labels to A4 L7160 and thermal 4 × 6 in shipping labels, and the PDF lines up with it. Partly used sheet? Click the labels that are gone and printing starts at the next free one.
How it works
- Fields from your columns. Put {Name}, {City} or any heading on the label. A line whose fields are empty is left out, so there are no gaps where an address has no second line.
- Text that fits. Long lines shrink, then wrap, to stay on the label, and the preview warns about anything that still doesn’t fit.
- QR codes and barcodes. Add a QR code or a Code 128 barcode from any column, sized in whole printer dots so it scans.
- Sheets that line up. 29 layouts for US Letter, A4 and label printers, or enter your own. An alignment test and a nudge setting fix printers that print slightly off.
- Private. Your list is read and the PDF is made on your device; nothing is uploaded.
Notes
Print at Actual size or 100%, not Fit to page. Avery is a trademark of Avery Products Corporation; LabAnvil isn’t affiliated with Avery. Sheet layouts are from the manufacturers’ published sizes and the gLabels template database.
More tools
See allPrintable Planners & Trackers
Tool · New
14 free printable planners and trackers: weekly and monthly plans, routines, meals, chores, budgets, workouts and more. Edit and print in your browser.
Secret Santa Generator
Tool · New
Draw names for Secret Santa in a minute: keep couples apart, set a spending limit, and send everyone a private link to reveal their match and share a wishlist. No sign-up, no emails.