How to Print Labels from Google Sheets [Guide 2023]

How to Print Labels from Google Sheets 10

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

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.

See also  How to Sort in Google Sheets (Complete Guide)

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.

Step 1

Go to Extensions > Add-ons > Get add-ons

How to Print Labels from Google Sheets 1

Step 2

Search for the add-on in the search box “Create and Print Labels”

How to Print Labels from Google Sheets 2

Step 3

Click on the add-on from the search results

How to Print Labels from Google Sheets 3

Step 4

Click on the Install button

How to Print Labels from Google Sheets 4

Step 5

Read the permission and access disclaimer, and click Continue to proceed.

How to Print Labels from Google Sheets 5

Step 6

Select a Google Account

How to Print Labels from Google Sheets 6

Step 7

Click Allow

How to Print Labels from Google Sheets 7

Step 8

Click on the Done button, and you have successfully installed the add-on. That’s great!

How to Print Labels from Google Sheets 8

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.

Step 1

Prepare the data for your labels

How to Print Labels from Google Sheets 9

Step 2

Go back to Google Sheets, and Click on Extensions > Create & Print Labels > Create Labels

How to Print Labels from Google Sheets 10

Or

Go to Extensions > Add-ons > View document add-ons

Here you will get the document’s add-on, and you can use it directly.

Step 3

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

How to Print Labels from Google Sheets 11

Step 4

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.

How to Print Labels from Google Sheets 12

Step 5

Now, select a label format from the given list.

How to Print Labels from Google Sheets 13

Step 6

Click on the “Use” button

How to Print Labels from Google Sheets 14

Step 7

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

How to Print Labels from Google Sheets 15

Step 8

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.

How to Print Labels from Google Sheets 16

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

Step 9

Add all column’s data one by one, and you will see the live preview in the “Label content” textbox

How to Print Labels from Google Sheets 17

Step 10

When you are done, click on the “Create Labels” button below. It will take some load time.
How to Print Labels from Google Sheets 18

How to Print Labels from Google Sheets 19

Step 11

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.

How to Print Labels from Google Sheets 20

Step 12

Here is your Docs file.

How to Print Labels from Google Sheets 21

Step 13

To print, go to File > Print. Adjust your print settings and click on print, and your labels will be printed.

How to Print Labels from Google Sheets 22

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.

Important Notes

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

See also  How to Make a Timesheet in Google Sheets [Complete Tutorial]

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.

See also  How to Insert Google Sheets Data into Google Docs (Best Practice)

Conclusion

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.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq, I am a highly skilled technical writer working full-time for Office Demy. I am specialized in Google Workspace and Microsoft Office applications. With a background in Software Engineering, I possess a deep understanding of the intricate functionalities and features of these productivity tools. Connect me on Linkedin https://www.linkedin.com/in/shaiq-ansari/

OfficeDemy.com - Free Tutorials for Microsoft Office & Google Workspace
Logo
Enable registration in settings - general