How to print labels from Excel

AzureLabel can print labels using data from an Excel spreadsheet. Each row in the spreadsheet can become a separate label, and each column can be used for product names, prices, barcodes, SKUs, images, and other label data.

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

The same workflow can be used to create product labels, barcode labels, price tags, inventory labels, and many other labels from Excel data.

The example uses the sample Excel file sample_data.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 tutorial, we will create the following product label:

The label contains the following elements:

1. Product name
2. Price
3. Batch number
4. UPC barcode
5. Product image
6. QR code linking to a website

Most of these elements are populated from Excel data and display different values for each row in the spreadsheet. In this example, the QR code uses a fixed website address and remains the same on every label. However, like the UPC barcode, it can also be populated from an Excel field and display different values for each row.

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.

   

   Remove any columns you do not want to import.

   

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 price

1. To display the price, drag the Price field to the empty space of the label.
2. Select the Text type.
3. Open Element properties

   

4. Go to the Text formatting tab, type the Prefix $ and click OK.

   

   You can also use Mixed text on the Data source tab if you need more complex text formatting. This is covered later in the guide.

5. Set the desired position and size of the area to display the product price.

   

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

Add the batch number

1. To display the batch number, drag the SKU field to the empty space of the label.
2. Select the Text type.
3. Open Element properties
4. Go to the Text formatting tab, type the Prefix Batch and click OK.

   

5. Set the desired position and size of the batch number.

   

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

Add the barcode

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

   

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

   

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

   

Add the product image

1. To display the product image, drag the Image field to the empty space of the label.
2. Select the Image type.

   

   Image fields can contain the image itself (for example, binary or SVG data), or a reference to an image, such as a local file path or a URL.

3. Set the desired position and size of the image.

   

Add the QR code

1. To display the QR code with a link to our website, select the 2D Barcode tool.

   

2. Click an empty area of the label.
3. Select the QR Code barcode type in the list.

   

4. Go to the Data source tab, type the barcode data https://azurelabel.com and click OK.

   

5. Set the desired position and size of the QR code.

   

Save the label

Click Save to save the label template.

Preview or print

Click Preview to generate labels from the imported Excel data.

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

Next steps

Try the same workflow with your own Excel files, or customize the label design by adding different text, barcode, image, and QR code elements.