Peelstack Label Maker docs

Print Avery® Zweckform 3422 labels from Google Sheets

24 labels per A4 sheet, 70 x 35 mm. Good for address labels, return address labels, holiday and wedding mail. Print your list straight from Google Sheets as an exact PDF.

See how the add-on works

Labels per sheet24 (3 across, 8 down)
Label size70 mm (2.756 in) wide, 35 mm (1.378 in) tall
ShapeRectangle
PaperA4, 210 x 297 mm
Top margin8.5 mm (0.336 in)
Left margin0 mm (0 in)
Right margin0 mm (0 in)
Bottom margin8.5 mm (0.333 in)
Gap between columns0 mm (0 in)
Gap between rows0 mm (0 in)
Same layoutHERMA 4429

Checked against the manufacturer's template file (www.avery-zweckform.com/vorlage-3422, www.avery-zweckform.com/sites/default/files/avery_importer/t).

How to print Avery Zweckform 3422 labels from Google Sheets

  1. Open your list in Google Sheets, then Extensions, Peelstack Label Maker, Create labels.
  2. Type 3422 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 and enter the offset it shows.

Free Avery Zweckform 3422 test page (PDF)

Download the Avery Zweckform 3422 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.

Questions

Is Avery Zweckform 3422 the same as HERMA 4429?

Yes. Avery Zweckform 3422, HERMA 4429 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 every feature, 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).

Similar sheets

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.