Make labels

Excel / CSV → print-ready PDF

Barcode labels from Excel, ready to print

Drop a price list, get a PDF for a thermal label printer or for A4 and Letter sticker sheets. Etiq fixes what Excel does to barcodes and sizes every bar for your printer.

  • Free
  • No sign-up
  • Files stay on your computer
  • EAN-13 · Code 128 · QR · Data Matrix

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.

01 — The spreadsheet

Excel breaks barcodes. Etiq puts them back.

Codes are numbers to Excel, and it treats them like numbers. Every row is checked before anything is printed.

  1. 01

    4.60701E+12

    4607012345677

    Scientific notation

    Excel shows a 13-digit code as 4.6E+12. The .xlsx file still holds the real number, and that is what gets printed.

  2. 02

    36000291452

    036000291452

    Lost leading zero

    A number can't start with 0, so Excel drops it. It comes back when the cell format or the check digit confirms it.

  3. 03

    460701234567

    4607012345677

    Missing check digit

    Twelve digits in, thirteen out: the last digit is worked out with the GS1 formula.

  4. 04

    4607012345678

    should end in 7

    A typo stays visible

    A wrong check digit means a wrong code. The row is shown to you instead of printing a barcode of some other product.

02 — The paper

Thermal roll or sticker sheet

The same list prints on both. Sizes come from the manufacturers' templates, so the print lands on the sticker.

BasicaFleece hoodieSKU HD-220-GR · Size L · Colour Heather grey$595012345600031
SprintexSport socks, 3 pairsSKU SC-031 · Size 6–9 · Colour White$125012345600048
Home & TeaCeramic mug 12 ozSKU MG-350-BL · Colour Blue$9.505012345600055

Label printers

58 × 40 mm for marketplaces, 4 × 6 in for Amazon FBA and couriers, 2.25 × 1.25 in FNSKU, or any size you set. One PDF page is one label.

SprintexTrail running shoes GaleSKU SNK-402-W · Size 9 · Colour White$895012345600017BasicaOrganic cotton tee, oversizedSKU TS-118-BK · Size M · Colour Black$245012345600024BasicaFleece hoodieSKU HD-220-GR · Size L · Colour Heather grey$595012345600031SprintexSport socks, 3 pairsSKU SC-031 · Size 6–9 · Colour White$125012345600048Home & TeaCeramic mug 12 ozSKU MG-350-BL · Colour Blue$9.505012345600055UrbanixCity backpack 20 LSKU BP-20-OL · Colour Olive$795012345600062DenimoStraight stretch jeansSKU JN-501-IN · Size 32/34 · Colour Indigo$645012345600079BasicaCuffed knit beanieSKU HT-012-RD · Size One size · Colour Red$185012345600086SprintexTrail running shoes GaleSKU SNK-402-W · Size 9 · Colour White$895012345600017BasicaOrganic cotton tee, oversizedSKU TS-118-BK · Size M · Colour Black$245012345600024BasicaFleece hoodieSKU HD-220-GR · Size L · Colour Heather grey$595012345600031SprintexSport socks, 3 pairsSKU SC-031 · Size 6–9 · Colour White$125012345600048Home & TeaCeramic mug 12 ozSKU MG-350-BL · Colour Blue$9.505012345600055UrbanixCity backpack 20 LSKU BP-20-OL · Colour Olive$795012345600062DenimoStraight stretch jeansSKU JN-501-IN · Size 32/34 · Colour Indigo$645012345600079BasicaCuffed knit beanieSKU HT-012-RD · Size One size · Colour Red$185012345600086SprintexTrail running shoes GaleSKU SNK-402-W · Size 9 · Colour White$895012345600017

Click a free sticker

Office printers

A4 and US Letter sheets with 6 to 80 stickers: Avery L7160, L7651, 5160, 5163 and the common unbranded ones. Half a sheet left from yesterday? Start from the first free sticker.

03 — The scanner

Bars cut to your printer's dots

A 203 dpi label printer draws with dots 0.125 mm wide. A 0.33 mm bar falls between dots and prints as two dots or three, so widths jump and scanners stumble. Etiq builds every bar from whole dots, keeps the white margins around the code and warns before you print when a code is too small.

  • Check digit verified
  • White margins kept
  • Bars in whole printer dots
  • Bar height checked
  • Printing at 100 % set in the PDF
Exact size, uneven print
Whole dots, even print

203 dpi · 1 dot = 0.125 mm

04 — Your data

Your price list stays on your computer.

The file is read and the PDF is made inside your browser. There is no upload and no account, and the page isn't allowed to send data anywhere: its security policy only lets it load files from this site.

$Content-Security-Policy: connect-src 'self'

05 — Who uses it

One tool instead of five

  • 01WB · Ozon · Amazon

    Marketplace sellers

    Product labels with EAN-13 or Code 128, article, size and EAC. FNSKU labels. Marking codes next to the barcode.

  • 02Shops

    Price tags

    Big prices, the old price crossed out and the discount worked out. Plain paper with cut lines, or sticker sheets.

  • 03Warehouses

    Bins and boxes

    Shelf and bin numbers in a series, 4 × 6 box labels with ITF-14 and a QR code.

  • 04Workshops

    Serials and QR tags

    Serial numbers, QR codes to manuals or a website, inventory tags for equipment.

Questions

Is it really free?
Yes. No account, no watermark, no trial. One PDF holds up to 20,000 labels.
Is my file uploaded anywhere?
No. Your browser reads the file and makes the PDF on your computer. The page's security policy doesn't allow it to send data to other sites.
Which printers work?
Any printer with a driver. Label printers (Xprinter, Zebra, TSC, Godex, Rollo, Dymo) print the roll sizes; office laser and inkjet printers print the sticker sheets and price tags.
How do I print labels at the right size?
Set the paper to the label size in the printer driver, open the PDF and print at 100 % or Actual size. The PDF also tells the viewer not to scale it.
Where do I get barcodes for my products?
Codes for selling in shops and on marketplaces come from GS1 or from the marketplace (in your seller account). For your own shop or warehouse, the Numbers tab makes EAN-13 codes with the in-store prefix 200.
Which barcode type should I choose?
EAN-13 (UPC-A in North America) for retail goods, Code 128 for articles, bins and FNSKU, ITF-14 for cartons, QR for links, Data Matrix for marking codes. Automatic picks the type from your data.
Does it follow the rules of my country?
It prints what the rules ask for when your list has it: the price per kilogram or litre that the EU and the UK require on price tags, the MRP inclusive of all taxes for India (choose INR as the currency), marking codes with their separators for Russia, Kazakhstan and Uzbekistan, FNSKU labels for Amazon. Rules change: check what your country and marketplace ask for before a big print run.
The print is a little off the stickers.
Print the test page, compare it with a sheet against the light and set the printer offset in More settings. It is remembered for that label size.
Can I use Google Sheets, Numbers or LibreOffice?
Yes. Numbers and LibreOffice (.ods) files open as they are, and so do old Excel files (.xls). From Google Sheets, copy the cells and paste them in the Paste tab, or download the sheet as .xlsx or CSV.