Free barcode labels

Create barcode labels from a list in your spreadsheet. Pick the code type, choose a sheet, and test-scan one label before you print the rest.

Free while in beta · no card needed

How it works

  1. Paste or upload your list. Include a column with the value you want to encode, such as a product code, an order number or a web address.
  2. Choose the barcode type and the column. Pick a code type, such as Code 128 or QR, and the column it should come from. Then choose a sheet, such as Avery® 5160.
  3. Test-scan, then print. Print one label, scan it with your phone or a barcode scanner, and check the result. When it scans, print the rest at the best quality your printer allows.

Make barcode labels

Barcode types

Each type holds a different kind of data. Choose the one your scanner or system expects:

TypeWhat it holdsCommon use
Code 128Letters and numbersStock IDs, asset tags, order numbers
Code 39Capital letters, numbers and a few symbolsSimple inventory and ID labels
EAN-1313 digitsRetail products
UPC12 digitsRetail products in the US
ITF-1414 digitsCartons and cases
QRText or a web linkLinks, menus, product pages

If a system already gives you the number, choose the matching type and paste it in. If you are making your own codes for stock or ID tags, Code 128 is a flexible choice.

Sheets for barcodes

Barcodes need room to scan, so pick a label that is big enough for the bars and the quiet space around them:

SheetSizeLabels per sheetGood for
Avery® 5167½" × 1¾"80Small codes and ID tags
Avery® 51601" × 2⅝"30Medium codes with a short name
Avery® 51632" × 4"10Larger codes and shipping labels
Avery® L7651 (A4)38.1 × 21.2 mm65Small codes on A4 paper

Check each sheet page for the full measurements before you buy.

Before you print

  • Retail numbers come from GS1. If a product will be sold in shops, its UPC or EAN number must be licensed from GS1. LabelPeel does not sell numbers.
  • Test-scan first. Scan one printed label before you print a full sheet. A code that scans on the screen can still fail on paper.
  • Print sharp. Use a laser printer or your printer's best quality. Do not make the bars smaller to fit.
  • Leave a white margin. Keep clear space around each code so the scanner can find the edges.

Ideas you can type

The AI helper changes every label at once. Try asking for:

  • "Make a Code 128 barcode from the SKU column"
  • "Make a QR code from the Website column"
  • "Make the labels for Size L blue"
  • "Put the product name in big letters above the code"
  • "Move the logo to the right and make it smaller" (after you add your logo in the Design step)

For more on setting up a list in a spreadsheet, read how to print labels from Excel.

Tips

  • Use the same column for every label, and check that the codes have no extra spaces.
  • Show the number under the bars if people need to read it by hand.
  • Keep one test sheet in a folder, so you can compare later prints.
  • Print at 100% or Actual size, and turn off Fit to page, or the bars may shrink.

Sheets for this job

Questions

Which barcode types can LabelPeel make?

LabelPeel makes Code 128, Code 39, EAN-13, UPC, ITF-14 and QR codes. It makes them from a column in your list, and it can show the number under the bars.

Can I use any number for a retail barcode?

Not for retail. Retail UPC and EAN numbers must be licensed from GS1, the organization that issues them. LabelPeel does not sell barcode numbers.

Why won't my barcode scan?

The bars may be too small or too blurry. Print at the best quality your printer allows, do not shrink the code, and keep a white margin around it. Then test-scan a printed label before you print the whole sheet.

Which Avery® sheet is best for barcodes?

Avery® 5167 is good for small codes, with 80 labels per sheet. Avery® 5160 and 5163 give the bars more room. Pick the sheet that fits the code and the label size you need.

Skip the mail merge — paste your list and print

Every row becomes one label, lined up on the sheet. Free while LabelPeel is in beta.

Guides