1 label per A4 sheet, 210 x 297 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 sheet | 1 (one label fills the sheet) |
|---|---|
| Label size | 210 mm (8.268 in) wide, 297 mm (11.693 in) tall |
| Shape | Rectangle |
| Paper | A4, 210 x 297 mm |
| Top margin | 0 mm (0 in) |
| Left margin | 0 mm (0 in) |
| Right margin | 0 mm (0 in) |
| Bottom margin | 0 mm (0 in) |
| Gap between columns | 0 mm (0 in) |
| Gap between rows | 0 mm (0 in) |
| Same layout | Sigel LA181, Sigel LA182, Tower W106, Label Planet LP1/210, HERMA 4428, HERMA 4631, Avery Zweckform L7567, Avery Zweckform J8567, Avery Zweckform L4775, Avery Zweckform L6013, Avery Zweckform 6603, OnlineLabels EU30001, A-One 72201, A-One 28409, A-One 28381 |
Checked against the manufacturer's template file (www.avery-zweckform.com).
How many Avery Zweckform 3478 sheets do I need?
A A4 sheet of Avery Zweckform 3478 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 Zweckform 3478 labels from Google Sheets™
- Open your list in Google Sheets™, then Extensions, Peelstack Label Maker, Create labels.
- Type 3478 and pick it. Check the lines the add-on suggests from your column names.
- Look at the preview with your own data, then Download PDF and print it at Actual size (100%) on A4 paper.
Print settings for this sheet
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 3478 test page (PDF)
Download the Avery Zweckform 3478 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 3478 (.docx)
Download the Avery Zweckform 3478 Word template: a blank A4 page with the label layout of Avery® Zweckform 3478, 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.
- Open it in Microsoft Word, or in Google Docs™: in Google Drive™ choose New, File upload, then open the file with Google Docs™.
- 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.
- 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.
- 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.
- 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.
- 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 3478 the same as Sigel LA181?
Yes. Avery Zweckform 3478, Sigel LA181, Sigel LA182, Tower W106, Label Planet LP1/210, HERMA 4428, HERMA 4631, Avery Zweckform L7567, Avery Zweckform J8567, Avery Zweckform L4775, Avery Zweckform L6013, Avery Zweckform 6603, OnlineLabels EU30001, A-One 72201, A-One 28409, A-One 28381 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 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
Sigel LA181, Sigel LA182, Tower W106, Label Planet LP1/210, HERMA 4428, HERMA 4631, Avery Zweckform L7567, Avery Zweckform J8567, Avery Zweckform L4775, Avery Zweckform L6013, Avery Zweckform 6603, OnlineLabels EU30001, A-One 72201, A-One 28409, A-One 28381
Similar sheets
- Avery L7167: 1 per sheet
- Avery L7168: 2 per sheet
- Avery L7169: 4 per sheet
- Avery L7166: 6 per sheet
- Avery L7165: 8 per sheet
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.