How to print Avery® 5164 labels in LibreOffice Writer
In LibreOffice Writer choose File › New › Labels and pick 5164 under Avery Letter Size, or enter it on the Format tab: pitch 4.188 in × 3.333 in, label 4 in × 3.333 in, 2 columns, 3 rows. Or use the designer below.
Updated · measurements from the gLabels template database
Loading the sheet list…
In Excel, Google Sheets or Numbers: select the cells with the header row, copy, and paste here. The sample rows are replaced.
Text auto-fits at 26.3 pt.
Print at 100% / Actual size, not “Fit to page”. Paper: US Letter (8.5 × 11 in).
Free prints one full sheet.
Font, style, colours, start position and printer offset
Print the alignment test sheet on plain paper, hold it over a label sheet, and nudge: positive moves everything right / down.
Pro, one payment, no subscription:
- Unlimited mail merge rows and sheets
- Open .xlsx files directly
- QR codes and Code 128 barcodes
- Serial numbering
- Your logo or image on every label
- Saved designs
- Saved printer calibration
- No credit line
Pro tools
Avery 5164 in LibreOffice Writer, step by step
-
Open the Labels dialog
In LibreOffice Writer, choose File › New › Labels; the dialog has Labels, Format and Options tabs, and all three matter for 5164.
-
Pick the 5164 template
On the Labels tab, choose the Brand “Avery Letter Size” and look for 5164 in Type. Brand and type lists vary by version; if 5164 is missing, use the next step.
-
Or enter 5164 by hand
On the Format tab enter the 5164 values: Horizontal pitch 4.188 in, Vertical pitch 3.333 in, Width 4 in, Height 3.333 in, Left margin 0.156 in, Top margin 0.5 in, Columns 2, Rows 3, Page width 8.5 in, Page height 11 in; save it for next time.
-
Edit once, copy to all
On the Options tab tick Synchronize contents and click New Document. Edit the top-left 5164 label, then click Synchronize Labels to copy it to all 6.
-
Merge a spreadsheet
For one 5164 label per row, pick your registered spreadsheet under Database and Table on the Labels tab and insert its fields; when you print, LibreOffice asks whether to print a form letter: answer Yes.
-
Print 5164 at 100 %
File › Print: paper US Letter, no “fit to page” scaling; a plain-paper test should show 3 rows of 5164 labels 3.333 in apart.
Worked example: 48 beer bottle labels on 5164
A merge of 48 rows prints 8 pages of 6 Avery 5164 labels. Preview the first page before sending all 8 to the printer.
In the LabelGrid designer the same 48 rows go into merge mode; the free version prints the first 6 (one full 5164 sheet) and Pro removes the limit. To reuse a part-used sheet, set the start position to the first empty label.
The LibreOffice Writer numbers for Avery 5164
| Horizontal / vertical pitch | 4.188 in / 3.333 in |
|---|---|
| Width / height | 4 in / 3.333 in |
| Left / top margin | 0.156 in / 0.5 in |
| Columns / rows | 2 / 3 |
| Page width / height | 8.5 in / 11 in |
When 5164 labels print out of line in LibreOffice Writer
- 5164 labels print on the wrong paper size: check Format › Page Style matches US Letter; LibreOffice may default to your locale's paper.
- Only the first 5164 label changed: Synchronize contents was off. Open the Options tab again, tick it, and click Synchronize Labels.
- Text cut off on the first or last 5164 row: many printers leave about 1/4″ (6 mm) unprinted, and 5164 has 0.5 in at the top and 0.5 in at the bottom, so keep LibreOffice Writer text 0.125 in inside each label.
About the Avery 5164 sheet
Avery® 5164 (shipping labels) has 6 labels of 3 1/3″ × 4″ per US Letter sheet. The same layout is sold under other Avery codes too (5264, 5514, 5524, 6464, 6499, 8164 and more), so these settings work for them as well.
Common jobs for 5164: Halloween party favor labels, Christmas gift tag labels, New Year labels, shipping labels and name badge labels. Avery® 5164 is named only to identify compatible sheets; LabelGrid is not affiliated with Avery.
More for Avery 5164
Avery 5164 in other apps
Templates and sizes
Frequently asked questions
Does LibreOffice have Avery 5164?
LibreOffice's label database includes many Avery codes under “Avery Letter Size”; if 5164 is missing in your version, the Format tab values above recreate it.
What are the measurements of Avery 5164?
6 labels of 4 in × 3.333 in on US Letter, 2 across and 3 down. On LibreOffice's Format tab: pitch 4.188 in × 3.333 in, margins 0.156 in left and 0.5 in top.
Why do my 5164 labels from LibreOffice Writer drift down the page?
Either the Vertical pitch is not 3.333 in or the print dialog scaled the page; at 97 % the last row moves about 0.315 in. Print at 100 %.
Can I skip LibreOffice Writer entirely?
Yes. The LabelGrid designer at the top of this page is set to Avery 5164: type one label or paste a list and download a PDF aligned to all 6 positions, free and in your browser.