Peelstack Label Maker docs
All Peelstack Label Maker docs

Label sheets6 min read9 sections

Print Avery® L7163 labels from Google Sheets™

14 labels per A4 sheet, 99.1 x 38.1 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 sheet14 (2 across, 7 down)
Label size99.1 mm (3.902 in) wide, 38.1 mm (1.5 in) tall
ShapeRectangle, rounded corners (3 mm)
PaperA4, 210 x 297 mm
Top margin15.2 mm (0.598 in)
Left margin4.7 mm (0.185 in)
Right margin4.7 mm (0.185 in)
Bottom margin15.1 mm (0.594 in)
Gap between columns2.5 mm (0.098 in)
Gap between rows0 mm (0 in)
Same layoutAvery J8163, Avery LR7163, Avery MP7163, Avery Zweckform L7163, Avery 959004, Avery 952003, Avery 936094, Avery 959108, Avery 959417, Avery 959046, Avery 959089, Avery 959304, Avery 936078, Label Planet LP14/99, HERMA 4678, HERMA 5076, HERMA 8635, HERMA 8671, Avery Zweckform L7563, Avery Zweckform J8563

Checked against the manufacturer's template file (www.avery.co.uk, www.avery-zweckform.com, www.averyproducts.com.au).

How many Avery L7163 sheets do I need?

A A4 sheet of Avery L7163 holds 14 labels (2 across, 7 down), each 99.1 x 38.1 mm. A list of 100 addresses needs 8 sheets, and the last one has 2 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 L7163 labels from Google Sheets™

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

Download the Avery L7163 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 L7163 (.docx)

Download the Avery L7163 Word template: a blank A4 page with the label layout of Avery® L7163, 14 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 10 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 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. 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 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 L7163 the same as Avery J8163?

Yes. Avery L7163, Avery J8163, Avery LR7163, Avery MP7163, Avery Zweckform L7163, Avery 959004, Avery 952003, Avery 936094, Avery 959108, Avery 959417, Avery 959046, Avery 959089, Avery 959304, Avery 936078, Label Planet LP14/99, HERMA 4678, HERMA 5076, HERMA 8635, HERMA 8671, Avery Zweckform L7563, Avery Zweckform J8563 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 14 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 J8163, Avery LR7163, Avery MP7163, Avery Zweckform L7163, Avery 959004, Avery 952003, Avery 936094, Avery 959108, Avery 959417, Avery 959046, Avery 959089, Avery 959304, Avery 936078, Label Planet LP14/99, HERMA 4678, HERMA 5076, HERMA 8635, HERMA 8671, Avery Zweckform L7563, Avery Zweckform J8563

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