Creating Labels from Imported Data in Label Editor

You can create a series of labels using the data from one or more spreadsheet columns. This lets you quickly create address labels from your entire address book, for example.
The following file formats are supported: .csv, .txt, .xls, .xlxs, and .xlsm.
Note: To use .xls, .xlxs, or .xlsm file formats, you must have Microsoft Excel installed on your computer.
  1. On the New/Open screen, select Import(Horizontal text) and click OK. You see this window:


  2. Click Load Import Data, select the file you want to import, and click Open.
  3. Select Overwrite Current Data and choose a data sheet, if necessary. You see a Layout window and a Data window side by side:


  4. Click the Import icon. You see a window like this:


  5. Select one of the columns that you want to import and click OK. You see the outline of an import frame.
  6. Drag the frame where you want the data to appear on your label. You see the data from the current row on the label layout:


  7. Repeat steps 5 and 6 until all the data you want to import appears on the label.
  8. Adjust the size and position of the import frames as necessary.
  9. To save your label project, click the Save icon, enter a file name, and click Save.
  10. To select specific rows to print, click the checkbox to the right of the row number in the Data window. A green check mark appears next to the row number.
    Note: You can select a row in the Data window and see a preview of your label in the Layout window.
  11. Click the Print icon. You see a window like this:


  12. Select the number of labels you want in the Copies box.
  13. Select the options you want in the Data Importing section.
  14. Click OK to print your labels.