How to Generate Barcode Labels from SKU Lists in Excel
Moving from manual inventory checks to a barcode-based system is a huge step up for any small business. It reduces errors and speeds up checkout. But how do you actually create the barcode stickers?
You don't need expensive barcode software. If you have your inventory in Excel or CSV, you have everything you need.
Understanding Barcode Types
Before you print, choose the right format:
- UPC-A / EAN-13: Standard for retail products worldwide. Requires a specific number of digits (12 or 13).
- Code128: The most versatile. Can encode letters and numbers. Great for internal SKUs (e.g., "TSHIRT-BLK-L").
- QR Code: Best for linking to websites or storing longer text.
Step-by-Step: Excel to Barcode Sticker
1. Clean Your Data
Ensure your Excel file has a column for the unique ID.
| Item Name | SKU | Price |
|---|---|---|
| Blue Widget | WID-BLU-01 | $10.00 |
2. Configure the Element
In the SheetsToLabels Designer:
- Drag a Barcode element onto the canvas.
- Data Binding: Select your "SKU" column as the source.
- Format: Choose "Code128" (safest bet for internal SKUs).
- Show Text: Toggle "Show Value" to print the human-readable text below the bars.
3. Add Context
A barcode alone isn't enough. Add text fields for "Item Name" and "Price" above the barcode so customers or staff know what the item is without scanning it.
4. Print & Verify
Print a sample sheet. Crucial: Use your barcode scanner (or a phone app) to scan the printed label. Ensure it beeps and decodes the correct SKU ("WID-BLU-01").
Scaling Up
Whether you have 50 items or 50,000, the process is the same. SheetsToLabels generates the vector lines for the barcodes server-side, ensuring they remain crisp and scannable even when printed on small labels.
Turn your spreadsheet into a professional inventory system today: Create Barcodes.