# Merge Sheet Data To Label Templates in Docs

1. **Open a blank document in Google Docs**&#x20;

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

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2F4rU3YRGb3UUFBnh7IqU9%2FScreenshot%202024-09-11%20at%205.04.43%E2%80%AFPM.png?alt=media&#x26;token=c15dcf36-5ca8-4bc4-8be9-0c58540b8839" alt=""><figcaption></figcaption></figure>

2. **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.&#x20;

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2FTiVUMbkLnBg2a3Y7WVrM%2FScreenshot%202024-09-11%20at%205.03.16%E2%80%AFPM.png?alt=media&#x26;token=9c4cd0fd-8f31-45e7-9ff7-901e5bdbc62c" alt=""><figcaption></figcaption></figure>

3. **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".

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2FeQLZ4UNKDE2VBJjzKkYP%2FScreenshot%202024-09-11%20at%205.05.59%E2%80%AFPM.png?alt=media&#x26;token=ba5c78b7-5472-43cc-b07a-eaabbc57ab1f" alt=""><figcaption></figcaption></figure>

4. **Select A Sheet to Merge Data**

**Click "Select a spreadsheet"**

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2FkghgmJ4lCpCMmauiFQTN%2Fselect%20spreadsheet.png?alt=media&#x26;token=75dd00d0-17f3-472b-bb02-a09be249e84b" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2Fxnk1fQZ6TZtrV1XJwnJx%2Fselect%20sheet%202.png?alt=media&#x26;token=be5f7d00-2a4d-4035-aa31-af32bd95c5c2" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2FSZHcCczw4vRBnzeDx1A9%2FScreenshot%202025-11-05%20at%2011.01.10%E2%80%AFPM.png?alt=media&#x26;token=910d063b-bb90-46f2-a5c9-c9a74d4fae58" alt=""><figcaption></figcaption></figure>

6. 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.&#x20;

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2FMOqF8PGkKVXtPpsta4Z3%2FScreenshot%202025-11-05%20at%209.32.49%E2%80%AFPM.png?alt=media&#x26;token=066e2e0a-63bc-4f26-b9f2-ede68e0d9ba2" alt=""><figcaption></figcaption></figure>

7. 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.&#x20;

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2FoCQ4wGtb6ZkNhBg2fjQw%2Fedit%20label.png?alt=media&#x26;token=343f3a8d-6b47-490b-8edc-056c83a1c108" alt=""><figcaption></figcaption></figure>

7. When you're happy with the formatting. Click the "Create labels" button. Your labels will be created.&#x20;

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2Fuiv043osROHKJXVlr6A2%2Fcreate%20labels.png?alt=media&#x26;token=9602b71f-4d8a-41a1-8fd8-ca6968f7411c" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2FeHpJdW6LoorHnMb1plXW%2Fopen%20document.png?alt=media&#x26;token=89e95d9d-5534-4a5b-b35e-e47d2d52c492" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2FDewmuDI2WmWLdV9tGl16%2FScreenshot%202025-11-05%20at%209.35.00%E2%80%AFPM.png?alt=media&#x26;token=92272e75-c515-4014-ba18-df9884b90a8d" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2FUYJXkvfkezfY6GpC5tYC%2Fprint.png?alt=media&#x26;token=b7d54fd8-a1e5-4897-a0a1-89484e03317a" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="https://3851254477-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhyyiUSThpFdlliNmso0W%2Fuploads%2FPZGb4tvK1G5dyfFTZAEp%2Fmargins.png?alt=media&#x26;token=6a0e1821-c2d0-4795-9ba7-4ebf47556ad4" alt=""><figcaption></figcaption></figure>

That's it!
