Design & Print Online Mail Merge, Import Data from a Spreadsheet, Import Addresses from Excel/Numbers

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

First, be sure your data in the spreadsheet is arranged in columns.
spreadsheet formatted for mail merge in design and print online

Then, in step 3 Customize 
  • On the left click on Import Data and select Start Import/Merge 
how to print labels from excel 
  • 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.
browse for excel file for mail merge
  • 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.

choosing the fields to print on labels

  • 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)
arranging the fields on the labels
  • Click Next
  • Click on Finish - Once you click finish you have completed the merge process.

More Mail Merge Help:

Word Mail Merge 

Formatting Mailing List in Excel


Video Demo

Was This Article Helpful?