Printing labels is often necessary for small businesses that regularly ship out products or for individuals who send out many packages. However, printing labels can be a massive pain, especially if you don’t know how to go about it, while writing ready-made labels by hand is even more of a hassle.
Fortunately, this article teaches you how to print labels from Google Sheets in the simplest way so you can improve your shipping process with more efficient methods. That way, you can avoid manually hiding gridlinesand individually printing selected cells in Google Sheetsper label.
Table of Contents
How To Print Labels From Google Sheets
Set Up Your Mailing Data On a Google Sheet
If you haven’t done so yet, input all the necessary data of the people you’ll be shipping things to onto a spreadsheet. This will be your primary source of information when printing labels from Google Sheets.
Make sure you reserve the first row for your headers for basic information like name, address, state, and phone number. To give you an idea of what you’re spreadsheet should look like, we’ve prepared a spreadsheet using the sample databelow:
![How To Print Labels From Google Sheets [Quick Guide] 2024 (1) How To Print Labels From Google Sheets [Quick Guide] 2024 (1)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-69.png)
Install The Labelmaker Plugin In Your Google Chrome Browser
Labelmaker is a plugin that allows you to generate and print labels from either Google Docs or Google Sheets. It includes a free 7-day trial before requiring a purchase. To install it, follow the steps below:
- Head to “Extensions” > “Add-ons” > “Get add-ons” in your Google Sheets or Google Docs.
![How To Print Labels From Google Sheets [Quick Guide] 2024 (2) How To Print Labels From Google Sheets [Quick Guide] 2024 (2)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-70.png)
- Type “labelmaker”into the search bar and hit“Enter.”
![How To Print Labels From Google Sheets [Quick Guide] 2024 (3) How To Print Labels From Google Sheets [Quick Guide] 2024 (3)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-71.png)
- Select the option labeled “Create & Print Labels – Label maker for Avery & Co.”
![How To Print Labels From Google Sheets [Quick Guide] 2024 (4) How To Print Labels From Google Sheets [Quick Guide] 2024 (4)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-72.png)
- Click the “Install” button. You should get a few confirmation prompts. Continue until the add-on is successfully installed.
![How To Print Labels From Google Sheets [Quick Guide] 2024 (5) How To Print Labels From Google Sheets [Quick Guide] 2024 (5)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-73.png)
- Alternatively, open this linkin a Chrome browser to head straight to the Labelmaker add-on page.
Launch The Labelmaker Add-on
Head back to the spreadsheet you made in step one, which you’ll use to create labels from Google Sheets.
Click “Extensions” > “Create & Print Labels – Label maker for Avery & Co” > “Create labels.”
![How To Print Labels From Google Sheets [Quick Guide] 2024 (6) How To Print Labels From Google Sheets [Quick Guide] 2024 (6)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-74.png)
Decide On a Template
A panel on the right side of your Google spreadsheetshould appear near the top. Click “Select a template.”
![How To Print Labels From Google Sheets [Quick Guide] 2024 (7) How To Print Labels From Google Sheets [Quick Guide] 2024 (7)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-75.png)
Youcan choose from the “Browse by vendors” dropdown menu and select the template that best meets your needs. You can also use the search bar near the panel’s top to look for template options via code.
![How To Print Labels From Google Sheets [Quick Guide] 2024 (8) How To Print Labels From Google Sheets [Quick Guide] 2024 (8)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-76.png)
When ready to proceed to the next step, click the “Use” button to select a template.
Format Your Label
Once you decide on a template, the next step is to format the label data according to how you want it to appear after printing.
You can do this by clicking the dropdown under the “Add merge fields” header and selecting one of the fields that appear in the list. You’ll notice that the column headers in your spreadsheet populate the dropdown list.
![How To Print Labels From Google Sheets [Quick Guide] 2024 (9) How To Print Labels From Google Sheets [Quick Guide] 2024 (9)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-77.png)
When you click one of the merge fields, it should appear in the “Label content”text box below.
![How To Print Labels From Google Sheets [Quick Guide] 2024 (10) How To Print Labels From Google Sheets [Quick Guide] 2024 (10)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-78.png)
Continue to add the fields you want on your printed labels. Move them around and add line breaks to get your desired format.
Note: The way you place the fields in the “Label content” textbox is how they’ll appear when printed. For example, if you set the “Address” field in the middle center of the textbox, that’s the way it’ll show up on your label.
You can also utilize formatting options like Bold, Italic, and Underline.
![How To Print Labels From Google Sheets [Quick Guide] 2024 (11) How To Print Labels From Google Sheets [Quick Guide] 2024 (11)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-79.png)
When you’re all set, click the “Create labels” button. After a few seconds, Labelmaker will generate a Google Doc with your selected information and formatting. Click the “Open document”button when it appears.
Note:You can also include a return address on your label. Make sure you add that information to your Google spreadsheet before launching Labelmaker and going through the motions.
To add a return address, from the “Add merge field” dropdown menu, situate the return address at the top-right corner of the “Label content”textbox or any other place you want it to be.
![How To Print Labels From Google Sheets [Quick Guide] 2024 (12) How To Print Labels From Google Sheets [Quick Guide] 2024 (12)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-80.png)
5. Start Printing
Related: How to Print Google Docs with Comments
Once you have finished creating your label, it is ready for the next step of printing.
Click the “Open document”button. A Google Doc should appear in a separate tab showing the full details of the mailing data from your formatted spreadsheet and in the same format as the Labelmaker add-on.
![How To Print Labels From Google Sheets [Quick Guide] 2024 (13) How To Print Labels From Google Sheets [Quick Guide] 2024 (13)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-81.png)
From there, hit “Ctrl + P” on your keyboard to open the print window and select the appropriate settings. Make sure to choose the right printer and paper size.
You can also click the “More settings” dropdown menu for further options. In this section, you’ll want to set “Margins” to “None” and change “Scale” to “Custom,” followed by entering 100 in the field that appears.
![How To Print Labels From Google Sheets [Quick Guide] 2024 (14) How To Print Labels From Google Sheets [Quick Guide] 2024 (14)](https://i0.wp.com/spreadsheetpoint.com/wp-content/uploads/2023/02/Untitled-82.png)
To finalize the printing process and print your labels, click the “Print” button.
Frequently Asked Questions
Can You Print Labels From Google Sheets?
Yes. You can create mailing labels from Google Sheetsby using the right extension. Labelmaker is one of many label-making plugins available for Google Sheets, allowing you to do this quickly and easily. All you have to do is follow the steps outlined above.
How Do I Print Avery Labels in Google Sheets?
The Labelmaker add-on includes templates for various Avery labelsizes and product types, allowing you to print mailing labels from Google Sheets using an Avery label of your choice.
Does Google Sheets Have a Label Template?
Google Sheets doesn’t feature a built-in label template and requires an extension like the Labelmaker add-on described in this article to make creating labels easier.
Wrapping it Up
If you’ve been racking your brain on how to print labels from Google Sheets, the answer is much simpler than you think. Using the right add-on for your spreadsheet, you can effortlessly arrange the mailing data to the format and arrangement of your choosing. Then, print it out according to the labels you want.
Related articles:
- Set the Print Area in Google Sheets
- Google Sheets Page Break Guide
- How to Print on One Page in Google Sheets