Peelstack Label Maker docs

Print Avery® L7161 labels from Google Sheets

18 labels per A4 sheet, 63.5 x 46.6 mm. Good for product, jar and name labels. Print your list straight from Google Sheets as an exact PDF.

See how the add-on works

Labels per sheet18 (3 across, 6 down)
Label size63.5 mm (2.5 in) wide, 46.6 mm (1.833 in) tall
ShapeRectangle, rounded corners (3 mm)
PaperA4, 210 x 297 mm
Top margin8.9 mm (0.349 in)
Left margin7.2 mm (0.284 in)
Right margin7.2 mm (0.284 in)
Bottom margin8.8 mm (0.346 in)
Gap between columns2.5 mm (0.1 in)
Gap between rows0 mm (0 in)
Same layoutAvery J8161, Avery 959002, Avery 952001, Avery 936096, Label Planet LP18/63, HERMA 4265, HERMA 4501, OnlineLabels EU30014

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

How to print Avery L7161 labels from Google Sheets

  1. Open your list in Google Sheets, then Extensions, Peelstack Label Maker, Create labels.
  2. Type L7161 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 L7161 test page (PDF)

Download the Avery L7161 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 L7161 the same as Avery J8161?

Yes. Avery L7161, Avery J8161, Avery 959002, Avery 952001, Avery 936096, Label Planet LP18/63, HERMA 4265, HERMA 4501, OnlineLabels EU30014 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 18 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.