How to print labels from excel with Avery Design & Print Online

First, be sure your data in the spreadsheet is arranged in columns.

Then, in step 3 Customize

• On the left click on Import Data and select Start Import/Merge

• Next, select Browse for File and locate your spreadsheet (Available file types: .xls, xlsx and csv). If you get an error, try saving your file as a .csv and re-upload.
• Note: The Google Drive steps are temporarily disabled at this time. Please save your document as a .csv file

• In Choose Fields, confirm your list and uncheck the first row if you have headers. You can also use the up/down arrows in the top row of grey checkboxes to sort the columns alphabetically or numerically. If everything looks correct, move forward to the next step.

to print on labels" width="518" height="225" />

on the labels" width="628" height="211" />

• Arrange your fields by dragging and dropping Available Fields to Arrange Fields
• Double click or drag and drop the field from the left to set up information how you would like it to appear (see example below - info on different lines)

• Click Next
• Click on Finish - Once you click finish you have completed the merge process.

More Mail Merge Help:

Video Demo

Was This Article Helpful?