How do I import data from a spreadsheet (mail merge) into Avery Design & Print?

You can easily import data from a spreadsheet to create address labels, name badges, inventory labels and more.

First, make sure your data is arranged in columns on your spreadsheet (one column for names, one for addresses, etc.). Be sure this information is on Sheet 1 of your spreadsheet.

Mail merge headers

Second, open your project in Avery Design & Print Online. Click Import Data on the left of the Customize screen. Then click Browse to find your Excel or CSV file. When your data is displayed, you can deselect any rows you don’t want printed, such as the header row.

Import data Mail Merge

Click Next and then double-click or drag and drop data from the Available Fields on the left to the Arrange Fields box on the right, which represents the text box of your item. (You'll be able to format your text in a later step.) Once you’re done arranging your fields, click Next and then click Finish. This will return you to the Customize screen where you can make formatting changes.

Note: Any changes you make will appear on all items unless you switch to the Edit One tab in the Navigator on the right side. A good idea is to make your formatting changes first using Edit All, then switch to Edit One to personalize text and images on individual items. Once you make changes to individual items, they won't be affected by future Edit All changes

Discover how easy it is to create a mail merge using Avery Design & Print (version 8.0). It's simple to import names, addresses and other data in just a few quick steps. Avery Design & Print mail merge is ideal for mass mailing, invitations, branded mailings, holiday address labels and more.