Online apps and platforms like Google apps have made all things easier to do online. For your e-commerce business, you can further step it up with an easy way to print labels directly from Google Sheets. In this post, we’ll show you how to print address labels using the Labelmaker Plugin easily. 

How Do I Make Labels in Google Sheets?

To make labels from Google Sheets, follow these steps:

1) Prepare Document
2) Install Labelmaker
4) Choose Template
3) Open Labelmaker
5) Format label
6) Create Labels & Open Document
7) Print your Labels

1.

Prepare your Document

Open your spreadsheet which contains the data you want to print. Make sure you have them organized with headers, just like in the photo below. 

Make-Labels-in-Google-Sheets

If you have your data in an offline document that you access with Microsoft Excel, OpenOffice, or other platforms, you can upload them easily into Google Sheets. All you need is a Google account, and you can have access to your documents with any device. Moreover, we have a separate guide in printing labels for MS Office if you want to print them while keeping them offline.

Select the right sheet label size before printing!

2.

Install Labelmaker

Make-Labels-in-Google-Sheets

Labelmaker is a plugin available in the Google Workspace Marketplace, used for creating labels from Google Docs and Google Sheets. Proceed here to install Labelmaker

In installing Labelmaker, you need a Google Account and accept the terms and conditions of the plugin.

3.

Open Labelmaker

Make-Labels-in-Google-Sheets

Once installed, return to your document. In your Google Sheets, click on the ‘Add-ons’ menu. Click on ‘Create & Print Labels- Avery & Co,’ and finally ‘Create labels.’  This action will open the Labelmaker sidebar. 

4.

Choose your Template

Make-Labels-in-Google-Sheets

In the sidebar, choose the appropriate label sheet you are using. There are more than 5000 labels to choose from, which are categorized to find your label easier. You can also search for the label code above. 

5.

Format your label

Make-Labels-in-Google-Sheets

After selecting your sheet template, you can now design and format your labels. First, click on the drop-down menu under ‘Add merge fields.’ Then click on the details you want to include in every label. 

The Label Content Space will show how you format the label. You can arrange and format the details in this space, such as setting them in boldface, italic, underline, and aligning them in the middle of the label. 

6.

Create Labels and Open your Document

Once your labels are complete with the details you need, click ‘Create Labels.’ This action will generate your document ready for printing. It will take a few seconds to a minute, depending on the number of labels you generate. 

Once the document is ready, an ’Open Document’ button will show. It will open your document prepared in Google Docs. 

Make-Labels-in-Google-Sheets

7.

Print your Labels

To print your labels, click ‘File’ then ‘Print’ or ‘Ctrl+P’ on your keyboard. This action will open a window where you can adjust print settings. For label making, here’s a rundown on the following print settings to adjust:

  • Select the correct printer to use.
  • Click on more settings to show additional settings.
  • Check your paper size. 
  • Set the margins to ‘None.’
  • Change the Scale to ‘Custom,’ then type in 100%.

Finally, hit ‘Print.’

Make-Labels-in-Google-Sheets-7

FAQ

How to Print Labels Without Word?

You can print labels by following this tutorial and having Google Docs and Google Sheets. Not only can you print your labels online, but you also have access to your documents online using any devices you own. 

Is Labelmaker Free?

Labelmaker offers free label making for thirty days. Moreover, you can sign up for a yearly license for $29.99/ year or a lifetime license for $79.99. 

Can You Create Labels in Google Docs Instead of Google Sheets?

Yes, you can follow the same tutorial in creating labels on Google Docs. Just make sure you still have the database ready on Google sheets. You may favor creating labels on Google Docs than on google Sheets as you can directly see how the labels would look on print. For a clearer procedure in doing this, check out this video by Labelmaker: 

How to Create the Same Label for a Whole Sheet?

You can do this, too, with Google Docs and Labelmaker. Just follow these steps:

  • Create a new document in Google Docs.
  • Click ‘Add-ons,’ ‘Create & Print Labels- Avery & Co,’ and then ‘Create labels.’ The Labelmaker sidebar opens.
  • Select your template and click ‘Use.’ This will create cells in the document representing the labels on the sheet.
  • On the first cell, place the details for your label. Format them as desired. 
  • Make sure the option ‘Use first cell as a model’ is checked.
  • To duplicate the label, click on ‘Create labels.’ This action will generate a new document which you should open as you click ‘Open document.’
  • A new Google Docs file will open, with duplicated labels ready for print. 

Wrapping Up

The convenience of doing everything online is such a treat. Combining it with quick and easy label printing allows you to have more time to get hands-on with your business. Just make sure to have everything set up at first, and choose compatible and high-quality label sheets. With good label sheets, downtimes and troubleshooting won’t eat away time and resources. 

Related Articles:

Like & follow our social media pages to see more updates and promotions !

Leave a Reply