How to print Avery® L7163 labels in LibreOffice Writer
In LibreOffice Writer choose File › New › Labels and pick L7163 under Avery A4, or enter it on the Format tab: pitch 101.6 mm × 38.1 mm, label 99.1 mm × 38.1 mm, 2 columns, 7 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 16.8 pt.
Print at 100% / Actual size, not “Fit to page”. Paper: A4 (210 × 297 mm).
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 L7163 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 L7163.
-
Pick the L7163 template
On the Labels tab, choose the Brand “Avery A4” and look for L7163 in Type. Brand and type lists vary by version; if L7163 is missing, use the next step.
-
Or enter L7163 by hand
On the Format tab enter the L7163 values: Horizontal pitch 101.6 mm, Vertical pitch 38.1 mm, Width 99.1 mm, Height 38.1 mm, Left margin 4.7 mm, Top margin 15.2 mm, Columns 2, Rows 7, Page width 210 mm, Page height 297 mm; 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 L7163 label, then click Synchronize Labels to copy it to all 14.
-
Merge a spreadsheet
For one L7163 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 L7163 at 100 %
File › Print: paper A4, no “fit to page” scaling; a plain-paper test should show 7 rows of L7163 labels 38.1 mm apart.
Worked example: 49 labels on L7163
A merge of 49 rows prints 4 pages of 14 Avery L7163 labels; the last page uses 7 positions and 7 stay blank. Preview the first page before sending all 4 to the printer.
In the LabelGrid designer the same 49 rows go into merge mode; the free version prints the first 14 (one full L7163 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 L7163
| Horizontal / vertical pitch | 101.6 mm / 38.1 mm |
|---|---|
| Width / height | 99.1 mm / 38.1 mm |
| Left / top margin | 4.7 mm / 15.2 mm |
| Columns / rows | 2 / 7 |
| Page width / height | 210 mm / 297 mm |
When L7163 labels print out of line in LibreOffice Writer
- L7163 labels print on the wrong paper size: check Format › Page Style matches A4; LibreOffice may default to your locale's paper.
- Only the first L7163 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 L7163 row: many printers leave about 1/4″ (6 mm) unprinted, and L7163 has 15.2 mm at the top and 15.2 mm at the bottom, so keep LibreOffice Writer text 1.8 mm inside each label.
About the Avery L7163 sheet
Avery® L7163 (mailing labels) has 14 labels of 99.1 × 38.1 mm per A4 sheet. The same layout is sold under other Avery codes too (J8163), so these settings work for them as well.
Avery® L7163 is named only to identify compatible sheets; LabelGrid is not affiliated with Avery.
More for Avery L7163
Avery L7163 in other apps
Templates and sizes
Frequently asked questions
Does LibreOffice have Avery L7163?
LibreOffice's label database includes many Avery codes under “Avery A4”; if L7163 is missing in your version, the Format tab values above recreate it.
What are the measurements of Avery L7163?
14 labels of 99.1 mm × 38.1 mm on A4, 2 across and 7 down. On LibreOffice's Format tab: pitch 101.6 mm × 38.1 mm, margins 4.7 mm left and 15.2 mm top.
Why do my L7163 labels from LibreOffice Writer drift down the page?
Either the Vertical pitch is not 38.1 mm or the print dialog scaled the page; at 97 % the last row moves about 8.5 mm. Print at 100 %.
Can I skip LibreOffice Writer entirely?
Yes. The LabelGrid designer at the top of this page is set to Avery L7163: type one label or paste a list and download a PDF aligned to all 14 positions, free and in your browser.