How to print your own labels in Google Docs™ and Sheets™

Launch the 'Label Sheets & Rolls' Add-on

You can install and launch this add-on either through the Google Workspace Marketplace or directly from our website, on the Google Docs & Sheets label template page you are printing from - for example: Avery-5160.

Choose a standard label sheet template

When you launch the add-on from the template pages on our site, the template brand and code will be automatically preselected for you. Otherwise, simply choose the page format (either Letter or A4), select the template brand, and the template code.

Manage printout alignment

To ensure flawless printout results, the add-on provides the following print settings:

• Apply a vertical offset to correct centering issues caused by your printer.
• Add a bleeding area to ensure designs extend to the edge of each label.
• Change the page orientation to either portrait or landscape.
• Set the number of labels to print per page. If the number of document pages (label designs) exceeds the number of labels on a single sheet, the add-on will automatically generate multi-page printouts.

Create your own custom label sheet template

If you need to create your own label template layout or labels of a custom size, select the Custom option. This is ideal for users who have purchased generic label sheets or are cutting their own labels from plain adhesive sheets.

Manage printout alignment

To ensure accurate label alignment on the printed sheet, the add-on offers the following print adjustment settings:

• Apply a vertical offset to correct centering issues caused by your printer.
• Add a bleeding area to ensure designs extend to the edge of each label.
• Appy a cutting marker that helps cutting custom-size labels.
• Specify the number of labels to be printed on each sheet.

Define your Roll label for any label and printer brand

If you need to print on roll labels, this add-on lets you print on any label brand and printer. You just need to enter the following information:

• Label Width
  The width of a single label.
• Label Height
  The height of a single label.
• Carrier Width
  The specifications of the roll should include the width of the carrier of labels, which is usually slightly larger than the width of the label, to allow for margin space on both sides.
• Gap
  Labels on a roll are usually spaced slightly apart from each other. The specifications of your label roll should list this as the Gap dimension.
• Orientation
  If you want your label images to be inserted vertically (i.e., rotated -90 degrees) into each label, there's no need to design the rotated. Simply set this field to "Landscape", and the system will automatically rotate the images and generate the printout file accordingly.
• Bleed area
  When your label background isn't white, slight misalignments during printing can cause a thin white edge to appear along one or more sides. A simple and effective way to avoid this is to print the label image slightly larger than the label area, so the background extends beyond the label's actual edge. This method is called applying a bleed. If you notice white edges, select a bleed area between 1% and 5%, depending on how much coverage you need.
• Quantity
  The number of labels you want to print.

Design

This add-on can be used from either Google Docs™ or Google Sheets™. Most choose Google Docs™ because it allows them to design labels directly on a Docs page, offering full flexibility over the content, while still supporting the import of text data from a spreadsheet.

After launching the add-on in Google Docs™ and selecting your template brand and code, or defining your own label sheet or roll template, the add-on will automatically create a document where the page width and height ratio matches that of a single label. This means you simply design one label, and the add-on takes care of generating the full printout for the entire sheet or roll. If you have multiple label designs, you simply add additional pages to the same Google document - one design per page.

Mail merge

Google Docs™

The Google Docs™ add-on makes it easy to generate hundreds of labels with the same design but different text pulled from a spreadsheet, such as when printing name tags or address labels. The beauty is that you still work on a single page: simply indicate where the data from each spreadsheet column should appear, and the add-on will automatically generate and arrange hundreds of labels for printing.

Google Sheets™

The Google Sheets™ add-on is better suited for quickly generating simple labels by merging data from the current Google Sheets file, though the label design options are very basic.

After launching the add-on and selecting the template brand and code, or defining a custom label sheet or roll, the add-on opens a window with a text area scaled to match a single label. In this area, you can insert static content and placeholders mapped to columns from the current Google Sheets file. The add-on then automatically generates the complete set of labels by merging spreadsheet data into these placeholders, producing a fully formatted, print-ready PDF layout.

Send to your printer

With one click, our add-on generates and displays the printout pages. You can then send them directly to your printer or save them as a PDF for future use.

Using another tool to design your labels?

We meet you where you are. Learn more about how you can use our service from Canva, Adobe Express, or even directly from your browser.