How-to

The most common product-barcode size

← Back to Blog

Print 2×1 barcode labels from a CSV

Published: · 8 min read · How-to
Free label maker: app.mylabelmaker.com — no signup. Native barcodes, Excel/Sheets batch, export or Zebra print. Related: barcodes from Excel · Google Sheets · all guides.

The actual question people ask

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 maker · label maker hub.

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

Steps that match the query

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 in r/printers threads.

Batch from Excel or Google Sheets

Map column tokens into text, barcodes, or QR. Paste CSV, upload a file, or load a published Google Sheet. Preview rows, then print quantity 1 before the stack. Guide: mail merge · CSV mail merge.

Print or export

Zebra thermal: Browser Print at the printer’s DPI. Everyone else: Options → PNG, JPEG, SVG, PDF, or ZPL. JSON saves the editable master.

Related

Try this workflow free

Browser canvas · native barcodes · Excel batch · export or Zebra print. No account.

Open free label maker