Google Sheets can be a helpful tool for pulling information into consistent printed labels.
However, Google Sheets doesn’t include the capability to print labels. Instead, you can add this functionality with the free “Create & print labels” add-on from Labelmaker.
The add-on pulls information from a Google Sheets spreadsheet, formats it, and exports it as a ready-to-print Google Docs document. Once created, you can print the label documents the same way you’d print any other document.
The tutorial covers installing the “Create & print labels” add-on and how to use it.
Install the Create & Print Labels Add-on in Google Sheets
The G Suite Marketplace offers an easy way to augment Google Sheets with new functionality. To install the “Create & print labels” add on, follow these steps:
- Go to the “Create & print labels” G Suite Marketplace page “https://gsuite.google.com/marketplace/app/create_print_labels/585829216542” in your web browser and click the “install” button.
- This will launch the “Get ready to install” window, which mentions how the add-on needs permission to install. Click the “Continue” button to advance.
- Follow the on-screen instructions to complete the installation process. You may be asked to select your Google Account from a list because the add-on connects to the account, not the device you’re using. On the final permissions screen, click “Allow” to complete the installation process.
Now that the add-on is installed, we’re ready to use Google Sheets to create and print labels.
How to Print Labels from Google Sheets
Google Sheets is versatile in the kinds of labels it can make. For ease-of-use, this tutorial demonstrates how to create a mailing label from an existing spreadsheet.
The example spreadsheet stores name and address information for 10 people.
Note: Your spreadsheet must use a header row for the label maker to work.
The following steps explain how to format the spreadsheet information into a US mailing label, but it can be modified to use any format. Follow these steps to create and print a label in Google Sheets:
- Launch the “Create & print labels” add-on by opening the “Add-ons” header menu, selecting “Create & print labels” from the list, and choosing “Create labels.” This will launch the “Create and print labels” modal.
- Next, click on the “Label template” field to choose a display template. This field may be already set, but if it isn’t it needs to be for the add-on to work.
- If you’re unfamiliar with Avery and other template formats, use the most popular option to simplify the process. Click the drop menu under “Select a template in the list below.”
- Choose the “Most popular templates” option to bring up a list of the most commonly used labels.
- The “Most popular templates” list brings up a few templates that cover address, shipping, and insertable divider labels. Select the first “US Letter” option from the list. In the case of the tutorial, it is “Avery US Letter – 5176 Easy Peel® Address Labels.” Click “Use” to continue
- Use the “Mailing list” section to choose the spreadsheet you want to use for the labels. In the tutorial’s case, we’re going to use the “Labels” workbook and the “data” spreadsheet.
- Next, use the space under “Content” to format the label to your desired layout. It works by using the column header with the “<< >>” wrapper. So the “Name” column is represented by “<<Name>>.” The field responds to spacing, line breaks, and character insertion.
- Add “Zip Code” to the content section by clicking “+ Add a merge field” and selecting “Zip Code” from the drop-menu.
- Properly format the label by putting “City,” “State,” and “Zip Code” on the same line. Add a comma immediately after “City” and separate the bottom row values with a single space.
- Click “Create labels” to build the labels in a Google Docs document.
- If you want to view the labels now, click “Open document” to launch the newly created Google Docs file.
- This will launch the label document in Google Docs.
- You can now view and print the address labels like any other document in Google Docs by selecting “File” and “Print.” Then follow your device and printer’s specific interface to complete the process.
These steps complete the process for printing labels in Google Sheets.
Finding the Right Settings for Your Label Paper
While this tutorial covers the process for creating and printing labels based on information stored in Google Sheets, it is up to you to match the label template with your chosen printer label paper.
The printer label paper’s packaging will indicate its name and dimensions. Coincidentally, If you are using Avery brand “Avery US Letter – 5176 Easy Peel® Address Labels,” this tutorial uses the type you want to select.
The plug-in also comes with presets for Sheetlabels.com. If you’re using another brand of shipping labels you’ll need to find the Avery or Sheetlabels.com equivalent to get the right template settings.
This tutorial covered the groundwork you need to start printing labels from Google Sheets’ workbooks.
I hope you found this tutorial useful!
Other Google Sheets tutorial you may like:
- How to Set Print Area in Google Sheets
- Show / Hide Gridlines in Google Sheets
- How to Convert Excel to Google Sheets
Google Sheets and Microsoft Excel Expert.