How to Make Avery Labels from an Excel Spreadsheet
You can use data from an existing spreadsheet to generate labels. When you create a spreadsheet in Excel the data is arranged in columns and rows. Each column should include a heading, which will be used as fields when you pull your labels. The actual content (appearing on your labels) should be included below each heading. You can use mail merge to create Avery labels and choose your specific product number before you run them.
Things You'll Need
- Avery labels
- Microsoft Excel file
- Internet connection
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.