This tutorial shows you how to create and print labels for a mailing list in Google Sheets, using Labelmaker. While our Google Sheets add-on provides powerful formatting features (bold, italic, alignments and more), if you are looking for more options, have a look at our guide on printing and formatting labels in Google docs. There are also many others guides and tutorials here depending on your use case.
Here is a summary of this tutorial:
Open your spreadsheet containing the mailing list data you want to use. If you don't have one yet, create a new spreadsheet and add data in it. The first row shall contain the headers (e.g. address, city, zipcode, state).
In Google Sheets, click on the "Extensions" menu (previously named "Add-ons"), then select "Create & Print Labels". If you don't have the add-on yet, make sure to install it first. After the installation, reload your spreadsheet by closing it and reopening it.
Within Labelmaker sidebar, click on "Select a template", then look at the available templates in the list. Over 5000+ labels are available as of writing, within multiple categories including "Avery US Letter", "Avery A4", "Avery Zweckform", "Sheetlabels.com", "OnlineLabels.com" and "Herma".
In the content field, add merge fields using double-arrows. For example add the address with <<address>> and the city with <<city>>. Once done apply some formatting such as bold, italic or aligned in the middle.
Click on "Create labels" to create all your labels in a new document. Each row in your spreadsheet is converted to a new label with the appropriate merge fields. This let you create a mailing list with hundreds of contacts in a few seconds.
Open the newly created document and make sure the mailing list is correct. If you need to make some adjustement, go back to the spreadsheet and make your changes in Labelmaker. Again, click on "Create labels" when you are ready and a new document will be created.
Now that your mailing list look well, in Google Docs, click on "File" > "Print". In the print dialogue, make sure to set the margin to none and the scale to 100%. Depending on the format of the labels product, you might need to adapt the size of the page. For example, Avery US Letter 5160 requires the size to be "Letter".
The printer is now hard at work!
In case your labels are not lining up or not printing properly, read our guide on How to Fix Misaligned Labels Templates?
Still having troubles? Ask for help on our Google Forum. Make sure to share a screenshot of the issue you’re having with your labels and include useful information such as the label template you are using.
Print quality labels in a couple of clicks right from Google Docs.
We offer a 30-days money-back guarantee on all our products.
Get help from our community of experts on the online forum.