Make labels

Barcode labels from Excel

Drop a price list or a stock sheet: names, articles, sizes and barcodes become labels for a thermal printer or a sticker sheet. Column titles are recognised in seven languages and in marketplace exports.

  • XLSX · CSV · paste
  • EAN-13 · Code 128 · QR
  • Rolls · A4 · Letter

Add your products

The file is read on your computer. Nothing is uploaded.

Choose the label

Size, look and barcode type. Opens as soon as your products are in.

Download and print

A preview of every label and one PDF for your printer.

Your label shows up here

Add products on the left, or try the example.

Printing labels right

Thermal roll

  1. In the printer settings (Windows: Printers → your printer → Printing preferences) set the paper to the label size, for example 58 × 40 mm.
  2. Open the PDF and print with “Actual size” or 100 %. One PDF page is one label.
  3. Labels come out sideways? Tick “Turn a quarter” in More settings, or change the orientation in the printer settings.

Sticker sheets

  1. Print a test page on plain paper first, put it on top of a sticker sheet and hold both against the light.
  2. Print with “Actual size” or 100 %, paper A4 or Letter as in the preset. Turn off “Fit to page” and “Shrink oversized pages”.
  3. Still off by a millimetre or two? Set the printer offset in More settings; it is remembered for this sheet.
  1. 1

    Add the list

    Drop the .xlsx or CSV file, or paste cells straight from Excel or Google Sheets.

  2. 2

    Check the label

    Tick the fields to print. Problems with codes are listed by row number; Excel's usual damage is repaired for you.

  3. 3

    Print

    Download the PDF and print at 100 %. A quantity column prints that many copies of each label.

Column titles it understands

Keep your own columns. Titles are matched in English, Russian, Spanish, Portuguese, German, French and Italian, and in the exports of Wildberries, Ozon, Shopify and Amazon:

  • Name: Name, Product, Title, Description
  • Barcode: Barcode, EAN, UPC, GTIN, Variant Barcode, FNSKU
  • Article: SKU, Article, Item code, Variant SKU
  • Price: Price, Sale price; old price: Compare at price, Was, MSRP
  • Number of labels: Qty, Quantity, Copies, Labels
  • Size, Colour, Brand, Material, Country, Weight, Date

A column without a title is found by its content: a column of 13-digit numbers is taken for barcodes. If a guess is wrong, pick another column in the list.

What Excel does to barcodes, and what happens to it here

  • 4.60701E+12. From an .xlsx file the full number is read: the file keeps all digits even when the cell shows the short form. Text that only holds the short form has lost digits; such rows are flagged, not guessed.
  • Lost zero in front. Put back when the cell format (such as 0000000000000) or the check digit confirms it.
  • 12 digits for EAN-13. The check digit is added.
  • Wrong check digit. Not printed: the row is shown so you can correct the typo.

One label per unit

With a quantity column, each row prints as many labels as it says: 12 pairs of size 42, 7 of size 43. Rows with 0 and total rows are skipped. You can also print a fixed number of copies of every label.