Peelstack Label Maker docs

Print Avery® L7162 labels from Google Sheets

16 labels per A4 sheet, 99.1 x 33.9 mm. Good for shipping labels, box and file labels, product labels. Print your list straight from Google Sheets as an exact PDF.

See how the add-on works

Labels per sheet16 (2 across, 8 down)
Label size99.1 mm (3.9 in) wide, 33.9 mm (1.333 in) tall
ShapeRectangle, rounded corners (3 mm)
PaperA4, 210 x 297 mm
Top margin13.1 mm (0.514 in)
Left margin4.7 mm (0.184 in)
Right margin4.7 mm (0.184 in)
Bottom margin13 mm (0.512 in)
Gap between columns2.5 mm (0.1 in)
Gap between rows0 mm (0 in)
Same layoutAvery J8162, Avery LR7162, Avery 959003, Avery 952002, Avery 936098, Avery 959112, Avery 959048, Avery 936079, Tower W121, Label Planet LP16/99, HERMA 4267, HERMA 5075, Avery Zweckform L7562, OnlineLabels EU30013

Checked against the manufacturer's template file (www.avery.co.uk/template-l7162, www.avery.co.uk/sites/avery.co.uk/files/avery_importer/templ, www.avery.co.uk/template-j8162, www.avery.co.uk/sites/avery.co.uk/files/avery_importer/templ, www.averyproducts.com.au/word-template-l7162, www.averyproducts.com.au/sites/avery.au/files/avery_importer).

How to print Avery L7162 labels from Google Sheets

  1. Open your list in Google Sheets, then Extensions, Peelstack Label Maker, Create labels.
  2. Type L7162 and pick it. Check the lines the add-on suggests from your column names.
  3. Look at the preview with your own data, then Download PDF and print it at Actual size (100%) on A4 paper.

Paper size A4; scale Actual size or 100%; no Fit to page or Fit to printable area; one sided; borderless off. If every label is off by the same small amount, print the add-on's test page on plain paper and enter the offset it shows.

Free Avery L7162 test page (PDF)

Download the Avery L7162 test page: the outline of every label at the published position, the distances to the paper edge and a 100 mm bar to check that nothing was resized. Print it on plain paper at Actual size and hold it over a label sheet against a window.

Questions

Is Avery L7162 the same as Avery J8162?

Yes. Avery L7162, Avery J8162, Avery LR7162, Avery 959003, Avery 952002, Avery 936098, Avery 959112, Avery 959048, Avery 936079, Tower W121, Label Planet LP16/99, HERMA 4267, HERMA 5075, Avery Zweckform L7562, OnlineLabels EU30013 share one layout, so the same template prints on all of them.

Can I do this in Google Docs?

Yes. The add-on also opens in Google Docs, where you paste your list or use the same text on every label. From Google Sheets it reads your rows directly.

Why do my labels drift down the page?

The page is being resized. Print at Actual size (100%), turn off Fit to page or Fit to printable area, and set the paper size to A4 in the print dialog and in your printer settings.

Can I print on a partly used sheet?

Yes. In the preview, click the first empty label; printing starts there.

Is it free?

Yes, with every feature, for up to 30 labels per run: one full sheet of 16 labels fits in one free run. $29 for one year or $59 once removes the 30 label limit (one-time payments, nothing renews).

Similar sheets

Avery® and Zweckform are trademarks of Avery Products Corporation or its affiliates. Taskivator is not affiliated with Avery; product codes are used only to describe compatible layouts.