Print barcode labels by quantity from Excel

15 in stock should mean 15 stickers. Duplicate the row, or print copies of one SKU. There is no qty column that auto-expands.

← Back to Blog

Print barcode labels by quantity from Excel

Published: · 3 min read · How-to
Open the free label maker: https://app.mylabelmaker.com. No signup. Design the label, then print to a Zebra or download PNG, PDF, or ZPL.

Open product sticker template

You can print barcode labels by quantity from Excel. The free label maker prints one sticker per row. If you have 15 of SOAP-12, put SOAP-12 on 15 rows, or print that one SKU and choose 15 copies. No signup.

Good to know: There is no qty column that auto-expands. Duplicate the row, or print copies of the current label. Do not invent a second SKU just to fill the roll.

How to print barcode labels by quantity from Excel

  1. Open https://app.mylabelmaker.com. No signup.
  2. For mixed SKUs, duplicate each row once per unit (15 stock = 15 identical rows). Barcode {{sku}}. Add {{name}}.
  3. Upload the file. Preview. The stack matches the row count.
  4. For one SKU only: load one row, print, and set copies to the quantity on the printer dialog.

Sample spreadsheet

A restock that needs three stickers of one SKU and one of another.

skuname
SOAP-12Lavender soap
SOAP-12Lavender soap
SOAP-12Lavender soap
CAND-04Pine candle

First row is the header. Those header words go inside the curly braces on the label, like {{sku}}.

Inventory run: barcodes for inventory. Print on a Zebra from the browser, or download PNG or PDF if you print another way.

Print or save

Got a Zebra? Print with Browser Print at the printer's DPI. Everyone else: print from this computer, or download PNG, JPG, SVG, PDF, or ZPL. Save JSON if you want the editable master back later.

Print the right number of stickers

Match the count in the sheet. Then scan a test.

Open free label maker