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.

google-open-google-docs

Click the big + sign for a new blank document.

create-new-google-doc

Here’s what you’ll see:

https://i0.wp.com/imgsrv.worldstart.com/images/ct-images/2017/06/google-doc-blank.jpg?w=616

Click Add-ons at the top.

google-doc-add-ons

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

google-doc-get-add-ons

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

google-doc-add-ons-list

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

google-doc-avery-label-merge

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.

google-doc-avery-label-merge-instructions

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

https://i0.wp.com/imgsrv.worldstart.com/images/ct-images/2017/06/sheet-menu-1.jpg?w=616

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

google-sheet-name-street-city

 

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

~ Cynthia