Creating Labels Using an Excel or Other Format File

You can create a large number of labels easily by importing your existing Excel, csv, or other format file.

1. Click on the tool bar.

2. Click Import (Horizontal Text) or Import (Vertical Text).



3. Click Load Import Data. When a file selection dialog box is displayed, select and open a file you want to import.



4. Click Overwrite Current Data.

If the first row of the file is used as a header row, select the check box for Use first row as column headers.



5. Select which worksheet to import, and then click OK.

A blank label image is displayed in the Layout editing window, and the imported data is displayed in the Data creation window.

6. Insert the data from the Data creation window to the Layout editing window, and then format a label.

To insert barcode or image data, change the column attribute before inserting it.

How to Operate the Data Creation Window

Note: You can change font type and size settings for each item. Changing Object Settings

7. Click to print the file.

Printing Labels with Serialization Object or Labels Created Using the Data Creation Window (Advanced Settings)