Turn Your Address List into Labels

turn address list into address labels

A quick and easy way to create personalized address labels is with Avery Design & Print. Here’s how to use the mail merge feature to turn your address list into labels in minutes. This is a must-have for mass mailings you’re sending to multiple recipients.

If you don’t have a spreadsheet of your contact names and addresses yet, you can get started with our pre-formatted files for Microsoft Excel or other database programs.

Step 1: Go to Avery Design & Print Online

Open the free Avery Design & Print Online software at avery.com/print. To start a new project, type your Avery product number and hit Enter on your keyboard.

Go to Avery Design & Print Online & Choose your design

Step 2: Choose your design

Use the menu on the left to view design categories. When you find a design you’d like to use, click Select this Design.

Select text box and import data

Step 3: Select text box and import data

First, resize the text box to be big enough to hold your addresses. Otherwise, your text will be shrunk to fit. Next, click on the edge of the text box and select Import Data from the menu on the left.

Locate your spreadsheet

Step 4: Locate your spreadsheet

Browse to find your spreadsheet file on your computer.

Step 5: Review address list

Uncheck any items you don’t want to be included, such as the header row on your spreadsheet.

Review list

Step 6: Arrange fields

Select a field on the left and drag it over to place it on the right. You can also double-click. If you accidentally drop a field in the wrong place, simply delete then drag and drop again.

Arrange fields

Step 7: Mail merge

Review the instructions for making changes to the format of your content. Then click Finish.

Merge to turn address list in to labels

Step 8: Make final formatting touches

Changes you make will apply to all the labels while the Navigator is on Edit All, so finalize your design first. Then switch to Edit One if you need to change any individual labels, but after that, Edit All will no longer apply to those labels. Click Save and then Preview & Print.

Choose your print option

Step 9: Choose your print option

Select Print It Yourself to print using our Blank Labels by the Sheet or our retail packs your own printer. Choose Let Us Print for You to have Avery WePrint, our professional printing service, print your project for you and deliver it to your door in about three business days.

Author: Melanie Neff

Melanie has an extensive writing background built on an impressive journalism foundation. As a reporter for USA Today and The Los Angeles Times for almost 20 years, she covered everything from the Los Angeles riots, fires, and floods to LA Lakers, Raiders and Clippers games and movie premieres. She followed her newspaper career with a long tenure covering commercial real estate financing and development. Melanie has been writing about small business marketing and labeling needs for the last 12 years. She thrives on reading, researching and expanding her knowledge of everything going on in today's business world and looks to provide the most valuable information she can to her readers.

2 thoughts on “Turn Your Address List into Labels”

  1. When making address labels, I created a new list in excel and saved it to the desktop. However, when I merge and print it reverts to a saved list from four years ago. How do I delete this old, old, old list and print the new list?

    1. Hi Tom,
      If you log into your account and go to Files, you can upload your updated mailing list. We would recommend renaming that file with the current date. You can also delete the old spreadsheet file from your account as well. If you are trying to replace the mailing list on a saved project, in the customize screen select Import Data/Mail Merge then select Replace Spreadsheet on the left side. This will allow you to merge the updated list to your labels. You can reach out to our Care Team at 800-462-8379 and we would be happy to screen share with you to help.

Comments are closed.