Tutorial

Print labels from Excel or CSV on Zebra printers

← Back to Blog

Print labels from Excel or CSV on Zebra printers (batch mail merge)

Published: · 8 min read · Tutorial

Spreadsheets are where product data lives — SKUs, serial numbers, bin locations, prices, expiration dates. Printing one label per row by hand is tedious. Desktop tools like BarTender charge hundreds per year for "database connectivity." Excel mail merge to Avery labels does not speak ZPL.

mylabelmaker gives you spreadsheet-driven batch printing for free: design one label with {{column_name}} placeholders, paste or upload your Excel-exported CSV, preview row 1 through row 500, and print one substituted label per row to your Zebra printer.

Common Excel → Zebra use cases

Step 1: Prepare your Excel file

1

One row = one label

Put column headers in row 1. Each data row becomes one printed label. Example inventory sheet:

sku,product_name,barcode,price,bin
SKU-1001,Organic Honey 12oz,012345678905,24.99,A-14
SKU-1002,Almond Butter 16oz,012345678912,18.50,B-02

In Excel: File → Save As → CSV UTF-8 (Comma delimited) (.csv). UTF-8 avoids garbled characters on international addresses or product names.

Alternatively, copy the whole sheet (including headers) and paste directly into mylabelmaker — no file save needed.

Step 2: Design the label with {{tokens}}

2

Placeholders in text, barcodes, and QR

Open app.mylabelmaker.com. Set label dimensions (e.g. 2×1 in product, 4×6 in shipping).

Add elements and use tokens anywhere:

  • Text: {{product_name}} and ${{price}} (literal $ is fine next to tokens)
  • Barcode value: {{barcode}} — pick EAN-13 or CODE128 based on your data
  • QR content: {{sku}} or a URL like https://store.com/p/{{sku}}

Token names must match CSV headers (case-insensitive). Extra columns in the sheet are ignored unless referenced.

Step 3: Load the spreadsheet

3

Three ways to connect data

  1. Paste CSV — copy from Excel/Numbers/Sheets, paste in Variables panel
  2. Upload .csv file — drag the exported file
  3. Google Sheets URL — publish sheet to web as CSV, paste URL (stays in sync). See Google Sheets guide

The row navigator appears at the bottom. Step through rows to verify barcodes scan and text fits (use autoshrink on long product names).

Step 4: Print all rows

4

Batch print to Zebra

With Browser Print running and printer selected, click Print. The button shows total rows — mylabelmaker prints one label per row automatically.

Need ZPL for a server? Options → Copy ZPL exports the current row's label. For full automation, export designs as JSON and integrate ZPL into your print queue (ERP guide).

Excel tip: Remove thousand-separator formatting from barcode columns before export (barcodes must be plain digits). In Excel, format column as Text before entering leading-zero SKUs.

Excel mail merge vs mylabelmaker

Feature Word/Excel mail merge mylabelmaker + CSV
Zebra thermal / ZPLNo — office printersNative ZPL + direct print
Barcode qualityOften poor when scaledPrinter-native DPI
Live row previewLimitedFull WYSIWYG per row
CostOffice labels expensiveFree software + thermal stock

Print your spreadsheet now

Export CSV from Excel, drop tokens in a label, batch print in minutes.

Open mylabelmaker

Related reading