This wikiHow teaches you how to use the Avery Label Merge add-on in Google Docs to print address labels from Google Sheets data.
Step
Part 1 of 4: Installing Avery Label Merge
Step 1. Open https://drive.google.com in a browser (browser)
If you are not logged in to your Google account, follow the instructions on the screen to sign in to your account.
Step 2. Click the New button (New)
This button is blue and is at the top left of the Google Drive page.
Step 3. Click Google Docs (Google Docs)
Clicking on it will open a new, unnamed blank document.
Step 4. Click the Add-ons menu
This menu is at the top of the document.
Step 5. Click Get add-ons (Get add-ons
..). After that, a list of available add-ons will appear on the screen.
Step 6. Type avery label merge into the search bar and press Enter or Returns.
After that, the Avery Label Merge add-on will appear in the list.
Step 7. Click the blue INSTALL button next to the description of the Avery Label Merge add-on
Clicking on it will install the add-on and display a pop-up window when the installation process is complete.
Step 8. Click the Continue button in the pop-up window
After that, the sign in to Google account page will appear on the screen.
Step 9. Enter your email address and password and click the NEXT button if you are not logged into your Google account
If you are already signed in to your Google account, select the account in the pop-up window. After that, a window asking for your permission will appear on the screen.
Step 10. Move the screen down and click the Allow button
After that, the add-on will be installed and you can use it to print labels from Google Sheets data.
Part 2 of 4: Creating an Address List
Step 1. Go to
Sign in to the Google account used to install Avery Label Merge if prompted.
If you already have an address list in Google Sheets, follow this method to make sure it's formatted correctly
Step 2. Click +
This button is a large box and is in the upper-left side of the page. Clicking on it will create a new document.
Step 3. Add column headings
This column contains the name for the type of data to be written in each column. Avery Label Merge requires column headings to be created at the top of the column.
For example, if you want to create a label that contains the name, address, city, province, and postal code of an Indonesian resident, you can name the columns A1 NAMA, B1 JALAN, C1 CITY, D1 PROVINCE, and E1 ZIP CODE
Step 4. Name the address list
To name the address list, click "Untitled document" in the upper-left corner of the document and type in a name, such as "Neighbor Address". After that, Google Sheets will save the data automatically.
Part 3 of 4: Combining Labels
Step 1. Open https://docs.google.com in a browser
Sign in to your Google account if prompted.
Step 2. Click +
It's in the top-left side of the page. Clicking on it will create a new document.
Step 3. Click Add-ons
This menu is at the top of the document.
Step 4. Click Mail Merge for Avery Labels
Step 5. Click Start
Step 6. Wait for the "Mail Merge for Avery Labels" window to appear on the screen
Step 7. Click " Label Size " to change the label size and paper size
- In the " Label Size & Page Layout " window, you can change the units of length (inches, centimeters, and millimeters) and paper size (A4, Legal, and Letter).
- You can also search for and select Avery templates by clicking the "Choose Avery Template" button in the "Mail Merge for Avery Labels" window.
Step 8. Click Select Spreadsheet
After that, a list of documents will appear on the screen.
Step 9. Select the document containing the address list and click the Select button
After that, the document information will appear on the right side of the label document.
Step 10. Add data into labels
You must add each column heading from the address list to its own row in the box in the center of the document. To add column headings, click each available column heading name in the " Add Merge Field to Label " column until it appears in the document.
Make sure each column heading is in its own column. Otherwise, the entire address will be printed on one line
Step 11. Click the Merge button
It's at the bottom of the "Mail Merge for Avery Labels" window. Clicking on it will combine the address of the selected document with the Google Doc. After that, you can start printing labels. When the merging process is complete, a confirmation window will appear on the screen.
Part 4 of 4: Printing Labels
Step 1. Load the label into the printer according to the instructions on the label package
This step will vary depending on the brand of printer and label.
Step 2. Click the "Print" icon
This icon looks like a printer and is in the top-left corner of Google Docs.
Step 3. Select a printer
If you can't find the printer in the options available in the “Destination” column, click See more… to look for it.
Step 4. Select the desired printing settings
You can select settings for data, printer, and labels.
Step 5. Click the Print button
It's blue and it's at the bottom of the window. After that, the label will start printing.
