Print Barcode Labels from Excel
You can print barcode labels from Excel without buying BarTender or using Word mail merge. Open the free label maker, map a column to a native barcode, preview a row, and print. No signup.
Open the free label maker: https://app.mylabelmaker.com. No signup. Excel to CSV, map the column, print to a Zebra. Full batch basics: batch print guide.
How to print barcode labels from Excel
- Open https://app.mylabelmaker.com. No signup.
- One header row: sku, barcode, name, bin. One product per row. Format the barcode column as Text so leading zeros stay. Save as CSV UTF-8.
- Set the size (2x1, 2.25x1.25, 3x2). Insert a native barcode: CODE128 for SKUs, UPC-A for US retail, QR for links. Put {{barcode}}, {{sku}}, {{name}}.
- Open Variables, upload the CSV, preview rows, print via Browser Print.
Also works from Google Sheets, Sheets guide · generic Excel: print labels from Excel.
Design the barcode, not a font
Leave quiet zones around the bars. Add human-readable text under the symbol. Don't paste a screenshot of a barcode.
Symbology help: print barcodes on Zebra · UPC stickers.
Load the CSV and preview rows
Open Variables. Paste or upload the CSV. Confirm headers map to tokens. Step through a few rows so each barcode looks right, then print all or a selected range.
Common Excel pitfalls
- Leading zeros dropped: format the barcode column as Text before export
- Scientific notation on long numbers: same Text format fix
- Screenshot barcodes: never paste images. Use a native barcode object
- Wrong DPI: soft bars fail scans. See the 300 DPI guide
UPC/EAN values must be valid for retail scanners. Internal SKUs can use CODE128 freely. Amazon FNSKU: FNSKU guide.