Peelstack Label Maker docs

Label sheets6 min read9 sections

Print Avery® 5165 labels from Google Sheets™

1 label per Letter sheet, 8 1/2 x 11 in. 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 size8.5 in (215.9 mm) wide, 11 in (279.4 mm) tall
ShapeRectangle
PaperUS Letter, 8.5 x 11 in
Top margin0 in (0 mm)
Left margin0 in (0 mm)
Right margin0 in (0 mm)
Bottom margin0 in (0 mm)
Gap between columns0 in (0 mm)
Gap between rows0 in (0 mm)
Same layoutAvery 8165, Uline S-5045, Staples 490429, Staples 70972, SheetLabels SL111VS, WorldLabel WL-175, WorldLabel WL-175WX, Label Outfitters 850110-H, Label Outfitters 850110-V, Maco MML-0100, OnlineLabels OL175

Checked against the manufacturer's template file (www.avery.com, s3.amazonaws.com).

How many Avery 5165 sheets do I need?

A Letter sheet of Avery 5165 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 5165 labels from Google Sheets™

  1. Open your list in Google Sheets™, then Extensions, Peelstack Label Maker, Create labels.
  2. Type 5165 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 Letter paper.

Paper size Letter; 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 5165 test page (PDF)

Download the Avery 5165 test page: the outline of every label at the published position, the distances to the paper edge and a 4 inch 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 5165 (.docx)

Download the Avery 5165 Word template: a blank Letter page with the label layout of Avery® 5165, 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. On this sheet the last row of cells is 1.5 mm shorter than the label, so the file fits one page in Word.

  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 Letter 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 Letter paper.

Further off on each row down the page: the page is being resized, and an offset cannot fix that. Measure the 4 inch bar on the test page; if it is shorter or longer, set the paper size to Letter 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 5165 the same as Avery 8165?

Yes. Avery 5165, Avery 8165, Uline S-5045, Staples 490429, Staples 70972, SheetLabels SL111VS, WorldLabel WL-175, WorldLabel WL-175WX, Label Outfitters 850110-H, Label Outfitters 850110-V, Maco MML-0100, OnlineLabels OL175 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 Letter 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 8165, Uline S-5045, Staples 490429, Staples 70972, SheetLabels SL111VS, WorldLabel WL-175, WorldLabel WL-175WX, Label Outfitters 850110-H, Label Outfitters 850110-V, Maco MML-0100, OnlineLabels OL175

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