Download Article
Print mailing labels from an address sheet in Google Sheets with an add-on
Download Article
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.
Steps
-
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.
-
Click the Extensions tab. A menu will drop down.Advertisement -
Hover your mouse over "Add-ons" and select Get Add-ons . This will open a new window in the center of your screen. -
Search for the "Create & Print Labels" extension. Click the search bar, type Create & Print Labels , and then click Create & Print Labels - Label Maker for Avery & Co by "Labelmaker." -
Click Install . Follow the on-screen instructions to install the free label maker extension.
Advertisement
-
Click the Extensions menu. It's at the top of your Google sheet. -
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.
-
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.
-
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.
-
Click Create Labels . This creates a Google Doc file containing your address labels in the proper printing format.
Advertisement
-
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.
-
Click the File menu and select Print . This opens the print dialog on your computer.- Alternatively, press Ctrl + P (Windows) or Cmd + P (Mac).
-
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.
-
Insert the label paper into your printer. 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. -
Click Print to print your labels. This prints the labels to your label sheets. [1] X Research source
Advertisement
Community Q&A
Search
-
QuestionWhen 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 AnswerHighlight 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.
-
QuestionWhere does the zip code go?CuireuncrocoCommunity AnswerIn 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.
-
QuestionHow do I print a label with a return address in top left corner and mailing address more to the middle right?CuireuncrocoCommunity AnswerYou 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.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
- If you don't want to use a premium add-on, try printing labels in OpenOffice.Thanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
Advertisement
About This Article
Thanks to all authors for creating a page that has been read 136,915 times.
Advertisement
