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.
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.
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.
Tip: Highlight a few ROWS below your last address and right click to delete the rows. This will prevent blank pages of labels.
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.
Print it Yourself
Unless you want to pay to have the labels shipped to you, click on “Print it Yourself.”
Export the labels as a PDF and use Control P to print from the PDF.