🔀Merge Sheet Data To Label Templates in Docs

1. Open a blank document in Google Docs

   Open a new Google Doc and leave it blank. You'll use this document to create and print labels.

1. Open Label Maker

In Google Docs, click on the "Extensions" menu, then select "Label Maker". If you haven't installed Label Maker yet, click here to install it. After it's installed, reload the Google Doc by closing it and reopening it.

1. Select A Template

Within the Label Maker sidebar pop-up, click on "Select a template", then select the template that you need. You can use the search bar to search by template ID or name. There are over 3,000 templates from Avery® US Letter, Avery® A4, Avery® Zweckform, Sheetlabels.com, OnlineLabels.com and Herma. Click "Apply Template".

1. Select A Sheet to Merge Data

Click "Select a spreadsheet"

1. Make sure your Sheet is formatted correctly. Column headings/fields will automatically be imported for you to select.

1. After your Sheet is selected. Navigate to Label Maker in the Google Doc and select the Sheet and Merge fields that you want to add to the label template.

1. Merge fields will be added to the first cell. Style the text according to your needs and make sure that the text stays within the templated cell size.

1. When you're happy with the formatting. Click the "Create labels" button. Your labels will be created.

1. Once your labels are done processing. Click "Open Document" to see preview your labels for printing.

1. Preview your labels to make sure you're happy with the formatting.

1. Print your labels. Click File --> Print. Make sure to set Margin to "None" and scale to 100%.

Make sure to set Margin to "None" and scale to 100%.

Note: The page size may need to match your label product. For instance, Avery® US Letter 5160 labels require "Letter" size.

That's it!