Create internal SKU barcodes from Excel
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 internal SKU barcodes from Excel. Most warehouse SKUs are not retail UPCs, and that's fine. Design one sticker in the free label maker, use CODE128 on {{sku}}, upload the list. Scanners at receiving will read it. We do not issue GS1 numbers.
Good to know: CODE128 is for internal tracking. Checkout at a grocery chain needs a UPC or EAN you bought from GS1. Do not invent a 12-digit UPC.
How to make internal SKU barcodes
- Open https://app.mylabelmaker.com. No signup.
- Sheet headers: sku, name. Set the label to 2x1.
- Barcode format CODE128. Value {{sku}}. Text {{name}}.
- Upload the Excel file. Scan with the gun you use on the floor. Print.
Sample spreadsheet
These are internal codes a shop invented. Not for grocery checkout.
| sku | name |
|---|---|
| WH-SOAP-12 | Lavender soap case |
| WH-CAND-04 | Pine candle case |
| WH-TOTE-01 | Canvas tote case |
First row is the header. Those header words go inside the curly braces on the label, like {{sku}}.
If you own a real UPC: how to make UPC labels. Inventory run: inventory from a spreadsheet.
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.