How this online barcode label generator works
Paste your values, one per line, or drop a CSV, TXT or TSV file with up to 1,000 rows. A header row is skipped for you. Pick a format such as Code 128 for stock and SKUs or EAN-13 and UPC-A for retail products, and every row is checked before anything is drawn. Invalid rows are listed with the reason, like a wrong digit count or a wrong check digit, and the valid ones carry on.
Most printable barcode generators hand you one image at a time and leave the layout to you. Here you see a preview of the first 12 barcodes, then choose a label template and download a PDF with each barcode centred on its own label, ready to print. Everything runs in your browser, so we don't receive your list.
If you would rather place barcodes yourself, the same tool also gives you a ZIP of PNG or SVG files. That route suits a label printer or a layout you have already built in Word.
How to print barcode labels on Avery sheets
- Paste your values or drop your CSV. Add a caption after a comma if you want a product name under the barcode.
- Choose the barcode format and fix any rows listed as invalid.
- Pick your label template, for example Avery L7160 on A4 or Avery 5160 on US Letter, or set a custom layout.
- Set copies per value and the label to start at, then turn on the thin outline and download the PDF.
- Print one page on plain paper at 100% scale, hold it against a label sheet to check alignment, then turn the outline off and print on the labels.
- Scan a few labels before you stick them on anything.
Avery barcode labels and custom templates
- Avery L7160: A4, 21 labels per sheet, 63.5 × 38.1 mm. A good all-round size for stock and shelf labels.
- Avery L7651: A4, 65 small labels per sheet, 38.1 × 21.2 mm, for compact Code 128 or Data Matrix codes.
- Avery L7163: A4, 14 labels per sheet, 99.1 × 38.1 mm, with room for long codes and captions.
- Avery 5160: US Letter, 30 per sheet, and Avery 5167: US Letter, 80 per sheet.
- Custom: set the page, rows, columns, label size, margins and gaps in millimetres to match sheets from other online labels suppliers or your own stock.
- Copies per value (1 to 100), start at label N to reuse a part-used sheet, caption under the barcode, padding, and a thin outline for an alignment test print.
Barcode labels in Word, Excel and Google Sheets
- Excel or Google Sheets to labels: put your values in one column, captions in the next if you want them, save or download the sheet as CSV and drop it into the tool.
- Word: download the ZIP of SVG or PNG files, then use Insert, Pictures to place them on a label layout from Mailings, Labels. SVG stays crisp when you resize it.
- Excel: use Insert, Pictures, then Place in Cell in recent Microsoft 365 versions to keep a barcode with its row.
- Google Sheets: Insert, Image, Image in cell, then upload the PNG. It moves and sorts with the row.
- Barcode fonts are the other spreadsheet route, but they need start and stop characters and do not add check digits. A generated image avoids both.
QR code labels, label printers and scanning into Excel
QR codes are not one of the label sheet formats. For QR code stickers, make a batch in our bulk QR code generator, download the ZIP and place the images on your label template. Data Matrix and Aztec are on the label sheet if you need a square 2D code.
Thermal printers from Zebra, Dymo and Brother use their own label software, which imports images. Download the ZIP of PNGs at 1200 or 2400 px wide so the bars stay sharp.
To read labels back into a spreadsheet, most USB and Bluetooth scanners type the number into the selected cell like a keyboard. With no hardware scanner, open the NeoReader scanner on your phone or computer, scan your labels one after another, then download the session list as CSV for Excel or Google Sheets.
