We’ve talked before about Google Docs, the free online office suite available to everyone with a Gmail address. Today I’m going to show you how to print labels using these programs. It’s not quite as straightforward as it is with Microsoft Office, but once you get the proper add-ons in place, you’ll quickly get the hang of it.

First, you’ll need to open Google docs. Go to your Gmail inbox and click the little square of squares at the top right. Select Docs from the drop-down menu.


Click the big + sign for a new blank document.


Here’s what you’ll see:


Click Add-ons at the top.


Choose Get add-ons from the drop-down menu.


You’ll see a number of add-ons to choose from.


Type  Avery Label Merge. The add-on is free. Just click the Free button to add.


Now that we have our document ready to go, we can click the link in the instructions to create a spreadsheet where you can input addresses. If you already have a spreadsheet made in Excel or another spreadsheet, try opening in Google Sheets and saving as a Google Sheet.


Or you can choose Sheets from the Google Drive Menu and create a new spreadsheet.


Make sure to name the columns in row 1. Then add the information.



Tomorrow, in part 2 of this tip, we’ll begin our mail merge.

~ Cynthia