Print labels from Excel or CSV on Zebra printers (batch mail merge)
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
- Product barcode labels (UPC/EAN/CODE128 from SKU column)
- Warehouse bin / shelf location labels
- Asset tags with serial numbers
- Price tags and shelf talkers
- Membership / event badges with unique QR codes
- Shipping manifests (addresses + tracking per row)
Step 1: Prepare your Excel file
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}}
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 likehttps://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
Three ways to connect data
- Paste CSV — copy from Excel/Numbers/Sheets, paste in Variables panel
- Upload .csv file — drag the exported file
- 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
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 mail merge vs mylabelmaker
| Feature | Word/Excel mail merge | mylabelmaker + CSV |
|---|---|---|
| Zebra thermal / ZPL | No — office printers | Native ZPL + direct print |
| Barcode quality | Often poor when scaled | Printer-native DPI |
| Live row preview | Limited | Full WYSIWYG per row |
| Cost | Office labels expensive | Free software + thermal stock |
Print your spreadsheet now
Export CSV from Excel, drop tokens in a label, batch print in minutes.
Open mylabelmaker