Create barcodes for inventory from a spreadsheet
Do this in the free app: app.mylabelmaker.com. No signup. Design the label, then print on a Zebra or download PNG / PDF / ZPL.
Yes. You can create barcodes for inventory from a spreadsheet. You don't need a barcode font. Open the free label maker, put a CODE128 barcode on {{sku}}, add {{name}}, upload the sheet, print.
Good to know: Format the SKU column as text so leading zeros stay. Internal SKUs use CODE128. A retail UPC is only for numbers you already own.
How to create inventory barcodes from a sheet
- Open https://app.mylabelmaker.com. No signup.
- Keep the inventory sheet. Headers: sku, name, bin (optional). Set the label to 2x1 or 3x2.
- Add a CODE128 barcode with {{sku}}. Add {{name}} under it. Optional {{bin}}.
- Upload the Excel or CSV file. Preview two rows. Scan one. Print.
Sample spreadsheet
A small-shop inventory sheet is enough to start. First row is the header.
| sku | name | bin |
|---|---|---|
| SOAP-12 | Lavender soap | A-12 |
| CAND-04 | Pine candle | A-13 |
| TOTE-01 | Canvas tote | B-02 |
First row is the header. Those header words go inside the curly braces on the label, like {{sku}}.
Need many of the same SKU? Duplicate that row, or print copies of one row. Guide: barcode labels by quantity. Core merge: many labels from Excel.
Print or save
If you're printing to a Zebra, use Browser Print and match the printer's DPI. Otherwise download PNG, JPEG, SVG, PDF, or ZPL. JSON is the file you can open again later.
Create inventory barcodes from this sheet
The list you already keep. Stickers that scan. No barcode font.
Open free label maker