Design and Print Labels with Google Docs

The easiest way to create and print Avery labels from Google Docs. Use this LabelMaker to design your label template and import/mail merge data from a Google Sheet.

Step 1: Install the 'Avery Label Merge' add-on

  • From Google Docs go to Add-ons -> Get Add-ons

  • Search for 'Avery Label Merge'.

  • Install the Add-on and finish the wizard steps

  • To start the add-on go to Add-ons -> Avery Label Merge -> Start

Step 2: Choose your source of data

  • [This step can be skipped if you are printing identical labels.]

  • From the sidebar click “Select Spreadsheet” to choose a Google Sheet file from which you want to merge data. You can choose any file you have access to include files from another Google Drive or Shared Drive.

  • Make sure the first row in your sheet contains column names. Such as ‘Fullname’, ‘Address’, ‘Email’, etc.

Step 3: Choose an Avery Template

  • Click the default 'Avery 5160' template to change to an other template.

  • When you do so the Label Template box changes to the size of the chosen template.

Step 4: Design and format your label template

  • In the template label box insert your text, images, tables and *|Merge Fields|* as required.

  • Format your text with any color, size and font.

  • More info here

Step 5: Print or make labels in Google Docs

  • Hit the blue 'Merge Labels' button if you want to mail merge data from a Google Sheet.

  • Hit the blue 'Identical Labels' button if you do not need to import data from a Google Sheet but just print your label template for a number of times

  • A new Google Docs is then created with the list of labels. You can also download a PDF version of it.

  • Open this newly created document and go to File -> Print in order to print on your Avery Label Sheets in your printer.

  • Make sure you have the right printer settings.