How to print barcode labels from Excel
- Choose a design — a simple barcode label, price tag, shelf label, asset tag and more.
- Add your list: upload the Excel (.xlsx) or CSV file, or copy the cells in Excel and paste them. One row = one label.
- Check the columns: pick which column holds the barcode, the name and the price. The barcode type is set for you — Code 128 for SKUs, EAN-13 for retail numbers.
- Edit the label if you like: drag the barcode, text, logo or QR code, change sizes and the main colour.
- Pick your label sheet — Avery 5160, L7160, an A4 sheet, round labels or a thermal roll — and download the PDF.
- Print at 100% (Actual size). Use "Start at label" for a sheet you have already used part of.
12 ready label designs
| Design | Good for |
|---|---|
| Barcode label | SKU or stock number with the product name — the classic barcode sticker. |
| Price tag | Shops and supermarkets: name, big price and EAN-13 barcode. |
| Shelf label | Shelf edge labels with logo, location, price and unit price. |
| Product label | Your own products: name, details, barcode and batch. |
| Asset tag | Laptops, furniture and equipment: "Property of", serial number and QR code. |
| Inventory bin | Warehouse and stock-room bins with a large code and location. |
| Address / mailing | Envelopes and parcels on Avery 5160 or L7160. |
| Shipping 4 × 6 | Parcel labels for thermal printers: from, ship to and an order barcode. |
| File folder | Office files and lever-arch folders. |
| Name badge | Events, staff and visitors. |
| Jar / round sticker | Jam, honey, candles and gifts on round labels. |
| QR storage label | Moving boxes and storage bins — scan to see what is inside. |
Which barcode type?
| Type | Holds | Use it for |
|---|---|---|
| Code 128 | Letters, numbers, symbols | SKUs, stock, asset, order and tracking numbers — the best choice for your own codes. |
| EAN-13 | 13 digits | Retail products in Europe, Asia, the Middle East, Africa and Australia. |
| UPC-A | 12 digits | Retail products in the US and Canada. |
| EAN-8 | 8 digits | Very small retail packs. |
| Code 39 | A–Z, 0–9, - . $ / + % | Older systems, ID badges, the car and defence industries. |
| ITF-14 | 14 digits | Outer cartons and shipping cases. |
| QR code | Any text or link | Links, asset records, box contents, menus. |
Type 12 digits for EAN-13 (11 for UPC-A, 7 for EAN-8, 13 for ITF-14) and the check digit is added; type all of them and it is checked. Retail barcodes for shops need numbers from GS1 — do not invent them.
Avery and A4 label sizes
| Sheet | Labels | Size |
|---|---|---|
| Avery 5160 / 8160 | 30 per sheet | 2⅝ × 1 in (66.7 × 25.4 mm) |
| Avery 5163 / 8163 | 10 per sheet | 4 × 2 in (101.6 × 50.8 mm) |
| Avery 5167 | 80 per sheet | 1¾ × ½ in (44.5 × 12.7 mm) |
| Avery L7160 | 21 per sheet | 63.5 × 38.1 mm |
| Avery L7163 | 14 per sheet | 99.1 × 38.1 mm |
| Avery L7651 | 65 per sheet | 38.1 × 21.2 mm |
| A4 24 labels | 24 per sheet | 70 × 37 mm |
| A4 12 labels | 12 per sheet | 105 × 48 mm |
Your sheet is not in the list? Choose Your own size, measure a label and the gaps with a ruler and type them in. For Zebra, Rollo, Munbyn and DYMO printers choose a thermal size — one label per page.
Tips for barcodes that scan
- Keep bars at least 0.19 mm wide — the tool warns you when a barcode is too small for the label.
- Leave the white space at both ends of the barcode (the quiet zone); the designs keep it for you.
- Print black bars on white labels. Light colours, glossy film and very low printer quality make scanning harder.
- In Excel, format long numbers as Text so Excel does not turn 6291041500213 into 6.29104E+12 or drop leading zeros.
Frequently asked questions
How do I print barcode labels from Excel?
Upload your .xlsx or CSV file (or copy the cells in Excel and paste them), check which column holds the barcode, choose your label sheet such as Avery 5160 or A4 21 labels, and download the PDF. Print it at 100% (Actual size).
Is this barcode generator really free?
Yes. Every design, every label sheet and the PDF are free, with no sign-up, no watermark and no limit on the number of labels you make.
Which barcode type should I use?
Use Code 128 for your own codes such as SKUs, stock, asset and order numbers — it holds letters and numbers. Use EAN-13 (or UPC-A in the US and Canada) only for retail products with a GS1 number. Use QR codes for links and longer text.
Can I make EAN-13 or UPC barcodes for selling in shops?
The tool draws correct EAN-13 and UPC-A barcodes and adds or checks the check digit. To sell in supermarkets you need numbers that belong to your company, which you get from GS1 in your country — do not make up retail numbers.
Which label sheets are supported?
Avery US Letter (5160, 5161, 5163, 5164, 5167, 5195, 5366, 5126), Avery A4 (L7160, L7159, L7161, L7162, L7163, L7165, L7173, L7651), plain A4 sheets with 8 to 40 labels, round labels, thermal roll labels (2×1 in, 4×6 in, 50×25 mm and more) and any size you type in.
Why don't my labels line up with the sheet?
Print at 100% or Actual size, not Fit to page. Print the test page on plain paper and hold it against the label sheet. If everything is a little off, move all labels with the printer adjustment in millimetres.
Can I print on a partly used label sheet?
Yes. Set Start at label to the first empty label on the sheet, and the used labels are skipped.
Is my data safe?
Yes. Your list and labels are made in your browser and never sent to our server. The work is kept only on this device, and Start over removes it.
Can I make serial numbers or asset tags without Excel?
Yes. Number series makes a list such as IT-0001 to IT-0500 with your own prefix, start, step and number of digits, and can add a GS1 check digit.