Peelstack Label Maker docs

Print Avery® L7169 labels from Google Sheets

4 labels per A4 sheet, 99.1 x 139 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 sheet4 (2 across, 2 down)
Label size99.1 mm (3.901 in) wide, 139 mm (5.472 in) tall
ShapeRectangle, rounded corners (3 mm)
PaperA4, 210 x 297 mm
Top margin9.5 mm (0.374 in)
Left margin4.7 mm (0.183 in)
Right margin4.6 mm (0.181 in)
Bottom margin9.5 mm (0.374 in)
Gap between columns2.6 mm (0.101 in)
Gap between rows0 mm (0 in)
Same layoutAvery J8169, Avery 959020, Avery 959030, Avery 936087, Avery 959402, Label Planet LP4/99, Avery Zweckform L7994, Avery Zweckform L4774, OnlineLabels EU30005, A-One 31069

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

How to print Avery L7169 labels from Google Sheets

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

Download the Avery L7169 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 L7169 the same as Avery J8169?

Yes. Avery L7169, Avery J8169, Avery 959020, Avery 959030, Avery 936087, Avery 959402, Label Planet LP4/99, Avery Zweckform L7994, Avery Zweckform L4774, OnlineLabels EU30005, A-One 31069 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 4 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.