Create and Print Labels in Google Sheets: For pulling information into uniform printed labels, Google Sheets can be a useful tool. However, the Print labels function is not included in Google Sheets, thus one needs to use the “Create & Print Labels” Add-ons function from Google Workspace Marketplace.
Create and Print Labels add-on extracts data from the Google Spreadsheet and exports the data into Google docs in ready to print format. On this page, we have provided all the necessary information on how to Print Labels with important Google Sheet tips. Read on to find out more.
Table of Contents
Installing Create & Print Labels Using Add-ons
Firstly, let’s understand how to install the “Create & Print Labels” from Add-on’s function into the Google Sheet by following the steps given below:
- Step 1: Open the Google Spreadsheet.
- Step 2: Click on the “Add-ons” button.
- Step 3: Now you will be directed to the Google Workspace Masterplace. Now in the search bar, type “Create and Print Labels“.
- Step 4: The following result will be shown on the screen. Click on “Install“.
- Step 5: Now read the conditions and select “Continue“.
- Step 6: A new tab will open. Click on “Allow“.
Now the Add-on is added into the Google Sheets.
- How to Set Print Area in Google Sheets: Page Setup, Print Layout in Google Sheets
- How to Create a Dependent Drop Down List in Google Sheets: Multiple Drop Down List
- How to Make a Pie Chart in Google Sheets: Customize Pie Chart
How to Print Labels from Google Sheets?
Let’s consider that we have a dataset whose name, address and other information is stored in the Google Sheet. Make sure you are marking row 1 as headers.
Now follow the steps listed below to create labels and print the same.
- Step 1: Click on Add-Ons and select “Create & print labels“.
- Step 2: Select “Create Labels” from the drop-down menu.
- Step 3: Select a display template from the “Label template” section. This field may already be set, but it must be for the add-on to function.
- Step 4: Select a template from the drop-down option under “Select a template from the list below.”
- Step 5: To get a list of the most regularly used labels, select the “Most popular templates” option. Avery’s most popular template.
- Step 6: A few layouts for address, shipping, and insertable divider labels appear in the “Most popular templates” category. Choose the first “US Letter” choice from the drop-down menu.
It is “Avery US Letter – 5176 Easy Peel® Address Labels” in the context of the instruction.
- Step 7: To continue, click “Use.”
- Step 8: Choose the spreadsheet you wish to use for the labels in the “Mailing list” section. Here we are using the “Labels” workbook and the “data” spreadsheet.
- Step 9: Then, in the space under “Content,” format the label to your choice. It works by wrapping the “ >>” wrapper around the column header. As a result, the “Name” column is indicated by “Name>>.”
- Step 10: By choosing “+ Add a merge field” and selecting “Zip Code” from the drop-down menu, you can add “Zip Code” to the content section.
- Step 11: Enter “City,” “State,” and “Zip Code” on the same line to properly format the label. After “City,” add a comma and a single space to separate the bottom row data.
- Step 12: To create labels in a Google Docs document, click “Create labels.”
- Step 13: To see the labels right away, click “Open document” to open the newly produced Google Docs file.
- Step 14: The label document will open in Google Docs as a result of this action.
- Step 15: By selecting “File” and “Print,” you can now view and print the address labels in Google Docs just like any other document.
- Step 16: Then, to finish the process, follow the interface particular to your device and printer. To print the labels, just use the keyboard shortcut “Cntrl+P” or just click on the Print icon in the toolbar.
- Step 17: Preview the document and click on “Next“.
- Step 18: Click on “Print“. The labels will be printed in the document.