Avery 7162 Template for Excel, CSV, Google Sheets and PDF
Create Avery 7162 compatible address labels from Excel, CSV, pasted rows, or Google Sheets. 16 labels per A4 sheet, 99.09 mm x 33.9 mm.
This page uses Avery dimensions from the open glabels template data and generates a browser-side PDF layout for address labels.
Built for spreadsheet-to-label workflows
Generate Avery 7162 compatible labels from spreadsheet rows
Import Excel, CSV, pasted rows, or a shared Google Sheet, then export a print-ready PDF using the Avery 7162 / 16 per A4 layout.
Import and edit data
3 rows ready. Quantity expands into 6 printable labels.
| Actions | Name | Barcode | Asset ID | Serial | Location | Qty | Price |
|---|---|---|---|---|---|---|---|
1. Wireless Mouse
SKU-1001 · Aisle A / Bin 04
2. USB-C Dock
SKU-1002 · Aisle B / Bin 11
3. Barcode Scanner
SKU-1003 · Receiving Desk
Preview and export
Add data fields
10Click an imported column, add fixed text, upload an image, or paste text/image from the clipboard.
Label sheet
Barcode label workflow
3 rows ready. Quantity expands into 6 printable labels.
Label sheet
Avery 7162 Template Specifications
Key print geometry parsed from glabels for Avery 7162. These values drive the PDF generator above.
| Comparison criteria | Avery 7162 Printable layout values |
|---|---|
Paper Sheet size used by this template | A4, 8.268 in x 11.693 in / 210 mm x 297 mm |
Label shape Physical label form | Rectangle |
Label size Width x height, shown in inches and millimeters | 3.901 in x 1.335 in / 99.09 mm x 33.9 mm |
Layout Columns x rows | 2 columns x 8 rows |
Labels per sheet Total printable labels on one page | 16 |
First label origin Top and left start position from the sheet edge | 0.511 in / 12.98 mm top, 0.157 in / 3.99 mm left |
Right and bottom margins Calculated remaining edge margin after the grid | 0.175 in / 4.44 mm right, 0.504 in / 12.8 mm bottom |
Pitch Distance from one label start to the next label start | 4.035 in / 102.48 mm horizontal, 1.335 in / 33.9 mm vertical |
Gap between labels Open space between neighboring labels | 0.133 in / 3.39 mm horizontal, 0 in / 0 mm vertical |
Corner radius Rounded-corner value from the source template data | 0.069 in / 1.76 mm |
Inner label margin Recommended internal content margin from the source data | 0.069 in / 1.76 mm |
Compatible Avery codes Other package numbers sharing this imported geometry | Avery L7162 |
Official Avery template Avery page for stock verification and official downloads | |
Template data source Public geometry source used for this PDF layout | glabels |
Avery is a trademark of its owner. SheetstoLabels is not affiliated with or endorsed by Avery; this page creates an Avery-compatible layout from public template geometry.
Compatible Avery Templates for Avery 7162
Avery 7162 shares this physical layout with Avery L7162. Use the same PDF layout when your sheet package lists one of those numbers.
Print Avery 7162 Labels Without Alignment Drift
Use these settings before printing Avery 7162 PDFs on A4.
Disable browser or PDF viewer scaling. Use 100% / Actual size so the template keeps the exact margins and pitch.
Best Uses for Avery 7162 Compatible Labels
Use this template when each spreadsheet row should become one or more 99.09 mm x 33.9 mm labels.
Barcode labels from Excel
Map SKU, UPC, asset ID, or serial number columns to barcode fields and export a sheet PDF.
QR code labels from Google Sheets
Turn URLs, asset links, or location records into QR labels that can be printed in bulk.
CSV label batches
Paste CSV rows or upload a file when you need a quick batch without setting up Word mail merge.
Avery 7162 Template FAQ
Common questions about printing Avery 7162 compatible labels from spreadsheets, using common Avery Help Center and search-result topics: template downloads, Excel import, print scaling, alignment, compatible stock, and bleed/safe area.
Still have questions?
If you couldn't find the answer you're looking for, please feel free to ask us!
Create Avery 7162 Compatible Labels
Import your spreadsheet rows, preview the Avery 7162 / 16 per A4 sheet, and export a print-ready PDF.