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
Start Avery Label Merge by clicking on Extensions > Avery Label Merge > Start to display the Avery Label Template Box and the Avery Label Merge sidebar.
Avery labels can be created, designed, and printed using the Avery Label Merge sidebar.
Step 2: Choose source data
For identical Avery labels: Proceed to Step 5 to create identical return address Avery sticker labels.
For merged Avery labels: From the Avery Label Merge sidebar, click on Select Spreadsheet to choose the Google Sheets file that is going to be used to merge data to create the 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 under the File field, then the spreadsheet can be opened by clicking on the file name.
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 tab
From the Sheet drop-down, select the tab in the Google Sheet that is going to be used to merge the data to create the 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 the Avery label template.
To be able to merge, there needs to be at least one row of data under the column names.
Step 5: Add text or *|merge fields|*
For identical Avery labels: Text and images are inserted directly into the 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 the Avery Label Template Box, then selecting a field from the Merge Field drop-down 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: Choose Avery label template
Select an Avery label template from the list and click on Apply. Search by label code, size, description, etc. Alternatively, a custom label size can be created.
Once an Avery label template is selected, the Avery Label Template Box changes to the size of the chosen 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, etc., 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, etc.
Step 9: Create Avery labels
For identical Avery labels: Click on Identical Labels to create the Avery labels.
For merged Avery labels: Click on Merge Labels to begin the label merge process and create the Avery labels.
Step 10: Options to download Avery labels
A message is going to be received confirming the number of labels generated, and therefore the number of rows merged. There is going to be an option to display the merged Avery sticker labels in a Google Doc and/or a PDF.
The Avery labels are now automatically saved in the Google Drive.
Step 11: Print Avery labels
In the newly created Google Doc, click on the Print icon to print the Avery labels.
Please read this article for how to print the labels using Google Docs, and to avoid the 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 the Avery Label Merge add-on. For additional guidance, please visit the Help section.