Create, Design & Print Avery Labels
From Google Sheets with this Online Label Maker
From the Google Sheets Add-on
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 your requirements:
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.
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.
Watch this online label maker tutorial or follow the steps below
Step 1: Choose your source data
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.
Step 2: Start Avery Label Merge
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.
Step 3: 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 Sheets 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, shipping labels or mailing 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 Sheets label template box for identical return address labels.
Step 4: Browse Avery templates
Click the Label / Envelope field to display a list of Avery templates.
Step 5: Choose an Avery 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 your Avery label in Google Sheets
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.
Step 7: Filter rows
For identical Avery labels: Proceed to Step 8.
For merged Avery labels: Click Filter Rows.
This will create a new column in your 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 will need to clear/delete the date/time values.
Step 8: Create your Avery labels from Google Sheets
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.
Step 9: Print labels from Google Sheets
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.
Your Avery address labels, shipping labels, mailing labels or return address labels will now print.
This concludes the steps detailing how to create labels in Google Sheets. Thank you for using the Avery Label Merge online label maker add-on. For additional guidance, please visit our Help section.