In this tutorial, you will learn how to print labels from Google Sheets.

How To Print Labels From Google Sheets

Whether you are printing labels for mailing addresses, product information, or anything else, it can certainly be a time-consuming process. Printing labels through a Google Sheets table can be a great way to automate this process.

Google Sheets can generate labels from your data with just a few clicks through an add-on.

In this guide, we will show you how to print labels from Google Sheets.

How to Print Mailing Labels Using Google Sheets

Here’s how to print mailing labels using Google Sheets.

Step 1

First, prepare a table containing the data you need for your mailing list.

In the example above, you have name and address data of your customer that you want to convert into a postage label.

Step 2

In a Google Docs project, click on Extensions > Add-ons > Get add-ons.

Step 3

Type ‘label maker’ into the search bar. Click on the add-on titled ‘Create & Print Labels…’ by the developer Labelmaker.

Step 4

Hit the Install button to enable the add-on for your account.

Step 5

In the Extensions drop-down list, you should now be able to see options related to the label maker add-on. Select the Create labels option.

Step 6

Choose a label template and select your prepared spreadsheet as a data source for the mailing list.

Step 7

Add the merge fields in your preferred order and format. Each merge field corresponds to a column from the original mailing list data.

Afterwards, click on Create labels to generate the new document.

Step 8

Click on the link shown in step 1 below.

Step 9

Google Docs will show you the add-on output in a new tab. Select File > Print to view the printing options.

Step 10

Users can now specify how they want to print their document through the current browser’s Print Dialog box.

In the example above, we’ll simply save the current document as a PDF file before sending the file to a printer.

Summary

This guide should be everything you need to print labels from Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.