How to Make Avery Labels from an Excel Spreadsheet

Go to Avery's design and print center online to create your labels.

Select "Address Labels" from the category. Check the product number of the Avery labels you're using, then pick a matching number from "Find Product Number or Description" and click on "Next."

Choose "Blank Design" from "Select Category." Then click on the design on the right to load it on your screen.

Choose "Mail Merge" for your editing option and click "Next."

Click on the "Browse" button to retrieve the Excel spreadsheet file you want to use. The "File Upload" window will open.

Double-click on the file and click "Next." The Excel data within the spreadsheet will be displayed.

Select "Use your first row of data as column headings" and click "Next."

Choose "Add Text Box" from the left to add a text box to your label. Then select the text box on the right. Click on the "Merge Field" button (on the left). The fields in your Excel spreadsheet will be displayed.

Double-click the field you want to place within the text box.

Double-click another field (from the left) that you want to include on your label. Then repeat until each field is added.

Arrange the fields on your label, so they look the way you want. To place a field on another line, place your cursor before the field's bracket and press the "Enter" key. To add a comma, place your cursor after the field's bracket and insert the comma.

Select "Next" when you are done.

Choose to fill your labels across or down and click "Next."

Select "Print Your Project" to print your labels immediately or "Save Your Project" to keep a copy of the merged labels in your files.