Creating Barcode Labels From Excel

Generating barcodes from an Excel spreadsheet is the fastest way to label an existing inventory. If your products, assets, or locations already exist in a spreadsheet, you can turn that data into printed labels in one import step — without re-entering values, without cloud uploads, and without a specialised barcode database.

Why Excel to Barcode Generation Makes Sense

Most small and medium businesses already have their product data in Excel: SKU codes, product names, descriptions, prices, and supplier information. The data is already clean and organised. Rather than typing each barcode value into a generator one at a time, a batch import turns the entire column into a print-ready file in seconds.

The other advantage is verification. An Excel file is easy to review, filter, and check before generating labels. You can sort by barcode value to spot duplicates, filter to a specific product category, and remove rows you do not want to label — all before the import step.

Step 1: Structure Your Spreadsheet

The minimum requirement is one column containing the barcode value — the data that will be encoded in the barcode. Everything else is optional but useful. A recommended structure:

Column names can be anything — you will map them in the importer. However, descriptive names make mapping faster and reduce the risk of assigning the wrong column to the barcode value.

Step 2: Avoid the Leading Zero Problem

The most common data corruption in Excel barcode workflows is leading zero stripping. Excel treats columns as numeric by default, so a UPC-A value of 036000291452 is stored as the number 36000291452 (11 digits, leading zero removed). When you generate a UPC-A from 11 digits instead of 12, the check digit calculation changes, and the barcode does not match your product's registered GTIN.

The fix: format the barcode column as Text before entering values. Right-click the column header → Format Cells → Number → Text. Then enter or paste your barcode values. If your data is already in the spreadsheet as numbers, convert to text by using the TEXT() function: =TEXT(A1,"000000000000") for a 12-digit number.

Step 3: Handle Merged Cells and Filters

Merged cells (where one cell spans multiple columns or rows for layout purposes) do not import cleanly. Before importing, unmerge all cells: select all (Ctrl+A), then Home → Merge & Center dropdown → Unmerge Cells. If you are using auto-filters to show a subset of your data, be aware that the importer reads all rows, including hidden ones. Remove or delete any rows you do not want to import, rather than simply hiding them.

Step 4: Save and Import

Save your file as XLSX (the default Excel format) and import it into Batch Label Studio Pro. The importer reads the first sheet, shows a preview of the first five rows, and lets you map columns to barcode value, label title, description, and quantity. A live sample label updates as you map each column, so you can verify the output before generating the full batch.

After mapping, select your barcode type, choose a label template, and click Generate. The tool processes every row locally — nothing is uploaded. Export as a multi-page PDF (one label per page, or multiple labels per page using a sheet template like Avery 5160) or a ZIP of individual PNG files.

Common Excel Import Mistakes

• Formulas instead of values

  Paste as values (Ctrl+Shift+V → Values Only) to prevent formula errors from appearing as barcode content.

• Extra header rows

  Use a single header row. Remove any title or sub-header rows above the data. The importer uses the first row as column headers.

• Blank rows mid-data

  Blank rows are imported as empty barcodes. Filter and delete blank rows before importing.

• Regional comma separators

  If your Excel uses commas as decimal separators (common in European locales), import as XLSX rather than CSV to avoid column misalignment.

• Mixed barcode types without a type column

  If your spreadsheet has both Code 128 and EAN-13 values, add a barcode_type column so the importer uses the correct encoder for each row.

Frequently Asked Questions