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.

Placeholders in text, barcodes, and QR

Open https://app.mylabelmaker.com. No signup. Set the size (2x1 for product stickers, 4x6 for 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.

Three ways to connect data

1. Paste CSV: copy from Excel, Numbers, or Sheets, paste in Variables.
2. Upload a .csv file: drag the exported file in.
3. Google Sheets URL: publish the sheet as CSV, paste the URL. See the 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).

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).