Create, Design & Print Avery Labels

From Google Docs with this Online Label Maker

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

From the Google Docs Add-on

Introduction

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

  1. Identical Avery labels: Ideal for creating labels when you want the content of each label to be the same.

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

  1. 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 Docs: 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 your Google Docs label template from a Google Sheet.

Watch this online label maker tutorial or follow the steps below

Step 1: Start Avery Label Merge

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

This will display the Google Docs label template box and open the Avery Label Merge sidebar. From the sidebar, you can design and print your Avery labels.

Step 2: Choose your source data

For identical Avery labels: Proceed to Step 5.

For merged Avery labels: From the Avery Label Merge sidebar, click Select Spreadsheet and choose the Google Sheets file from which you want to merge data.

This can be a file from your Google Drive, Shared Drives or any other file you have access to. Once selected, the name of your spreadsheet (e.g. Student Records) will then appear under the File field and can be opened by clicking on the file name.

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

You can import your Google Contacts into a Google Sheet by following the steps in this article.

Step 3: Select your Sheet

From the Sheet drop-down, select the tab in your Google Sheet that you want to merge data from.

Step 4: Check your source data in Google Sheets

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

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

Step 5: Add your text or *|merge fields|*

For identical Avery labels: Create and design your static label which will be replicated as many times as you wish.

For merged Avery labels: Insert *|merge fields|* into your Avery label template by clicking in the desired location within the Google Docs label template box, selecting a field from the Merge Field drop-down 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 your Google Sheet.

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

Step 6: Browse Avery templates

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

Step 7: Choose an Avery Template

Select an Avery template from the list and click Apply.

You can search by label code, size, description and more. Alternatively, you can create a custom label size.

Once an Avery template is selected, the Google Docs label template box changes to the size of the chosen template.

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

Step 8: Design and format your label in Google Docs

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

You can change the font, color, size, etc. of the *|merge fields|* in your Avery label template in the same way you would regular text. You can further customize your Avery label template with advanced label formatting and dynamically merged images, which are ideal for QR codes, barcodes, profile images etc.

Step 9: Create your Avery labels in Google Docs

For identical Avery labels: Click Identical Labels to create your Avery labels in Google Docs.

For merged Avery labels: Click Merge Labels to begin the label merge process and create your Avery labels in Google Docs.

Step 10: Option to download labels in PDF format

You will receive a message confirming the number of labels generated, and therefore the number of rows merged. You have the the option to open your merged Avery label stickers in Google Docs and/or PDF format.

Your Avery labels will be automatically saved to your Google Drive.

Step 11: Print your Avery labels in Google Docs

In your newly created label document, click the Print icon to print your Avery labels in Google Docs.

Please read this article to see how to print labels from Google Docs and to avoid your labels becoming misaligned.

Your Avery address labels, shipping labels or return address labels will now print.

This concludes the steps detailing how to create labels in Google Docs. Thank you for using the Avery Label Merge online label maker add-on. For additional guidance, please visit our Help section.