Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Free: Create Avery Address Labels in Google Docs

Create Avery Address Labels in Google Docs for FREE. Use this step by step guide for how to make labels in Google Docs.
Free: Create Avery Address Labels in Google Docs

How to create avery address labels in Google Docs? There is no reason to spend $80 on the Add-on for Google Docs in the marketplace. There is a free solution that is easy to use! Create Avery labels in Google Docs for free. 

Create Avery Address Labels in Google Docs

Choose from the wide array of label sizes. You can use official Avery labels or generic ones with the Avery code. Take note of the label code when setting up for printing. 

Addresses in a Spreadsheet

Data is much better in a Google Sheets spreadsheet. Organize the names, email addresses, or other information you want to place into the labels in a spreadsheet.

2 Free Options to Create Avery Labels in Google Docs

Table of Contents

Labels in Google Docs

Creating labels in Google Docs requires creating a table. Knowing the label size and space between the labels. The margins and spacing information should be provided on the label packaging. Using an Add-on for Google Docs makes this process easier. Select the Avery label number within the sidebar. 

Try Foxy Labels Add-on for Google Docs

To create a template within Google Docs, try Foxy Labels Add-on. Use the Extensions menu to show the Foxy Labels sidebar. Select the Avery label number. The table with the correct dimensions will be added to the Google Doc.  

Free version allows for a limited number of label creation.

Add Label Details

The Add-on creates the table structure. Modify each label or merge from Google Sheets.

Avery Address Labels in Google Docs screenshot with foxy labels sidebar. Shows a grid of label rectangles.

Learn More about Google Docs from Teacher Tech

Create Avery Address Labels in Google Docs

You have a spreadsheet with names and addresses and want to create an address label for each. How do you print onto Avery address labels? I looked up the Add-ons for Google Docs but the ones in the marketplace cost money. There is no reason to spend $80. Create Avery address labels in Google Docs.

Create labels for free from the Avery website.

Avery provides a solution for Google Docs users FOR FREE!

Start with a Spreadsheet

The first thing you want is a spreadsheet with names and addresses (or whatever information you want to merge to create labels.) Create this in Google Sheets. Create a copy of my sample spreadsheet. Try it out.

Learn More about Google Sheets from Teacher Tech

Addresses on the First Sheet

The FIRST sheet contains the merge information. Drag the tab in the spreadsheet with the addresses to the first position.

Delete Extra Rows

If there are extra blank rows, be sure to delete them before merging to avoid blank labels. 

Activated rows can be blank and will create blank labels.

Tip: Highlight a few ROWS below your last address and right click to delete the rows. This will prevent blank pages of labels.

Create Labels on the Avery Website

The free feature on the Avery website allows you to create labels for Google Docs. Choose “Design & Print with Google.”

Click on “Get Started.”

Choose the Template Number

Type in the Avery label number.

Select Your Label Design

Screenshot of Avery site. Choosing a template of various styles for the template.

Choose the Merge

On the left hand side select “Import Data Mail Merge.”

Select Google Drive

When choosing to import data for the labels the default is to upload from your computer. INSTEAD, click on the “Google Drive” button.

Screenshot from Create Avery Address Labels in Google Docs import data screen showing you connect to Google Drive

Select Your File

Choose the spreadsheet. Make sure the FIRST tab contains the addresses.

Uncheck the Header Row

If the first row of your spreadsheet says “name” and “address.”

Drag the Fields

Design your label. Drag the fields to put the values in the order that you want them. A sample will be displayed.

Preview the label, I had to delete the sample text on the label.

Preview and Print

Click the “Preview and Print” button.

Print it Yourself

Unless you want to pay to have the labels shipped to you, click on “Print it Yourself.”

Export PDF

Export the labels as a PDF and use Control P to print from the PDF.

© 2024 All Rights Reserved.