PLEASE DISCONTINUE THE USE OF THIS TICKETING SYSTEM

New Ticketing System

How to print labels using Google docs/sheets

*Library computers are now Google Chromeboxes

IF you're having trouble printing labels please follow this guide.


- Avery Label Merge Add-on neeeded

Google Docs recently added the ability to print labels with the addition of Add-ons. Add-ons for Google Docs are made by third-party developers in order to make Google Docs do more. Think of it as an App Store of sorts for the web based productivity suite.

To print labels within Google Docs, first you’ll have to add the Avery Label Merge add-on to Google Docs. To do this, create a new document in Google Docs and look towards top of the window. You should see a button labeled Add-ons towards the top of the window. From the drop-down menu, click on the button labeled Get add-ons...

From the add-on window, use the search bar located towards the upper right-hand corner of the window to search for the Avery Label Merge add-on. Once you find the add-on, install it by clicking on the add buttonthat is located towards the upper right-hand corner of the screen.

Now, use Google Docs to create a new spreadsheet using Google Sheets. This spreadsheet is where you’ll be putting all of the information you’d like to use in your labels. Use the first row of each spreadsheet as labels for the columns. So, if you’re making address labels, you’d want to label one column “name”, “street”, etc. After labeling these columns, enter the corresponding information that you’d like printed on labels below each label. Keep in mind that each row is it’s own label, so skip to a new row for each new label. 

Now, go back to your new Document and click on the Add-ons label. Hover over the option labeled Avery Label Merge and click on New Merge. From the popup window, select which type of label you’d like to make: an address label or a name label. You’ll then be prompted to select which type of Avery label you’ll be printing on, and then you’ll be told to select which spreadsheet you’d like the Avery add-on to pull information from. Choose the spreadsheet you just created and press the Select button located towards the lower, left-hand corner of the window.

Look towards the right-hand corner of your Google Document under the Avery label manage box. From here, you’ll see a list of the names of your columns in the sheet you just created. Select the columns you’d like to include in your document by clicking on them. Then, look towards the bottom of the window next to the header labeled Rows and make sure you’re merging information from the correct rows from the sheet.

After you’ve ensured all of the information that you’ve input is correct, look towards the center of your Google Document. You should see a textbox shaped like a square label with the names of your columns in double brackets. Arrange these names around the label like you’d like to have them printed.

Now, you’re ready to create your labels. Look to the bottom of the Avery label manage box and click on the button labeled Merge. You will then be prompted to view your labels in a new Google Document where you can print your labels.


Creation date: 9/26/2018 11:18 AM      Updated: 9/26/2018 11:18 AM