How to print labels from Excel or CSV

One design. Every row in the file.

← Back to Blog

How to print labels from Excel or 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.

Open product sticker template

If you have a list of names, SKUs, or barcodes in Excel, you do not need Word and you do not need to copy each line by hand. Design the label once in the free label maker. Put a placeholder like {{name}} where the name goes. Load the spreadsheet. Each row becomes its own label.

Good to know: The first row of the sheet must be headers. The word inside {{name}} has to match a column name. If the column is called sku, use {{sku}}.

How to turn a spreadsheet into labels

  1. Make a sheet with a header row. Example columns: name, sku, price.
  2. Open the free label maker and set the sticker size.
  3. Add a text box. Type {{name}} where the name should print. Add a barcode and use {{sku}} if you have that column.
  4. Open Variables. Upload the Excel or CSV file, or paste the CSV, or paste a published Google Sheet link.
  5. Preview one row. If it looks right, print the whole list on a Zebra, or download files if you print another way.

What you can fill from the sheet

Excel, CSV, or Google Sheets

Upload .xlsx or .csv. Or paste CSV. Or publish a Google Sheet to the web as CSV and paste the link. The app reads the rows in your browser. The file does not go to our server.

This is the part most people miss

You design one label. Two hundred rows in the sheet means two hundred labels, without redesigning. That is the whole point. Older Word mail merge does the same job with more steps and worse barcodes.

More detail if you print on Zebra: Excel on a Zebra · Google Sheets · mail merge labels.

Print or save

Print on a Zebra from the browser, or download PNG, JPEG, SVG, PDF, or ZPL. Export JSON if you still need to edit the label later.

Turn your spreadsheet into labels

One design. Every row. Print the stack.

Open free label maker