- The easiest way to Print Labels from Google Sheets: Prepare your label data in Google Sheets > Install the “Create and Print Labels” add-on > Select your label data in Google Sheets > Open the add-on via Extensions > Create & Print Labels > Create Labels > Choose a label template > Configure the label content > Customize the label format > Click “Create Labels” to generate labels > Open the generated Google Docs file > Print your labels using File > Print.
In this article, we will learn a very exciting technique. We are going to learn how to print labels from Google Sheets. These labels are fully customized and can be used for your mailing lists, your products, packaging, and so on. Excited right? Well. Before starting. I would like to highlight some key points. Printing labels from Google Sheets is not a direct way, we will use an add-on (there are so many available, you can use any of them).
We will first learn how to create them, then how to edit them, and finally how to print them for various purposes. This is the most awaited article in our Google Sheets Series. So, without further delay, let’s start with some advantages and usages to learn printing labels from Google Sheets.
Table of Contents
Importance of Printing Labels from Google Sheets
We certainly need labels if we are running an online business. We have so many usages of labels, for instance, if you are a digital marketer, you have a mail account and a mail list and you want to send marketing emails to your potential customers, now adding a label to your mail enhances your brand awareness and its authority 3 times compared to an unlabeled email. A label at the bottom of your email is a key point that convenience a user and there are chances that they will purchase your product or service.
Similarly, if you are working in E-commerce, drop-shipping, or you have a private label brand on Amazon, you need labels, you can either hire a graphic designer to design all your labels and then print them for your products, but this option is costly, or you can simply learn a simple trick and can do it for yourself with no more than 1 hour of your time maybe once or twice a month. This is the amount of time even business owners waste on social media.
Well, there are many more purposes behind creating and printing different kinds of labels. So, therefore, we need to learn how to print labels from Google Sheets.
How to Print Labels from Google Sheets?
First of all, we should have our label data on a sheet. It depends on you what details you want to use in your label. Let’s say you want to make labels for your E-commerce shipment, so the basic details you need are customer name, customer id, order number, total charges, customer address, etc. This data must be present in your Google Sheets file and then all you need to do is use an easy tool to convert this data into label format and then easily print them to paste on your physical products. This is very easy using the add-on. Let’s get started with the add-on installation then we will see how to use it.
How to Print Labels from Google Sheets – Get the Add-on
In this section, we will learn how to print labels from Google Sheets using the “Create and Print Labels” add-on. This add-on is paid but has a seven-day trial. You can use it, and if you like it then you can take your premium membership for unlimited usage. There are so many label template groups such as Avery Us letter, Avery A4, Avery R4 Photo size, Avery Zweckform, SheetLabels.com, OnlineLabels.com, and Herma. Each group has hundreds of templates and you get overall 5000+ free templates for different categories. Wow, that’s very cool. So, let’s go to the Sheets and install this add-on for free.
Go to Extensions > Add-ons > Get add-ons
Search for the add-on in the search box “Create and Print Labels”
Click on the add-on from the search results
Click on the Install button
Read the permission and access disclaimer, and click Continue to proceed.
Select a Google Account
Click on the Done button, and you have successfully installed the add-on. That’s great!
How to Print Labels from Google Sheets – Use Add-on to Create Labels
In this section, we will learn how to print labels from Google Sheets, and we will see how to use Create & Print Labels add-ons after a successful installation. We can access this add-on in two ways. We will see both of them, and till the printing of your labels, we will see each step with all the details.
Now, you have your sheets file ready, and you have also installed the add-on. Now follow the below steps to create and print labels from Google Sheets.
Prepare the data for your labels
Go back to Google Sheets, and Click on Extensions > Create & Print Labels > Create Labels
Go to Extensions > Add-ons > View document add-ons
Here you will get the document’s add-on, and you can use it directly.
As you click on the add-on, either way, a sidebar will open for the add-on, click on the Label template section to select a starter template
In the “Browse by Vendor” section, click on the dropdown list to select your label group, there are so many templates with their name, if you don’t know about names, you can try a few of them to get your desired one.
Now, select a label format from the given list.
Click on the “Use” button
Your template is selected and ready, now you need to quickly format your label body, first remove all the default text from the “Label content” textbox
Now, from the “Select a marge field” dropdown, select your column names to show on your labels, first select the first name, then the last name, then jump to the next line, select the address, and postcode, then again move to next line, and select city and state, and dont forget to add a comma between city and state, and address and postcode.
This is only a sample label format; you can change it depending on whatever your goal is.
For example: If you select First name: Then the first-row value of this column will be added, then you can write custom text such as adding a comma, bold your text, italic the text, underlining, or using alignment keys
Add all column’s data one by one, and you will see the live preview in the “Label content” textbox
When you are done, click on the “Create Labels” button below. It will take some load time.
Then you will see the “Open document” button, click on it, and it will land you to a new Google Docs file with your ready labels.
Here is your Docs file.
To print, go to File > Print. Adjust your print settings and click on print, and your labels will be printed.
This is how to print labels from Google Sheets using Create & Print Labels add-on. There are many more free and paid tools available in the market for creating and printing purposes. You can use any add-on that you like. I hope you find this guide helpful.
- Create & Print Labels is from Label maker for Avery and Co.
- Create & Print Labels – label maker for Avery and Co is a paid add-on, but you can use the train version for seven days.
- You can use more than 5000 free-to-use templates for your labels within this add-on with so many categories.
- There is a common problem with beginners, if you get your column headers instead of your original data in your Labels file generated by this add-on, then the solution is simple. All you need to do is close your add-on, reopen it, clear all the text inside the Label content textbox and start adding content from scratch.
- The labels are always editable, you can edit or customize them even from the auto-generated Docs file after creating it from the add-on
- If your Google Sheets file contains no data then you will not be able to make labels from this add-on
- If you have multiple sheets within a workbook or more data tables on a single sheet, then it can be problematic, you just need to have your data table alone on a single sheet (not a workbook) to get the benefits of this add-on properly without any hurdle.
Frequently Asked Questions
How to print labels from Google Sheets for free?
You can use Create & Print label add-on to print labels from Google Sheets for a free trial. You can use this add-on for seven days without a single cent. Then, if you think your business is increasing, I will suggest you buy the monthly plan. Else, you have many more tools available online free and paid, which offers these services, and you can use them. But I always recommend using add-ons from authentic sources to keep your data safe from any kind of piracy or theft.
Can I Use the Same Method to Print Labels from Google Sheets as I Can from Google Docs?
Yes, you can use the same method for google docs label printing as you can for printing labels from google sheets. Both applications offer label printing features that allow you to customize and print labels based on your needs.
Can the Same Method be Used to Print Addresses on Envelopes from Google Sheets?
To simplify the envelope address printing process, Google Sheets can be a handy tool. By using third-party add-ons or plugins, one can export contacts from Google Sheets and directly print them onto envelopes. These envelope address printing tips can save time and effort, ensuring accurate and efficient mailing solutions for individuals and businesses alike.
I am not getting values in my labels, instead, I am getting column headers, why is it?
It’s a common problem for beginners. The solution is simple, first, you make sure that you have cleared everything inside your Label content text box, now start adding items one by one with the help of the above dropdown, add all the column names, then repeat all the steps to print your labels, and you will get actual content instead of the header text.
This is all about how to Print Labels from Google Sheets. I tried to cover everything about the Create & Print Labels add-on. It’s a very popular add-on with over 5 million users. It’s a paid tool, but it’s authorized by the Google Workspace marketplace. I hope you find the above explanation helpful and that you have learned this topic completely. I will see you soon with another useful guide. Take care and keep learning with Office Demy.