Are you looking for the quickest solution to print labels for a mailing list?
Google Sheets is one of the top tools for small and medium-sized e-commerce business owners. It helps them improve productivity and save time through a complete suite of spreadsheet formulas and features.
Printing labels is a daunting task without proper tools at your disposal.
Google Sheets can be used to print labels within a few seconds.
In this quick guide, let us discuss how to print labels from Google Sheets. Make sure to read this step-by-step guide till the end.
It is beneficial for businesses that send hundreds of shipments daily.
How to Print Labels for a Mailing List in Google Sheets
Google Sheets doesn’t come with any built-in tool to print labels. You need to install an add-on named Labelmaker.
It is the most popular tool for printing labels using Google Workspace products such as Docs and Sheets.
Let us start with the steps to print labels.
STEP #1 – Prepare a Mailing List
The first step is to create a mailing list in Google Sheets. Refer to the screenshot given below.
The columns included above are:
- First Name
- Last Name
- Address
- City
- State
- Zip Code
You can download and use the mailing list template we prepared for free.
Feel free to add more columns and include more data as per your business needs. The template can be customized without any limitations.
Suppose you have your contact details in an offline document like Microsoft Excel. Follow the steps below to import it to Google Sheets.
- Open a new Google Sheet by clicking here
- Hover to the main menu
- Click on the “File” button
- Choose “Import” from the list
- A new popup will appear on your screen
- Go to the “Upload” tab
- Press the “Browse” button as shown below
- Select the file from your local drive
- Press “Open” button
- Importing will take based on the size of your file
- A new popup will appear, as shown in the following image
- Press the “Import data” button
Once your file is ready in Google Sheets, make sure the headers are correctly formatted.
STEP #2 – Install Labelmaker Addon
As mentioned earlier, there is no built-in tool to print labels. You need to rely on a third-party add-on named “Labelmaker.”
Let’s start,
- Click here to open the add-on on Google Workspace store
- Press the “Install” button
- A new window will appear, as shown below
- Select your Google account
(Make sure it is the same Google account used to create the mailing list spreadsheet in Step 1) - Press the “Continue” button
- Grant permissions by clicking the “Allow” button
- Once the add-on is installed, you will see the following popup with the instructions to access it in Google Sheets
- Press the “Done” button to close the popup
Apart from Labelmaker, you can also use Foxy Labels, which work similarly.
STEP #3 – Launch Labelmaker Add-on
Now, you can go back to your Google Sheets containing the contact information.
Here’s how you can access the Labelmaker add-on in Google Sheets,
- Hover to the main menu and click the “Extensions” tab
- Choose the “Create & Print Labels – Label maker for Avery & Co” option
- Next, select “Create labels” from the list
It will open a dialog box on the right-hand side of the screen, as shown in the following image.
STEP #4 – Select a Template
In this step, you need to select a template to print labels from a predefined list.
The list is quite huge, and the selection depends upon your specific requirements. Make sure to explore the available options until you find the right fit.
Here’s how you can choose the template in the Labelmaker add-on:
- Click the button below the “Label template” option
- Click on the dropdown below the “Browse by vendors” option
- Select the vendor from the list
(For demonstration, I will stick to the “Most popular templates” option) - Choose the appropriate option from the box below the “Product number” option
- Press the “Use” button
The template is selected successfully. The selection is saved for future use. Simply put, next time onwards, wherever you open the Labelmaker, the template will appear in the Label template section.
STEP #5 – Format the Label
Now is the time to format our label using the contact details available in the spreadsheet.
Consider the following label, which includes full name, address, city, state, and zip code.
Let us learn to create this format.
- In the Labelmaker dialog box, Click the empty box below the “Label content” option
- Next, click the dropdown below the “Add merge fields” option
- Select the “First Name” from the list
- Press the “Spacebar” on your keyboard once
- Click on the merge fields dropdown again and choose “Last Name” from the list
- Now, press the “Enter” key
- Click on the merge fields dropdown again and choose “Address” from the list
- Press the “Enter” key
- Next, choose the “City”, “State”, and “Zipcode” from the merge fields dropdown
(Make sure to put the space between city and state) - Press the “Create labels” button
Your labels will be created in Google Docs. The add-on creates a new document for you.
Make sure to make the first name and last name bold. Also, play around with the available formatting option, as shown in the following image.
STEP #6 – Open Labels in Google Doc
Once the labels are created, you will see the following popup.
Note that the time will depend upon the number of labels you wish to create. For a considerable number of labels, you may have to wait for a few minutes.
Press the “Open document” button once the labels are created. It will open a new tab on your browser. You will be taken to a newly created Google Doc.
STEP #7 – Star Printing
This is the final step in printing labels using Google Sheets. Once you are satisfied with the print label structure and formatting, you may wish to print it.
Here are the steps to print labels using Google Docs,
- Hover to the main menu
- Click the “File” tab
- Select the “Print” option from the list
- A new popup will appear on your screen
- Choose the desired printer
- Make sure other settings are as per your requirement
- Press the “Print” button
Voila! Your labels are ready to be shipped.
FAQs – How to Print Labels from Google Sheets
Q. Can you print labels through Google Sheets?
Yes, of course. Users can easily print labels using Google Sheets. They need to install an add-on named Lablemaker. Click here to install.
In the above article, we have discussed the steps to use the add-on and print labels in Google Sheets.
It is a paid add-on that offers a 7-day free trial. If you find the tool useful, you can purchase it for just $79.99 for a lifetime.
They also have a yearly subscription plan, which costs $29.99 per year.
Q. What is the best Google App to make labels?
There are two popular add-ons: Labelmaker and Foxy Labels. Both of them are compatible with Google Sheets and Docs.
You need to consider the yearly subscription for both.
Labelmaker offers a 7-day free trial, and after that, you need to pay $29.99 per year. It allows users to print unlimited labels.
On the other hand, Foxy Labels offers a lifetime free plan that allows you to print up to 100 labels per document. For unlimited labels, you need to purchase the yearly subscription plan that costs $39 per year.
Obviously, Foxy Labels is the best affordable choice when it comes to small businesses looking to print less than 100 labels per document.
Q. Does Google have a label template?
No. Google Sheets doesn’t have any built-in template to print labels.
You can use third-party add-ons such as Labelmaker and Foxy Labels.
Here’s the link to download a free Mailing List Template to manage your contacts in Google Sheets.
Refer to the above sections to learn the steps to use Labelmaker to print labels using Google Sheets.
Q. How do I print Avery Labels in Google Sheets?
The Labelmaker and Foxy Labels include a massive list of Avery label templates.
You need to install these add-ons for Google Sheets. The steps to install and use these add-ons are mentioned above in this article.
Conclusion
Printing labels using Google Sheets is easier than you think.
If you are stuck somewhere while following the steps mentioned in this article, make sure to comment below. Our team will respond to your questions as soon as possible.
Note that the Lablemaker add-on is free for the first 7 days. After that, you need to purchase a yearly subscription that costs $29.99 per year.
If you don’t have the budget, then use the Foxy Labels. The steps to use the Foxy Labels are similar. It allows you to print up to 100 labels for free for a lifetime. To increase the limit, you have to purchase their yearly subscription, which is worth $39/year.
For more such tips and tricks to use Google Sheets like a pro, please explore our blog.