How to print labels from CSV

AzureLabel can print labels using data from CSV files. Each row in the CSV file 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 a CSV file, import data, and print labels using that data.

The same workflow can be used to print product labels, barcode labels, price labels, shelf labels, inventory labels, shipping labels, and many other types of labels from CSV files.

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 CSV data and display different values for each row in the file. 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 a CSV 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 CSV

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

1. Click the Import settings button.

   

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

   

3. Go to the Connection tab, and select CSV as the connection type.

   

4. On the Connection tab, select your CSV file.

   

5. On the Reading tab, specify:

   

   1. File encoding – the character encoding used by the CSV file. The list includes UTF-8, UTF-16, and the current Windows code page. If you need a different encoding, enter its Windows code page ID.
   2. Column delimiter – the character that separates values in each row, for example a comma (,), semicolon (;), or tab.
   3. Quote character – the character used to enclose values that contain delimiters or line breaks, typically a double quotation mark (").

   Also specify the row that contains the column names. In this example, it is row 1.

   If the CSV file does not contain column names, set this value to 0.

   

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

   

7. Click Test import to verify the data.

   

8. Click OK.

Import data from CSV

1. Click the Import button.

   

   After importing the data, the names of your columns (data fields) appear 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 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 CSV data.

AzureLabel generates one label for each row in the CSV file. You can review the generated 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 CSV file. In the Import settings, select the field that contains the quantity values and enable Use this field to set the print quantity.

Related articles

How to print barcode labels

How to create QR codes and barcodes from data fields

How to use image links from Google Drive in labels