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 gridlines and individually printing selected cells in Google Sheets per label.
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 data below:
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.
- Type “labelmaker” into the search bar and hit “Enter.”
- Select the option labeled “Create & Print Labels – Label maker for Avery & Co.”
- Click the “Install” button. You should get a few confirmation prompts. Continue until the add-on is successfully installed.
- Alternatively, open this link in 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.”
Decide On a Template
A panel on the right side of your Google spreadsheet should appear near the top. Click “Select a template.”
You can 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.
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.
When you click one of the merge fields, it should appear in the “Label content” text box below.
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.
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.
5. Start Printing
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.
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.
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 Sheets by 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 label sizes 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.