Print bulk barcode labels from Excel

One design. A barcode for every row.

← Back to Blog

Print bulk barcode 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

Bulk barcode labels means one layout and a different code on every sticker. Put SKUs in Excel. Design one label in the free label maker. Map the barcode to {{sku}}. Print the stack.

Good to know: Format the SKU column as text in Excel so leading zeros do not disappear.

How to print a bulk barcode run

  1. Sheet headers: sku, name. One row per sticker.
  2. Open the free label maker. Set 2x1 or your stock.
  3. Add a CODE128 barcode with {{sku}}. Add {{name}} under it.
  4. Variables, Upload the Excel file. Preview two rows. Print.

Sample spreadsheet

A 200-SKU restock sheet can start this small.

skuname
10001Black tee M
10002Black tee L
10003Navy hoodie

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

Same idea from a CSV: barcode labels from CSV. Core steps: many labels from Excel.

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 the bulk barcode run

The SKU list you already keep. Stickers on the boxes.

Open free label maker