How to print barcode labels

AzureLabel can generate and print barcode labels using data from Excel spreadsheets, Google Sheets, databases, POS systems, APIs, the built-in Print Data table, and other supported data sources.

Supported barcode types include UPC-A, UPC-E, EAN-13, EAN-8, Code 128, Code 39, Data Matrix, QR Code, PDF417, Aztec, GS1-128, GS1 Data Matrix, GS1 QR Code, and many others.

This tutorial shows how to create a barcode label template, connect an Excel file, import barcode data, and print barcode labels.

The example uses the sample Excel file sample_data_barcode_types.xlsx included with AzureLabel. You can find it in the C:\Program Files (x86)\AzureLabel 2026\res\en\Samples folder. The same steps apply to your own Excel files, even if they contain different columns and data.

In this example, we will create the following barcode label:

The label contains the following elements:

1. Product name
2. UPC-A barcode
3. EAN-13 barcode
4. Code 128 barcode
5. Data Matrix barcode
6. QR Code
7. GS1 Data Matrix barcode

All of these elements are populated from Excel data and display different values for each row in the spreadsheet.

Create the label

1. Click New label.

   

2. Select New blank label.

   

3. Enter a name for the label, for example Example.

   

4. Set the label size to 4 x 2 inches and the corner rounding to 0.4 inch.

   

   

Connect the Excel spreadsheet

Before AzureLabel can use data from an Excel file, you need to create import settings that describe how the spreadsheet should be read.

1. Click the Import settings button.

   

2. If a dialog appears, select Add new settings.

   

3. On the Connection tab, select your Excel file.

   

4. On the Reading tab, specify the row number that contains the column names. In this example, it is row 1.

   If your table does not contain column names, set this value to 0.

   

5. Go to the Data fields tab and click Read data fields from source.

   

   The column names appear in the list.

   

6. Click Test import to verify the data.

   

7. Click OK.

Import the spreadsheet data

1. Click the Import button.

   

   After importing the data, you can see the names of your columns (data fields) in the Data fields list:

   

Add elements to the label

Add the product name

1. To display the product name, drag the Name field to the empty space of the label.

   

2. Select the Text type.

   

3. Set the desired position and size of the area to display the product name.

   

4. Set the Auto font size to Fit to the element.

   

Add the UPC-A barcode

1. To display the barcode, drag the UPC-A field to the empty space of the label.

   

2. Select the Barcode type.

   

3. Select the UPC-A barcode type in the list and click OK.

   

4. Set the desired position and size of the UPC-A barcode.

   

Add the EAN-13 barcode

1. To display the barcode, drag the EAN-13 field to the empty space of the label.
2. Select the Barcode type.

   

3. Select the EAN-13 barcode type in the list and click OK.

   

4. Set the desired position and size of the EAN-13 barcode.

   

Add the Code 128 barcode

1. To display the barcode, drag the Code 128 field to the empty space of the label.
2. Select the Barcode type.

   

3. Select the Code 128 barcode type in the list and click OK.

   

4. Set the desired position and size of the Code 128 barcode.

   

Add the Data Matrix barcode

1. To display the barcode, drag the Data Matrix field to the empty space of the label.
2. Select the Barcode type.

   

3. Select the Data Matrix barcode type in the list and click OK.

   

4. Set the desired position and size of the Data Matrix barcode.

   

Add the QR Code

1. To display the barcode, drag the QR Code URL field to the empty space of the label.
2. Select the Barcode type.

   

3. Select the QR Code barcode type in the list and click OK.

   

4. Set the desired position and size of the QR Code barcode.

   

Add the GS1 Data Matrix barcode

1. To display the barcode, drag the GS1 field to the empty space of the label.
2. Select the Barcode type.

   

3. Select the Data Matrix barcode type in the list.

   

4. Set the GS1 data mode checkbox, select (round bracket) in the Notation for application identifiers (AIs): dropdown, and click OK.

   

5. Set the desired position and size of the GS1 Data Matrix barcode.

   

Save the label

Click Save to save the label template.

Preview or print

Click Preview to generate barcode labels from the imported Excel data.

AzureLabel generates one barcode label for each row in the Excel spreadsheet. You can review the generated barcode labels before printing and adjust print settings if needed.

To print multiple copies of a label, change the value in the Print quantity column of the Label print data table.

You can also import print quantities from your Excel file. In the Import settings, select the field that contains the quantity values and enable Use this field to set the print quantity.

Next steps

Try the same workflow with your own Excel files, or customize the label design by adding different barcode types, text, images, and other label elements.