Print labels from Excel on a Zebra

Yes. You can print labels from Excel on a Zebra. Design one label with column tokens, load the sheet, preview a row, then print the stack. Free, no signup.

Print labels from Excel on a Zebra

Published: · 5 min read · Tutorial

Yes, you can print labels from Excel on a Zebra without BarTender or Designer Pro. Design one label with {{column_name}} placeholders, paste or upload the CSV, preview a row, then print one label per row.

How it works

Excel rows, printed on your Zebra

Put a column on each line of the label and every row in the file becomes its own sticker.

Print your spreadsheet

Export the CSV or just paste the rows, drop the tokens on the label, check a row, and print. No signup.

Open the free label maker

SKUs, serial numbers, bins, prices, dates: they already live in the sheet. Word mail merge doesn't speak ZPL. This does.

What you can print from Excel on a Zebra

  • Product barcode labels (UPC, EAN or CODE128 from a SKU column)
  • Warehouse bin and shelf location labels
  • Asset tags with serial numbers
  • Price tags and shelf talkers
  • Membership or event badges with a unique QR code each
  • Shipping manifests, with an address and tracking number per row

1Your list

How to print labels from Excel on a Zebra

Here's each part in a bit more detail.

  1. Open https://app.mylabelmaker.com. No signup.
  2. Set the size: 2x1 for product stickers, 4x6 for shipping.
  3. Add text, a barcode or a QR code, and put {{column_name}} tokens where the data goes.
  4. Paste or upload your spreadsheet.
  5. Step through a few rows in the preview.
  6. Print. You get one label per row.

2Examples

Labels to try it with

These are real renders from the editor, with made-up details. Click one and it opens with that exact label.

3Your list

Get the Excel file ready

One row is one label. That's the whole rule.

Put column headers in row 1. Every row under it becomes one printed label. A small inventory sheet might look like this:

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, choose File → Save As → CSV UTF-8 (Comma delimited) (.csv). UTF-8 keeps international addresses and product names from turning into garbled characters.

Or skip the file. Copy the whole sheet, headers included, and paste it straight into mylabelmaker.

Good to know: barcodes have to be plain digits. Remove thousand-separator formatting from barcode columns before you export, and format a column as Text before you type SKUs with leading zeros.

4Good to know

Put column tokens on the label

Tokens work anywhere on the label:

Token names have to match the CSV headers, though case doesn't matter. Extra columns in the sheet are ignored unless you use them.

  • Text: {{product_name}} and ${{price}} (a literal $ next to a token is fine)
  • Barcode value: {{barcode}}, with EAN-13 or CODE128 picked to suit your data
  • QR content: {{sku}}, or a URL like https://store.com/p/{{sku}}

5Load and calibrate

Load the spreadsheet

There are three ways in.

Paste CSV. Copy from Excel, Numbers or Sheets and paste it in Variables.

Upload a .csv file. Drag the exported file in.

Google Sheets URL. Publish the sheet as CSV and paste the URL. The Google Sheets guide shows how. Or download the CSV from Sheets and treat it like any other labels from Excel job.

A row navigator appears at the bottom. Step through the rows to check the barcodes scan and the text fits. Autoshrink helps with long product names.

6Your list

Batch print every row to the Zebra

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

Need ZPL for a server instead? Options → Copy ZPL exports the current row's label. For full automation, export the design as JSON and feed the ZPL into your own print queue. You can check any ZPL in the ZPL viewer first.

To print only some rows, or a few copies of each, see Zebra labels from Excel or Google Sheets. Its example layouts open with sample rows loaded.

The data is already in the sheet. The label just needs to know which column goes where.

7Compare

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

If you came here from BarTender, the free BarTender alternative page compares the two for batch labels. More answers on variables and batch printing are in the FAQ.

Questions about printing labels from Excel on a Zebra

Can I print labels from Excel on a Zebra without BarTender?

Yes. Design one label with column placeholders, paste or upload the CSV, preview a row, then print one label per row through Browser Print. No BarTender, no Designer Pro, no signup.

Do the column names have to match exactly?

Token names must match the CSV headers, but case does not matter. Extra columns in the sheet are ignored unless the label uses them.

Why do my barcodes lose their leading zeros?

Excel treats them as numbers. Format the column as Text before you type leading-zero SKUs, and remove thousand-separator formatting from barcode columns before you export.

Can I print from Google Sheets instead of Excel?

Yes. Publish the sheet as CSV and paste the URL, or download the CSV and upload it like an Excel export.