Print 2×1 barcode labels from a CSV

The most common product-barcode size

← Back to Blog

Print 2×1 barcode labels from a CSV

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.

2×1 is the default product/inventory barcode size on desktop Zebras. Set the artboard to 2×1 first (wrong size is why labels look “cut off”), drop {{sku}} in a barcode, load the CSV. Open the free label maker to do it now.

Good to know: A 2×1 face on 4×6 stock will look tiny and waste labels. Match the roll in the printer.

How to print 2×1 barcode labels from a CSV

  1. Open the free label maker and set the size of your stock.
  2. Add a native barcode (not an Excel font) and map the spreadsheet column, for example {{code}}. Use a column of artboard exactly 2.00 × 1.00 in.
  3. Preview row 1 and a row near the end of the sheet.
  4. Print the stack on a Zebra, or export PDF / ZPL.

Excel barcode fonts on 2×1

CODE128 fonts in Excel often fail to scan at this size. Native barcodes rasterize at print DPI. That is the usual fix.

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 from your spreadsheet

Map a column, preview a row, then print. No signup.

Open free label maker