Create, Design & Print Labels

From Google Docs with this Online Label Maker

Install this add-on to create, design and print labels from Google Docs

From the Google Docs Add-on

Step 1: Start Avery Label Merge

Start the Avery Label Merge add-on by clicking Add-ons > Avery Label Merge > Start.

This will display the label template and open the Avery Label Merge sidebar.

Step 2: Choose your source of data

For identical labels: Proceed to Step 5.

For merged labels: From the Avery Label Merge sidebar, click Select Spreadsheet and choose the Google Sheets file from which you want to merge data.

This can be a file from your Google Drive, Team Drives or any other Google Drive you have access to.

Step 3: Select your Sheet

From the Sheet drop-down, select the tab in your Google Sheet that you want to merge data from.

Step 4: Check your source data

Make sure the first row in your Google Sheet contains column names, such as Name, Address, City State, Zip Code etc. These column names will be used as *|merge fields|* in your label template.

To be able to merge, you need to have at least one row of data under your column names.

Step 5: Add your text or |merge fields|

For identical labels: Enter your label text directly into the label template.

For merged labels: Insert *|merge fields|* into your label template by clicking in the desired location within the template, selecting a field from the Merge Field drop-down and clicking Add.

Repeat this step for all required *|merge fields|*.

*|Merge fields|* are the column names found in the first row of data in your Google Sheet.

Step 6: Browse Avery templates

Click the Label / Envelope field to display a list of label templates.

Step 7: Choose an Avery Template

Select a label template from the list and click Apply.

You can search by label code, size, description and more.

Once a template is selected, the label template box changes to the size of the chosen template.

Step 8: Design and format your label

Format your text or *|merge fields|* as required.

You can change the font, color, size, etc. of the *|merge fields|* in your label template in the same way you would regular text. You can further customize your label template with advanced label formatting and images.

Step 9: Create your labels in Google Docs

For identical labels: Click Identical Labels to create your labels.

For merged labels: Click Merge Labels to begin the label merge process.

This will create a Google Doc containing your labels. You will also have the option to download your labels in PDF format.

Step 10: Print or make labels in Google Docs

In your newly created label document, click the Print icon to print your labels.

Make sure you have the correct printer settings.

Report abuse