Head back to the spreadsheet you made in step one, which you’ll use to create labels from Google Sheets.Ĭlick “Extensions” > “Create & Print Labels – Label maker for Avery & Co” > “Create labels.”Ī panel on the right side of your Google spreadsheet should appear near the top. Alternatively, open this link in a Chrome browser to head straight to the Labelmaker add-on page.

Continue until the add-on is successfully installed. You should get a few confirmation prompts.

Select the option labeled “Create & Print Labels – Label maker for Avery & Co.”.

Type “labelmaker” into the search bar and hit “Enter.”.

Head to “Extensions” > “Add-ons” > “Get add-ons” in your Google Sheets or Google Docs.

It includes a free 7-day trial before requiring a purchase. Labelmaker is a plugin that allows you to generate and print labels from either Google Docs or Google Sheets.

To give you an idea of what you’re spreadsheet should look like, we’ve prepared a spreadsheet using the sample data below: Make sure you reserve the first row for your headers for basic information like name, address, state, and phone number. This will be your primary source of information when printing labels from Google Sheets. If you haven’t done so yet, input all the necessary data of the people you’ll be shipping things to onto a spreadsheet.

Does Google Sheets Have a Label Template?.

How Do I Print Avery Labels in Google Sheets?.

Can You Print Labels From Google Sheets?.

Install The Labelmaker Plugin In Your Google Chrome Browser.

Set Up Your Mailing Data On a Google Sheet.

How to create address labels in numbers