Avery logo
Print this page Print
Avery Easy Merge for Office 365

Introduction

The Avery Easy Merge add-in makes it quick and easy to create labels, cards and name tags using an Excel spreadsheet. The information in your list is merged into Avery Design & Print Online, where you can format and print your project.

Additional Services and Accounts

This add-in depends on additional services and accounts:

Installing the Add-in

The add-in can be downloaded from the Microsoft Office Store at store.office.com.Search for "Avery Easy Merge".

Office Store Search

Select the add-in and follow the instructions to install. Once the add-in is installed in Excel, you can find it under Home tab > Avery Easy Merge.

Insert My Add-ins

Using the Excel Add-in

Your data should be organized in columns in Excel as shown below. The maximum number of columns is 20 and the maximum number of rows is 3,000. Click Export Now to get started.

Your data

Once your data has been processed, click Continue to Avery.com.

Continue to Design & Print Online

Next, enter your Avery product number in the Quick Search window or browse by product category on the left.

Quick Search

Click Select this Design on the blank or pre-designed template you’d like to use.

Select a Design

You should then see the information from your Excel file. Deselect any rows or columns you don’t want to include. If your spreadsheet includes a header row, be sure to deselect that row. Click Next.

Information from the Excel file

Drag and drop or double-click your data fields on the left to arrange them in the order you want. Click Next.

Drag and drop or double-click data fields

Now you will be able to edit your text and customize the placement, font size and style. Make changes to the whole sheet at once using the Edit All tab in the Navigator on the right side of the screen. If you want to make changes to individual labels or cards, switch to Edit One. When you’re satisfied, click Preview & Print.

Edit your text and customize

If your project looks good, you can choose to Print it Yourself, or some Avery products can be custom printed by our WePrint professional printing service by clicking Let Us Print for You.

Review and print

Click Print Now.

Click Print Now

A pdf will be generated. Follow the instructions for successful printing.

Remove the Excel Add-in: for Windows

  1. Click the Home tab, and then right-click on the Avery Easy Merge icon
  2. From the menu that pops up, select Remove Add-in
  3. Follow the instructions and the add-in will be removed. See screeshot below.
  4. Remove add-in for Windows

Remove the Excel Add-in: for MacOS

  1. Click the Insert tab, and then click My Add-ins.
  2. In Office Add-ins, click the 3 dots menu next to the Add-in.
  3. Click Remove. See screeshot below.
  4. Remove add-in for Windows
  5. Read the notice that appears regarding other devices and click Remove.