Print labels from Excel

How to print labels from Excel

Print labels with data import from Excel

With Labeljoy, you can print labels by importing data from Excel quickly and easily.
Labeljoy integrates the function of importing data from external databases such as text files, Excel file, mySQL database, Outlook contacts, that allows to easily print many labels.

Find out how easy it is to print address labels from Excel!

DOWNLOAD LABELJOY FREE

This tutorial explains step by step how to print labels from Excel spreadsheets.
Once you have decided on the layout of the label, you can import the data from an Excel file.

This is the Excel file used for this tutorial:

Excel data connected to labels

1 – Import Excel data to print labels

Use the function “Link data sources” by clicking on the icon in the left toolbar and follow the instructions. Select the option “The data is in a file or in the clipboard“.

Select data source type

Select the file type, in this case an Excel file was used to print the labels. Select “Excel 97-2003“.

Select the Excel file to print

Select the Excel file containing the data you want to use.

Select the Excel file from your PC

2 – Import the file settings

NOTE: The header settings must be set correctly. As shown in the figure below, the Excel file to be connected to the label contains the headers in the first row.

Header row setting

Select the number of labels to be printed

The number of labels to be printed can be specified for each row of the Excel file. In this case, one label is printed for each row of the Excel file.

Set quantity of labels to be printed

To set a different number of labels to be printed watch the tutorial video “How to set the number of labels from the database

It is also possible to set filters and sorting of labels to be printed without acting directly on the Excel sheet, but by adjusting the settings directly from Labeljoy.

Sorting labels

Filter Excel fields

Data review of Excel data that will be included on the labels to be printed.

Data review of labels from Excel

3 – Create labels from Excel files

Double-click on the text to insert Excel data into the text field.

Connect Excel data to Labeljoy field

Clicking on the icon “Field“, the names in the header row of the Excel file appear. By clicking on them you can add fields for printing that are linked to the Excel database.

Add Excel field

Below an example of a possible combination of Excel data in a text field of Labeljoy.

Field from Excel database

INFO: It is also possible to associate Excel data with barcode fields.

4 – Print labels from Excel

This is the result obtained when associating the Excel file to the text field of a label using Labeljoy.

Printable labels from Excel file

INFO: Find out how to update data linked labels dynamically.

In just a few steps you can print address labels from Excel and design labels with images, barcodes, graphic effects, clipart and logos.

DOWNLOAD LABELJOY FOR FREE

INFO: The functions of data import from Excel is very useful for creating customized labels as: