Qodeplate

Bulk barcode generator: print labels from a list

Paste product numbers from Excel or upload a CSV. Check digits are added, invalid lines are flagged, and you get one PDF ready for A4 or Letter label sheets or a thermal label printer. For one code at a time, use the online barcode generator.

Labels
Printer

“Start at label” skips labels already used on a partly used sheet.

How to print barcode labels from Excel

  1. Copy your column

    Select the product numbers in Excel or Google Sheets and paste them in. Copy two columns (number and product name) and the name is printed on each label.

  2. Pick your label sheet

    Choose the sheet that matches the box of labels you bought. The sizes follow the common Avery codes printed on the box.

  3. Print at actual size

    Open the PDF and print at 100%. Do a test print on plain paper and hold it against a label sheet before using the real labels.

Which label sheet should I use?

SheetLabel sizeGood for
65 per sheet (L7651)38.1 × 21.2 mmSmall items, shelf edges, Code 128 stock labels
24 per sheet (L7159)63.5 × 33.9 mmEAN-13 product labels
21 per sheet (L7160)63.5 × 38.1 mmProduct labels with a name
14 per sheet (L7163)99.1 × 38.1 mmBin and rack locations, cartons
30 per sheet (Avery 5160, US Letter)2.625 × 1 inProduct labels in the US and Canada
Thermal roll 57 × 32 mmOne label per pageStock and shelf labels on Zebra or Dymo
Thermal roll 4 × 6 inOne label per pageShipping and carton labels

Bulk label questions

Can I print on a thermal label printer?

Yes. Choose “Thermal label printer” and your label size. The PDF has one label per page, so Zebra, Dymo and Brother printers print one barcode per label. In the print dialog, set the paper size to the label size and print at 100%.

Why does the printer resolution matter?

Thermal printers print in dots, usually 203 or 300 per inch. If a bar falls between two dots it prints too thick or thin and scanners struggle. Pick your printer’s resolution and every bar is sized to whole dots.

My label sheet isn’t listed. What now?

Choose “Custom sheet” and type the label size, margins and gaps from the box. Do one test print on plain paper and hold it against the labels.

What happens to invalid numbers?

They are listed with the line number and left out of the PDF, so one typo doesn’t stop the whole batch.

Is my list uploaded anywhere?

No. The PDF is made in your browser and your product list never leaves your device.