Create, Design & Print Avery Labels

From Google Sheets with this Online Label Maker

Install this online label maker add-on to create, design and print Avery labels from Google Sheets

From Google Sheets

Introduction

The steps below detail how to make labels in Google Sheets and can be followed to design and print labels from Google Sheets in two different ways, depending on the requirements:

Identical Avery labels: When the content of each label is the same.

For example, how to do labels in Google Sheets for return addresses: The identical labels option can be used to create return address label stickers by entering the name and address directly into an Avery label template in Google Sheets.

Merged Avery labels: Ideal for creating labels when you want to merge unique content into each label.

For example, how to make address labels in Google Sheets: The merge labels option can be used as an Avery address label, mailing label and shipping label printer by merging the recipients' names and addresses into an Avery label template in Google Sheets.

Watch this online label maker tutorial or follow the steps below

Step 1: Select source data file

For identical Avery labels: Proceed to Step 2.

For merged Avery labels: Open the Google sheet you want to merge from.

Make sure the first row in Google sheet contains column names, such as Name, Address, City State, Zip Code etc. These column names are going to be used as *|merge fields|* in the Avery label template.

To be able to merge, you need to have at least one row of data under column names.

For example, if you wish to design and print Avery address labels, shipping labels or mailing label stickers, the speadsheet needs to contain the names and addresses of the recipients. This step is not necessary for identical return address labels.

Your Google Contacts can be impored into a Google sheet by following the instructions in this article.

Step 2: Start Avery Label Merge add-on

Start Avery Label Merge online label maker add-on by clicking on Extensions > Avery Label Merge > Start to open the Avery Label Merge dialog box.

In the dialog box, you can design and print labels from Google Sheets.

Step 3: Insert and format text or |merge fields|

For identical Avery labels: Create and design the static label as required, which can be replicated as many times as required.

For merged Avery labels: Insert *|merge fields|* into an Avery label template by clicking in the desired location within the Google Sheets label template box, selecting a field from the Merge Field drop-down menu and clicking Add.

Repeat this step for all required *|merge fields|*.

*|Merge fields|* are the column names found in the first row of data in the Google sheet.

For example, if you wish to design and print Avery address labels, shipping labels or mailing label stickers, the Avery label template is going to contain *|merge fields|* for the names and addresses of the recipients. Text and images can be inserted directly into the Google Sheets label template box for identical return address labels.

Step 4: Browse Avery label templates

Click the Label / Envelope field to display a list of Avery templates.

Step 5: Select Avery label template

Select an Avery template from the list and click Apply.

You can search by label code, size, description and more.

For example, if you wish to design and print Avery address labels, shipping labels, mailing labels or return address label stickers, you may wish to select a popular Avery template, such as Avery 5160 or Avery 8160.

Step 6: Design and format Avery label in Google Sheets

Format the text or *|merge fields|* as required.

The font, color, size, and so on, of the *|merge fields|* can be changed in the Avery label template in the same way as regular text. The Avery label template can be further customized by dynamically merging images that is ideal for QR codes, barcodes, profile images, and so on.

Step 7: Filter rows

For identical Avery labels: Proceed to Step 8.

For merged Avery labels: Click Filter Rows.

This creates a new column in the Google sheet called Filter Rows to Merge. Following the mail merge, the empty cells in the Filter Rows to Merge column are populated with the date/time the merge took place. To merge these rows again, you need to clear/delete the date/time values.

Step 8: Create Avery labels from Google Sheets

For identical Avery labels: Click Identical Labels to create Avery labels from Google Sheets.

For merged Avery labels: Click Merge Labels to begin the label merge process and create Avery labels from Google Sheets.

The merged Avery label stickers are automatically saved on Google Drive.

Step 9: Print Avery labels

In the newly created label document, click the Print icon to print the Avery labels from Google Sheets (via Google Docs).

Read this article to see how to print labels from Google Sheets and to avoid the labels becoming misaligned.

The Avery address labels, shipping labels, mailing labels or return address labels are now going to print.

Thank you for using Avery Label Merge online label maker add-on. For additional guidance, visit our Help section.

Report abuse