Print SKU labels from Excel

The catalog number, scannable, on every unit.

← Back to Blog

Print SKU labels from Excel

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

Open product sticker template

Your SKUs are already in a catalog sheet. Design one SKU label in the free label maker. Barcode {{sku}}. Add {{name}}. Upload. Print every unit you are tagging today.

Good to know: Use the SKU your shop, Amazon, or WMS already stores. A second code on the sticker causes pick errors.

How to print SKU labels from a catalog

  1. Headers: sku, name.
  2. Open the free label maker. Set 2x1.
  3. CODE128 with {{sku}}. {{name}} under the bars.
  4. Upload the Excel file. Scan one. Print.

Sample spreadsheet

A three-SKU sample from a candle catalog.

skuname
CAND-04Pine 8oz
CAND-05Lavender 8oz
CAND-06Cedar 8oz

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

Need UPC instead of an internal SKU? how to make UPC labels.

Print or save

Zebra thermal: print from the browser with Browser Print at the printer’s DPI. Everyone else: download PNG, JPEG, SVG, PDF, or ZPL. JSON keeps the editable master.

Print SKU labels from this catalog

The numbers you already use. Stickers that scan.

Open free label maker