Peelstack Label Maker docs
All Peelstack Label Maker docs

Label sheets6 min read9 sections

Print Avery® L7167 labels from Google Sheets™

1 label 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 a PDF sized to the published layout.

Get the add-on for Google Sheets™

Labels per sheet1 (one label fills the sheet)
Label size199.6 mm (7.858 in) wide, 289 mm (11.378 in) tall
ShapeRectangle, rounded corners (3 mm)
PaperA4, 210 x 297 mm
Top margin4 mm (0.157 in)
Left margin5.2 mm (0.205 in)
Right margin5.2 mm (0.205 in)
Bottom margin3.9 mm (0.154 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, www.averyproducts.com.au).

How many Avery L7167 sheets do I need?

A A4 sheet of Avery L7167 holds 1 label, which fills the whole sheet. 100 labels need 100 sheets. A partly used sheet is fine: in the preview, click the first empty label and printing starts there. For your own list, see how many sheets you need.

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, measure it and enter the offset, or let the add-on calculate it. To check your printer before you use any labels, print the printer calibration page.

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.

Our Word template for Avery L7167 (.docx)

Download the Avery L7167 Word template: a blank A4 page with the label layout of Avery® L7167, 1 label as cells at the published positions, no borders. It is our own file made from the layout numbers on this page, not the manufacturer's file. The cells are rectangles, also where the label itself has rounded corners or is round.

  1. Open it in Microsoft Word, or in Google Docs™: in Google Drive™ choose New, File upload, then open the file with Google Docs™.
  2. If you see no cell outlines in Word, click in the table and choose View Gridlines on the Layout or Table Layout tab. Google Docs™ shows no lines; if you give the table a light border to see the cells, set the border to 0 pt before you print.
  3. Click into a label before you type. The narrow cells between labels are only spacing, so paste one label at a time, not a whole range. Keep the text short enough for the label. Word cuts off what does not fit; Google Docs™ makes the cell taller, which moves the labels below it down, so check the page count.
  4. Print at 100% on A4 paper. In Word for Windows, choose File, Options, Advanced and turn off "Scale content for A4 or 8.5 x 11 paper sizes" (in the Print group). On the Print screen, under Settings, choose Scale to Paper Size, then No Scaling. If Word warns that a margin is outside the printable area, choose Ignore, or Yes to continue; text in the outer few millimetres of the paper may not print.
  5. Print one page on plain paper first and hold it over a label sheet against a window. Label sheets are cut to a tolerance, so a label can sit a little off the published position.
  6. The add-on's printer offset and stretch correction do not apply to this file, and this sheet has no spare margin to move it with. To use them, make the PDF with the add-on instead.

Word also has many label codes built in: on the Mailings tab choose Labels, then Options, and pick your label vendor and product number. Our Word template is an alternative when you want a ready made page for your label code in one download, with one cell for each label and no borders.

Avery is a trademark of Avery Products Corporation or its affiliates. Microsoft and Word are trademarks of the Microsoft group of companies. Not affiliated with or endorsed by Avery or Microsoft.

If the labels do not line up

Every label off by the same amount (all a little high, low or to one side): in the add-on, open "Labels print a little off? Align your printer", print the test page on plain paper, measure with a ruler and enter the offset, or let the add-on calculate it. The add-on remembers it for A4 paper.

Further off on each row down the page: the page is being resized, and an offset cannot fix that. Measure the 100 mm bar on the test page; if it is shorter or longer, set the paper size to A4 and the scale to Actual size (100%) in the print dialog and in the printer settings. More in how to fix misaligned labels.

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 the same features as the paid plans, for up to 30 labels per run: one full sheet of 1 label fits in one free run. $29 for one year or $59 once removes the 30 label limit (one-time payments, nothing renews).

Other codes for this layout

Avery J8167, Avery LR7167, Avery 959014, Avery 959009, Avery 952005, Avery 952007, Avery 959400, Label Planet LP1/199, HERMA 4252, HERMA 10736, OnlineLabels EU30002

Similar sheets

All supported label sheets · How many labels per sheet

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.

English