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.

Free: Create Avery Address Labels in Google Docs

YouTube video

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.

Avery provides a solution for Google Docs users FOR FREE!

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 so you can try it out.

First Sheet

The FIRST sheet in your spreadsheet needs to be the sheet that contains the addresses. You can drag the tabs in the spreadsheet to move a sheet to the first position.

Delete Extra Rows

I got a little copy paste happy with the labels I was making the other day. I had accidentally dragged my formula beyond my rows of names. I deleted the formulas, but it activated those rows.

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.

Avery Website

Your next step is to go to the Avery website. You want to “Design & Print with Google.”

Click on “Get Started.”

Choose the Template

Type in the Avery label number.

Select Your Design

You can design and create your label with images and fonts.

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.

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.

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.

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d