Peelstack Label Maker docs
All Peelstack Label Maker docs

Label sheets6 min read9 sections

Print Avery® Zweckform 3474 labels from Google Sheets™

24 labels per A4 sheet, 70 x 37.1 mm. 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.

Get the add-on for Google Sheets™

Labels per sheet24 (3 across, 8 down)
Label size70 mm (2.756 in) wide, 37.1 mm (1.461 in) tall
ShapeRectangle
PaperA4, 210 x 297 mm
Top margin0 mm (0 in)
Left margin0 mm (0 in)
Right margin0 mm (0 in)
Bottom margin0 mm (0 in)
Gap between columns0 mm (0 in)
Gap between rows0 mm (0 in)
Same layoutLabel Planet LP24/70, HERMA 4615, HERMA 4464, HERMA 4685, Avery Zweckform 6605, OnlineLabels EU30047

Checked against the manufacturer's template file (www.avery-zweckform.com).

How many Avery Zweckform 3474 sheets do I need?

A A4 sheet of Avery Zweckform 3474 holds 24 labels (3 across, 8 down), each 70 x 37.1 mm. A list of 100 addresses needs 5 sheets, and the last one has 4 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 Zweckform 3474 labels from Google Sheets™

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

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

Download the Avery Zweckform 3474 Word template: a blank A4 page with the label layout of Avery® Zweckform 3474, 24 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. 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 (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, 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 Zweckform 3474 the same as Label Planet LP24/70?

Yes. Avery Zweckform 3474, Label Planet LP24/70, HERMA 4615, HERMA 4464, HERMA 4685, Avery Zweckform 6605, OnlineLabels EU30047 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 24 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

Label Planet LP24/70, HERMA 4615, HERMA 4464, HERMA 4685, Avery Zweckform 6605, OnlineLabels EU30047

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