Create, Design & Print Avery Labels

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 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 Sheets 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 Sheets label template.

2. 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 your Google Sheets label template.

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 your 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.

For example, if you wish to design and print Avery address labels, shipping labels or mailing 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.

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

This will open the Avery Label Merge dialog box. In the dialog box, you can design and print labels from Google Sheets.

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

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.

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 by dynamically merging images, which are ideal for QR codes, barcodes, profile images etc.

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

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

Your merged Avery label stickers will be automatically saved to your Google Drive.

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

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