Last Updated on November 3, 2023 by Jake Sheridan
In this tutorial, you will learn how to create labels from Google Sheets.
How To Create Labels From Google Sheets
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.
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.
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.
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.
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.
Next, open up a new Google Docs project.
Select Extensions > ‘Create & Print Labels…’ > Create labels.
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.
A text box and several gridlines should now appear in the current page.
Click on the Select a spreadsheet option under the Mailing list section.
Select the spreadsheet that contains the table with the mailing list data.
Use the Select a merge field dropdown menu to start inserting fields into the textbox.
Click on Create labels to create a new document that fills out the rest of the label template.
The add-on should now provide a link for you to access the label template.
This guide should be everything you need to create mailing labels from Google Sheets.