In this tutorial, you will learn how to create labels from Google Sheets.
How To Create Labels From Google Sheets
Quick Navigation
Creating labels from a Google Sheet table can be a reliable way to save time and ensure accuracy. For example, if you have a list of mailing addresses stored in a Google Sheet and you need to print labels for each address, you can use an add-on to do the work for you.
In this guide, we’ll explain how to create labels from Google Sheets using add-ons. We’ll explain how to download our preferred add-on from the Google Workspace Marketplace. We will also show how to use the add-on to output the result in a Google Docs project.
How To Generate Labels for a Mailing List in Google Sheets
Here’s how to generate labels for a mailing list in Google Sheets.
Step 1
First, collect your labels into a single spreadsheet. Ensure that each section of the label has its own column.
In our example above, we have separate columns for the first name, last name, and different sections of the address.
Step 2
Next, we’ll need to install a third-party add-on to handle the actual label generation. We can open the Google Workspace Marketplace by clicking on Extensions > Add-ons > Get add-ons.
Step 3
In the Google Workspace Marketplace dialog box, search for the ‘Create & Print Labels’ add-on by Labelmaker. Click on the add-on to view the add-on’s information page. Click on the Install button.
Step 4
Google Sheets will ask you if you are ready to install. Click on Continue to proceed.
Google Sheets may also ask you to authorize the third-party application. Follow the on-screen prompts to grant the application the proper authorization.
Step 5
Next, open up a new Google Docs project.
Select Extensions > ‘Create & Print Labels…’ > Create labels.
Step 6
A panel will appear on the right side of the project. Click on Select a template to select a particular label template to use for your mailing list.
Step 7
A text box and several gridlines should now appear in the current page.
Step 8
Step 8Click on the Select a spreadsheet option under the Mailing list section.
Step 9
Select the spreadsheet that contains the table with the mailing list data.
Step 10
Use the Select a merge field dropdown menu to start inserting fields into the textbox.
Step 11
Step 12
Click on Create labels to create a new document that fills out the rest of the label template.
Step 13
The add-on should now provide a link for you to access the label template.
Summary
This guide should be everything you need to create mailing labels from Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own. You may also check out the add-on’s output here.