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.
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 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
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.
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.
Related articles: