Peelstack Label Maker docs
All Peelstack Label Maker docs

Label sheets6 min read10 sections

Print Avery® 18160 labels from Google Sheets™

30 labels per Letter sheet, 2 5/8 x 1 in. Good for address labels, return address labels, holiday and wedding mail. Print your list straight from Google Sheets™ as a PDF sized to the published layout.

Avery 18160 has the same layout as Avery 5160, so everything below applies.

Get the add-on for Google Sheets™

Labels per sheet30 (3 across, 10 down)
Label size2.63 in (66.8 mm) wide, 1 in (25.4 mm) tall
ShapeRectangle, rounded corners (2.5 mm)
PaperUS Letter, 8.5 x 11 in
Top margin0.5 in (12.7 mm)
Left margin0.187 in (4.8 mm)
Right margin0.183 in (4.6 mm)
Bottom margin0.5 in (12.7 mm)
Gap between columns0.12 in (3 mm)
Gap between rows0 in (0 mm)
Same layoutAvery 5160, Avery 5260, Avery 5520, Avery 5630, Avery 5660, Avery 5960, Avery 6240, Avery 6521, Avery 5136, Avery 8160, Avery 8460, Avery 8660, Avery 15660, Avery 18260, Avery 18660, SheetLabels SL100

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

How many Avery 18160 sheets do I need?

A Letter sheet of Avery 18160 holds 30 labels (3 across, 10 down), each 2 5/8 x 1 in. A list of 100 addresses needs 4 sheets, and the last one has 10 labels used. 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 18160 labels from Google Sheets™

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

Download the Avery 18160 test page (made for Avery 5160, which has the same layout): 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.

One page cheat sheet for Avery 18160 (PDF)

Download the Avery 5160 cheat sheet (it covers the layout of Avery 18160 too): the size, margins and three steps on one page, with the print settings checklist. Print it and keep it by the printer.

Our Word template for Avery 18160 (.docx)

Download the Avery 18160 Word template (made for Avery 5160, which has the same layout): a blank Letter page with the label layout of Avery® 18160, 30 labels 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 (about 6 lines of 9 pt text on this 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. To move the print, add the offset X to the left margin and the offset Y to the top margin (Layout, Margins, Custom Margins), and take the same amounts off the right and bottom margins so the table still fits.

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 18160 the same as Avery 5160?

Yes. Avery 5160, Avery 5260, Avery 5520, Avery 5630, Avery 5660, Avery 5960, Avery 6240, Avery 6521, Avery 5136, Avery 8160, Avery 8460, Avery 8660, Avery 15660, Avery 18160, Avery 18260, Avery 18660, SheetLabels SL100 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 30 labels 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 5160, Avery 5260, Avery 5520, Avery 5630, Avery 5660, Avery 5960, Avery 6240, Avery 6521, Avery 5136, Avery 8160, Avery 8460, Avery 8660, Avery 15660, Avery 18260, Avery 18660, SheetLabels SL100

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