Using Avery WePrint Import Data Feature

Create a list of the names in a spreadsheet. You can have multiple columns of information if need be.

Make your selection with the configurator and enter the design tool.

On the Select Design screen you can either choose a blank template to create your design from scratch, or choose from one of our predesigned templates to edit.

Click “Import Data” on the left hand side of your screen, and then click the "Start Import / Merge".

Click the “Browse for file” button, and navigate to the location of the spreadsheet on your computer. The above screen will appear. If you do not want your header row of titles on your labels, remove the tick from row 1. You can also deselect any columns you don't want to see on your labels. When ready, click “next”.

Arrange your data fields into the order you would like them to appear on your label. Drag the data headings from the left hand side and drop them into the box on the right. You can drop fields next to each other if you would like the information to appear next to each other on the label.

When you click “Finish” your data will automatically be transferred to individual labels.

If you still have “edit all” selected on the right hand side of your screen, you can now format all your names at once. Simply highlight the name on any label on your canvas, then change your font, its size, the colour or relocate the text field to where you want the addresses to be placed on the label. You can also add images and borders.

IMPORTANT: If you want to make changes to individual labels (perhaps if one name is longer than the others), click “Edit one” on the right-hand side before editing that specific label.

When you’re happy with all of your labels, click next. You will be then shown a preview of 1 design, or if you would like to see a pdf preview of all the names,  click “Download Digital Print Proof”.

If happy, Add to Bag.