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
- 1
Add the list
Drop the .xlsx or CSV file, or paste cells straight from Excel or Google Sheets.
- 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
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.
Label makers
- 58 × 40 thermal labelsThe marketplace standard for label printers.
- Sticker sheetsOffice printer, sticker sheets, no wasted stickers.
- EAN-13 generatorBulk EAN-13 with check digits added and verified.
- Code 128 generatorLetters and digits: articles, bins, internal codes.
- QR code labelsOne QR code per row: links, IDs, inventory.
- Price tagsBig prices, crossed-out old prices, cut lines.
- GS1 Data MatrixMarking codes next to the product barcode.
- Amazon FNSKUCode 128 FNSKU labels for fulfilment.
- Numbered labelsA-0001 to A-0500 without a spreadsheet.