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](https://avery.sugarondemand.com/custom/KBImages/0EM0h000000g2je.png)
Then, in step 3 Customize
- On the left click on Import Data and select Start Import/Merge
![how to print labels from excel](https://avery.sugarondemand.com/custom/KBImages/3Start_Mail_Merge.png?force_download=0&1691512387181=1&platform=base)
- 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](https://avery.sugarondemand.com/custom/KBImages/4Browse_for_File_Mail_Merge.png?force_download=0&1691512415492=1&platform=base)
- 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.
- 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](https://avery.sugarondemand.com/custom/KBImages/5Arrange_Fields_Mail_Merge.png?force_download=0&1691512484165=1&platform=base)
- Click Next
- Click on Finish - Once you click finish you have completed the merge process.
More Mail Merge Help:
Formatting Mailing List in Excel
Video Demo