Create, Design, and Print Avery Labels

Using Google Docs with an Online Label Maker

Install Avery Label Merge to create, design, and print Avery labels using Google Docs with an Online Label Maker

Google Docs

Introduction

The instructions below explain how to create, design, and print Avery labels using Google Docs with an online label maker in two different ways, depending on the requirements:

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

For example, when the Identical Labels option is used to create identical return address Avery sticker labels by directly entering the name and address of a recipient into an Avery label template.

Merged Avery labels: When unique content is merged into each label.

For example, when the Merge Labels option is used to create address Avery sticker labels, mailing Avery sticker labels, or shipping Avery sticker labels by merging the names and addresses of the recipients into an Avery label template.

Watch tutorial video or follow instructions below

Step 1: Start Avery Label Merge add-on

Start Avery Label Merge by clicking on Extensions > Avery Label Merge > Start to display Avery Label Template Box and Avery Label Merge sidebar.

Avery labels are created, designed, and printed using Avery Label Merge sidebar.

Step 2: Select source data file

For identical Avery labels: Proceed to Step 5 to create identical return address Avery sticker labels.

For merged Avery labels: From Avery Label Merge sidebar, click on Select Spreadsheet to select the Google Sheets file that is going to be used to merge data to create Avery sticker labels.

This can be a file from Google Drive, Shared Drives, or any other file. Once selected, the name of the spreadsheet ( Student Records, etc.) appears in the File field.

For example, to create address Avery sticker labels, mailing Avery sticker labels, or shipping Avery sticker labels the speadsheet needs to contain the names and addresses of the recipients.

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

Step 3: Select Google Sheets tab

From the Sheet drop-down menu, select the tab in the Google Sheet that is going to be used to merge the data to create Avery sticker labels.

Step 4: Check source data

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

To be able to merge, there needs to be at least one row of data under the column names.

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

For identical Avery labels: Text and images are inserted directly into Avery Label Template Box as required, to create the identical return address Avery sticker label that can be replicated as required.

For merged Avery labels: Insert *|merge fields|* into the Google Docs label template by clicking in the desired location within Avery Label Template Box, then selecting a field from the Merge Field drop-down menu and clicking on Add. Repeat these steps for all the required *|merge fields|*.

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

For example, to create address Avery sticker labels, mailing Avery sticker labels, or shipping Avery sticker labels, the Google Docs label template is going to contain *|merge fields|* for the names and addresses of the recipients.

Step 6: Browse Avery label templates

Click on the Label / Envelope field to display the list of the available Avery label templates.

Step 7: Select Avery label template

Select an Avery label template from the list and click on Apply. Search by label code, size, description, and so on. Alternatively, a custom label size can be created.

Once an Avery label template is selected, Avery Label Template Box changes to the size of the selected template.

For example, if one wishes to create, design, and print address Avery sticker labels, mailing Avery sticker labels, shipping Avery sticker labels, or identical return address Avery sticker labels, a popular Avery label template could be selected, such as Avery 5160 or Avery 8160.

Step 8: Design and format Avery label in Google Docs

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

The font, color, size, and so on, of the *|merge fields|* can be changed in the Google Docs label template in the same way as regular text. The Google Docs label template can be further customized with advanced label formatting and dynamically merged images that are ideal for QR codes, barcodes, profile images, and so on.

Step 9: Create Avery labels

For identical Avery labels: Click on Identical Labels to create Avery labels.

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

Step 10: Options to download Avery labels

After a message appears that confirms the number of labels generated (the number of rows merged), choose either to display the merged Avery sticker labels in a Google Doc and/or a PDF.

Avery labels are now automatically saved on Google Drive.

Step 11: Print Avery labels

In the newly created Google Doc, click on the Print icon to print Avery labels.

Read this article about how to print labels using Google Docs, and how to avoid labels becoming misaligned.

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

Thank you for using Avery Label Merge add-on. For additional guidance, visit the Help section.

Report abuse