How to Create Barcode Labels from Excel

If your product data lives in an Excel spreadsheet, you are already most of the way to a complete batch of barcode labels. This guide walks through preparing your file, importing it into Batch Label Studio Pro, choosing the right barcode format, and exporting print-ready output — step by step.

Step 1 — Prepare your Excel columns

Batch Label Studio Pro expects at minimum a column containing the barcode value for each row. The most useful structure has three to five columns:

Column names do not need to match exactly — you will map them during import. The table above uses a naming convention that makes mapping straightforward.

Step 2 — Fix leading zeros before saving

Excel automatically strips leading zeros from numeric cells. A UPC-A value like 036000291452 becomes 36000291452 — one digit short and invalid for retail scanning.

There are two reliable ways to prevent this:

1. Format the barcode column as Text before entering any data: select the column, open Format Cells, choose Text, then type your values.
2. Prefix each value with a single quote when entering: '036000291452. The quote forces Excel to treat the cell as text and does not appear in the exported CSV.

Step 3 — Choose the right barcode type

If your barcode_type column is not yet filled, here is a quick decision guide:

Step 4 — Import your file into Batch Label Studio Pro

1. 4a.Open Batch Label Studio Pro in your browser. Drag your CSV or XLSX file onto the import area, or click Browse to select it. The file is read locally — nothing is uploaded.
2. 4b.The importer shows a preview of detected columns and up to 5 sample rows. Verify that leading zeros are intact and that barcode values look correct.
3. 4c.Map your columns: select which column is the barcode value, which is the barcode type, and optionally which columns are the label title and description.
4. 4d.If all rows use the same barcode type (e.g., all Code 128), choose "All rows use this type" and select it once — you do not need a barcode_type column.

Step 5 — Choose a template and export

After mapping columns, select a label template. Batch Label Studio Pro includes standard sizes for Avery label sheets, Zebra thermal printers (4×6, 2×1, 3×2), and custom dimensions in millimeters. A sample label previews your mapped data at the chosen size.

Once you are satisfied with the layout:

• Multi-page PDF — prints directly from any PDF viewer onto label sheets. Each page is sized to fit your sheet layout.
• ZIP of PNGs — one image file per row, named by the label title or row number. Includes a manifest CSV mapping each filename to its source data row.

All generation happens locally. A 1,000-row file typically completes in under a minute on a modern laptop.

Troubleshooting tips

Frequently Asked Questions