A Step-By-Step Guide to Printing Labels from Google Sheets

Download Article

Print mailing labels from an address sheet in Google Sheets with an add-on

Written by Darlene Antonelli, MA

Last Updated: August 5, 2023 Fact Checked

Download Article

Installing the Add-on

|

Creating the Labels

|

Printing Your Labels

|

Q&A

|

Tips

Do you want to print labels from a list of addresses in Google Sheets? You can use a simple Google Sheets extension called Labelmaker to print mailing labels in seconds. Labelmaker takes the column headers from your address list in Google Sheets, turns them into fields, and then creates a label sheet you can print from Google Docs. You can use Labelmaker for free to print as many labels as you want for 7 days. This wikiHow article will teach you how to print mailing labels using data from Google Sheets.

Things You Should Know

To find the add-on, click the "Extensions > Add-ons" in Google Sheets and download "Create & Print Labels."
Labelmaker is free for 7 days, and you can print as many labels as you want.
Give your data useful column headers like Name, Address, and Phone number so they're easy to merge into labels.

Part 1

Part 1 of 3:

Installing the Add-on

Download Article

1
Open your project in Google Sheets. Go to https://docs.google.com/spreadsheets/ in a web browser and open your project that has the mailing labels.
- If you don't have a project already, you can start a new one by clicking the + in the lower right corner of your screen.
A menu will drop down.

Advertisement
This will open a new window in the center of your screen.
Click the search bar, type Create & Print Labels, and then click Create & Print Labels - Label Maker for Avery & Co by "Labelmaker."
Follow the on-screen instructions to install the free label maker extension.

Part 2

Part 2 of 3:

Creating the Labels

Download Article

It's at the top of your Google sheet.
2
Select Create & Print Labels and click Create Labels. This opens the Labelmaker panel on the right side of your worksheet.
- To make sure your address data fits nicely onto the printed labels, make sure the first row of your Google sheet contains simple headers like Name, Address, City, State, and Zip.
3
Select a template. Click Select a Template under "Label template" to view your options.
- Grab the label sticker sheets you'll be printing to, and look for a 4-digit numeric code (e.g., "Avery US Letter – 2164 Shipping"). You can search for the code to find the correct template.
- Alternatively, click the "Browse by vendors" drop-down menu to select the manufacturer of your address labels, then select the proper sheet code from the list.
- When you're finished, click Use to choose your template.
4
Add merge fields for the labels. The "Add merge fields" drop-down menu contains all of the column headers from your address sheet. To add elements of each address (e.g., name, street address, etc.) to the printed address label, you'll need to add fields for each data type to the label in the order it should appear.
- To add the first field to the label (e.g., the name of the person you're mailing to), select the desired field from the menu (e.g., Name). This will add the column header name to the label between two angle brackets like this: <<Names>>.
- You can add multiple fields to each line on the label. For example, if you have separate columns for first and last names, you can add <<First>> <<Last>> to the first line.
- Place each field on the lines on which you want them to appear. For example, <<Names>> on the first line, <<Address>> on the second line, and <<City>><<State>><<Zip Code>> on the third line.
- You can also use the buttons below the fields to make text bold, justified, centered, and more.
This creates a Google Doc file containing your address labels in the proper printing format.

Part 3

Part 3 of 3:

Printing Your Labels

Download Article

1
Click Open document after creating your labels. You'll see this green button in the right panel.
- If you closed Google Sheets prematurely or don't see the "Open document" button, open https://docs.google.com/document and double-click the document called "Labels for (your template name)."
- If there's something wrong with the labels, you can close the Docs window and edit the Google Sheets version, then click Create Labels again.
2
Click the File menu and select Print. This opens the print dialog on your computer.
- Alternatively, press Ctrl + P (Windows) or Cmd + P (Mac).
3
Set your printing preferences. To make sure your labelsprint properly, you'll want to choose the following:
- Select your printer from the "Destination" menu.
- Click More settings to expand additional options.
- Set "Margins" to None.
- Set "Scale" to 100%. To do this, click the Scale drop-down, select Custom, and then enter 100.
- Make sure "two-sided" is not selected unless your sheet of labels is double-sided.
- Set the margin to 0 and scale to 100%. Make sure you have the correct paper size before you print.
- You may consider only printing the first page for now to make sure it prints properly.
If you haven't already done so, make sure you've properly inserted the adhesive paper you'll be printing on according to the instructions in the packaging.
This prints the labels to your label sheets.^{[1]
X
Research source}

Community Q&A

Search

Add New Question

Question

When I create the label, it only shows up on the first label on the sheet. I want a whole sheet of the same label. How can I do this?

Community Answer

Highlight the information on the first label you have. Then copy and paste it onto the additional labels. This should be done only if you want the same information on each label.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 3
Question

Where does the zip code go?

Cuireuncroco

Community Answer

In your spreadsheet, create a column named "zip", for example. Fill in the cells in this column with the zip code for each recipient. Then add this variable to your labels to have the zipcode variable populated.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

How do I print a label with a return address in top left corner and mailing address more to the middle right?

Cuireuncroco

Community Answer

You can use the formatting options available in the sidebar to place the return address in the top left corner and the mailing address to the middle right. Alternatively, use the Google Docs version of the add-on to create your labels in a more visual way. The Google Docs version will offer more formatting options.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 0