When Excel barcodes go wrong: a troubleshooting guide

For the step-by-step workflow, use the Excel barcode generator.

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 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.

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