How to print labels with data retrieved from a CSV File/Excel File/People's app using Label Wizard?


In this tutorial, we are going to use the Label Wizard to create labels with data retrieved from a CSV File. The steps are similar if you have data stored in an Excel spreadsheet or in Microsoft People app.

1. First, tap on the "+" button on the top left-hand corner of the app and select "New Label Wizard". Select "Avery" as the "Vendor" and the "5160 Label Address" in "Templates". Click on the "Next" button when you are ready.




2. In "Label Objects", select "CSV File" as the "Data Source" and ensure "Use Sample" is checked. The CSV sample is available for viewing/editing in "Help -> Samples". You can also choose to use your own CSV file without the "Use Sample" option. Finally, tap on the "Create Label" button.




3. The "Label Wizard" imports data from the CSV file and automatically generates 5 Text objects corresponding to the first 5 columns in the CSV file.




4. You can touch up the design and modify the objects with the WYSIWYG designer.

5. Tap on the Preview button (blue button on the top app bar) to preview the labels with the data.




Useful Tips

1. The Label Wizard by default generates 5 Text objects corresponding to the first 5 columns of the CSV file. You can easily add additional columns by adding a Text object and then changing the "Type" property to "CSV Column".

2. You can refresh your Data Source by tapping on Setup Fields from the top Ellipsis. On the Flyout, select the CSV File type and tap on the Select button to select a new CSV file. The data in the new CSV file will be automatically imported.

3. You can also use the Label Wizard to import data from an Excel spreadsheet or contacts from Microsoft's People app.