How to Print Barcode Labels from Excel (EAN, QR, Code 128 Guide)

Step-by-Step: Print Barcode Labels from Excel

Prepare a clean Excel or CSV file with one row per label
Import the data into LabelFlow Pro
Map spreadsheet columns to text and barcode fields
Select the correct barcode type: EAN-13, Code 128, or QR Code
Adjust label size, margins, and preview output
Print in batch to a standard or thermal printer

Example Workflow

Import Excel spreadsheet data for barcode label printing

Preview barcode labels before batch printing

Printing barcode labels from Excel is a common requirement for product labeling, inventory control, warehouse operations, and shipping workflows. The challenge is that Excel stores the data, but it does not produce production-ready barcode graphics on its own. A professional workflow converts your spreadsheet values into properly rendered barcodes and places them into a repeatable print layout.

Which Barcode Type Should You Use?

EAN-13 – best for retail products and GTIN-based labeling
Code 128 – best for warehouse, logistics, internal stock, and asset labels
QR Code – best for URLs, serial-linked content, manuals, and extended data

If you are printing barcode labels from Excel for products, EAN-13 and Code 128 are usually the most common choices. If you need to encode links or more complex content, QR Code is the better option.

Step 1

Prepare Your Excel Data

Create a clean spreadsheet with one row per label and one column per variable, such as Product Name, SKU, Barcode Value, Price, or URL. Remove merged cells, blank header rows, and inconsistent formatting. For EAN-13, use exactly 13 digits. For Code 128, use a clean alphanumeric string. For QR Codes, use the full text or URL you want encoded.

Step 2

Import the File into Your Label Workflow

Import the Excel or CSV file into LabelFlow Pro. The software reads your structured data and lets you bind each spreadsheet column to a text field, barcode field, or QR code field on the label. This removes the need for barcode fonts, Excel macros, or fragile Word mail merge workflows.

Step 3

Select the Correct Barcode Symbology

Choose the barcode type that matches your use case: EAN-13 for retail barcodes, Code 128 for inventory and logistics labels, or QR Code for web links and extended data. Always verify that the encoded value matches the barcode standard and that the final printed barcode includes enough quiet zone for reliable scanning.

Step 4

Add Human-Readable Text

Most professional barcode labels also display the raw value below the barcode. This helps operators verify the code visually and allows manual entry if a scanner is unavailable. Keep the text readable and aligned consistently across the whole batch.

Step 5

Preview Size, Quiet Zone, and Layout

Before printing, check that the barcode is large enough for the intended scanner and printing method. Leave sufficient blank space around the barcode, confirm margins, and verify that the barcode is not being compressed or stretched by the layout. This is especially important on thermal printers and small product labels.

Step 6

Print and Test Scan

Print a small test batch first. Scan several labels using the same type of scanner your operators or customers will use. If the code is difficult to read, increase barcode size, improve contrast, or adjust spacing before running the full batch.

Why Excel Alone Is Not Enough

Excel stores barcode data but does not reliably generate production-ready barcodes
Barcode fonts often create formatting problems and inconsistent results
Word mail merge is slow and error-prone for batch barcode jobs
Thermal printers require tighter control over layout, margins, and scaling

Common Barcode Label Mistakes

Using the wrong number of digits for EAN-13
Printing barcodes too small for the target scanner
Leaving too little white space around the code
Using Word mail merge for high-volume barcode runs
Mixing inconsistent data formats inside the same spreadsheet column

FAQ

Can Excel generate barcode labels on its own?

Not reliably. Excel can store barcode values, but it does not natively generate production-ready EAN, QR Code, or Code 128 graphics. Most users need fonts, scripts, or a dedicated label workflow.

What is the best barcode type for labels from Excel?

EAN-13 is best for retail products, Code 128 is best for internal stock and logistics labels, and QR Code is best when you need to encode URLs or larger data strings.

Can I print barcode labels from Excel to a thermal printer?

Yes. Once the Excel data is mapped correctly, you can print barcode labels to thermal printers such as Zebra, Brother, and DYMO, provided the label size and printer settings are configured correctly.

Do I need barcode fonts?

No. A dedicated barcode workflow generates barcode graphics directly, which is more reliable than depending on fonts or spreadsheet hacks.