Avery® 5161® Template for Excel, CSV, Google Sheets and PDF
Create labels compatible with the Avery® 5161® layout from Excel, CSV, pasted rows, or Google Sheets. Features 20 labels per US Letter sheet, measuring 4 in x 1 in.
This page uses layout 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® 5161® compatible labels from spreadsheet rows
Import Excel, CSV, pasted rows, or a shared Google Sheet, then export a print-ready PDF using the Avery® 5161® Compatible / 20 per US Letter 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® 5161® Template Specifications
Key print geometry parsed from glabels for Avery® 5161®. These values drive the PDF generator above.
| Comparison criteria | Avery® 5161® Printable layout values |
|---|---|
Paper Sheet size used by this template | US Letter, 8.5 in x 11 in / 215.9 mm x 279.4 mm |
Label shape Physical label form | Rectangle |
Label size Width x height, shown in inches and millimeters | 4 in x 1 in / 101.6 mm x 25.4 mm |
Layout Columns x rows | 2 columns x 10 rows |
Labels per sheet Total printable labels on one page | 20 |
First label origin Top and left start position from the sheet edge | 0.5 in / 12.7 mm top, 0.156 in / 3.97 mm left |
Right and bottom margins Calculated remaining edge margin after the grid | 0.156 in / 3.97 mm right, 0.5 in / 12.7 mm bottom |
Pitch Distance from one label start to the next label start | 4.188 in / 106.36 mm horizontal, 1 in / 25.4 mm vertical |
Gap between labels Open space between neighboring labels | 0.188 in / 4.76 mm horizontal, 0 in / 0 mm vertical |
Corner radius Rounded-corner value from the source template data | 0.063 in / 1.59 mm |
Inner label margin Recommended internal content margin from the source data | 0.063 in / 1.59 mm |
Compatible codes Other package numbers sharing this geometry | 5261®, 5961®, 8161®, 8461®, 18161® |
Official template Official page for stock verification and downloads | |
Template data source Public geometry source used for this PDF layout | glabels |
Avery® is a registered trademark of its owner. SheetsToLabels is independent and not affiliated with, endorsed by, or sponsored by Avery Products Corporation. This page is designed to print templates compatible with the layout of these stock numbers.
Compatible Layouts for Avery® 5161®
This layout shares its physical dimensions with compatible codes 5261®, 5961®, 8161®, 8461®, 18161®. Use the same PDF layout when your package lists one of those numbers.
Compatible 5261® Layout
Uses the same 2 columns x 10 rows, 4 in x 1 in geometry as Avery® 5161®.
Compatible 5961® Layout
Uses the same 2 columns x 10 rows, 4 in x 1 in geometry as Avery® 5161®.
Compatible 8161® Layout
Uses the same 2 columns x 10 rows, 4 in x 1 in geometry as Avery® 5161®.
Compatible 8461® Layout
Uses the same 2 columns x 10 rows, 4 in x 1 in geometry as Avery® 5161®.
Compatible 18161® Layout
Uses the same 2 columns x 10 rows, 4 in x 1 in geometry as Avery® 5161®.
Print Avery® 5161® compatible labels without alignment drift
Use these settings before printing Avery® 5161® PDFs on US Letter.
Disable browser or PDF viewer scaling. Use 100% / Actual size so the template keeps the exact margins and pitch.
Best Uses for Avery® 5161® compatible labels
Use this template when each spreadsheet row should become one or more 4 in x 1 in 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® 5161® Template FAQ
Common questions about printing Avery® 5161® 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® 5161® Compatible Labels
Import your spreadsheet rows, preview the Avery® 5161® Compatible / 20 per US Letter sheet, and export a print-ready PDF.