Loading Data from Excel or Database Sources

To start working with printing labels from Excel using the label development software, simply open the application, create a query to your Excel database, and select the necessary fields for your label template. Save the query for future use and enjoy the convenience of automating the label printing process.

The program supports only the .xlsx, .xlsm, .xltx, and .xltm formats. If you are using MS Excel 2007, you need to save the file in one of these formats.

Steps to Load Data from CSV:

1. Launch Union Label on your computer.

2. Select one of the pre-set templates for the label or create your own if required.

3. Importing Data from CSV

   • Click the "Import Data" button.
   • In the appearing window, select the option "Load CSV File".
   • Find the necessary CSV file on your computer and upload it.

4. Field Configuration

   • After uploading the CSV file, you will be prompted to match the columns of the file with the fields on the label.
   • For each field on the label, select the corresponding column from your CSV file (e.g., for the product name, select the column with the product name).

5. Preview
   Review the result to ensure that the data is loaded correctly and displayed properly on the label layout.

6. Printing Labels

   • Once all the data is verified, select the necessary print settings (label size, printer, and number of copies).
   • Click "Print".

Now your labels will be printed with the data loaded from the CSV file!

If you need additional help or instructions, let us know!