How To Print Labels From Google Sheets [Quick Guide]

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

  1. 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:

Sample spreadsheet of data, including name, address, number, state, and zip code.
  1. 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:

  1. Head to “Extensions” > “Add-ons” > “Get add-ons” in your Google Sheets or Google Docs.
Google Docs Extensions option, displaying where to add "Add-on" plugins.
  1. Type “labelmaker” into the search bar and hit “Enter.”
Google workspace marketplace search bar, searching for labelmaker.
  1. Select the option labeled “Create & Print Labels – Label maker for Avery & Co.”
Google workspace marketplace, displaying the search for "Create & Print Labels - Label maker for Avery & Co."
  1. Click the “Install” button. You should get a few confirmation prompts. Continue until the add-on is successfully installed.
The final step to install the Google plugin, Labelmaker.
  1. Alternatively, open this link in a Chrome browser to head straight to the Labelmaker add-on page.
  1. 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.”

Google Sheets displaying how to create labels using Labelmaker.
  1. Decide On a Template

A panel on the right side of your Google spreadsheet should appear near the top. Click “Select a template.”

Google plugin, Labelmaker, displaying where to select a template for a label.

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.

Labelmaker's label options, displayed via product numbers.

When ready to proceed to the next step, click the “Use” button to select a template.

  1. 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.

Labelmaker's dropdown menu, displaying the merge field options, including name, address, zip code, state, and number.

When you click one of the merge fields, it should appear in the “Label content” text box below.

Labelmaker's "Label content" box.

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.

Labelmaker's "Label content" box displaying the label format of a pre-printed label.

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.

Labelmaker displaying the "Print" button.

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.

Display of the mailing data in the chosen format.

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.

"More Settings" displaying how to scale and customize printing options.

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.

Related articles:

Most Popular Posts

Related Posts

Thanks for visiting! We’re happy to answer your spreadsheet questions. We specialize in formulas for Google Sheets, our own spreadsheet templates, and time-saving Excel tips.

Note that we’re supported by our audience. When you purchase through links on our site, we may earn commission at no extra cost to you.

Like what we do? Share this article!