Peelstack Label Maker docs

Print Avery® L7167 labels from Google Sheets

1 labels per A4 sheet, 199.6 x 289 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 sheet1 (1 across, 1 down)
Label size199.6 mm (7.858 in) wide, 289 mm (11.38 in) tall
ShapeRectangle, rounded corners (3 mm)
PaperA4, 210 x 297 mm
Top margin4 mm (0.158 in)
Left margin5.2 mm (0.205 in)
Right margin5.2 mm (0.205 in)
Bottom margin3.9 mm (0.155 in)
Gap between columns0 mm (0 in)
Gap between rows0 mm (0 in)
Same layoutAvery J8167, Avery LR7167, Avery 959014, Avery 959009, Avery 952005, Avery 952007, Avery 959400, Label Planet LP1/199, HERMA 4252, HERMA 10736, OnlineLabels EU30002

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

How to print Avery L7167 labels from Google Sheets

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

Download the Avery L7167 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 L7167 the same as Avery J8167?

Yes. Avery L7167, Avery J8167, Avery LR7167, Avery 959014, Avery 959009, Avery 952005, Avery 952007, Avery 959400, Label Planet LP1/199, HERMA 4252, HERMA 10736, OnlineLabels EU30002 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 1 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.