Create Avery 5161 compatible address labels from Excel, CSV, pasted rows, or Google Sheets. 20 labels per US Letter sheet, 4 in x 1 in.
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


Import Excel, CSV, pasted rows, or a shared Google Sheet, then export a print-ready PDF using the Avery 5161 / 20 per US Letter layout.
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
Add data fields
10Click an imported column, add fixed text, upload an image, or paste text/image from the clipboard.
Barcode label workflow
3 rows ready. Quantity expands into 6 printable labels.
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 Avery codes Other package numbers sharing this imported geometry | Avery 5261, Avery 5961, Avery 8161, Avery 8461, Avery 18161 |
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.
Avery 5161 shares this physical layout with Avery 5261, Avery 5961, Avery 8161, Avery 8461, Avery 18161. Use the same PDF layout when your sheet package lists one of those numbers.
Uses the same 2 columns x 10 rows, 4 in x 1 in geometry as Avery 5161.
Uses the same 2 columns x 10 rows, 4 in x 1 in geometry as Avery 5161.
Uses the same 2 columns x 10 rows, 4 in x 1 in geometry as Avery 5161.
Uses the same 2 columns x 10 rows, 4 in x 1 in geometry as Avery 5161.
Uses the same 2 columns x 10 rows, 4 in x 1 in geometry as Avery 5161.
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.
Use this template when each spreadsheet row should become one or more 4 in x 1 in labels.
Map SKU, UPC, asset ID, or serial number columns to barcode fields and export a sheet PDF.
Turn URLs, asset links, or location records into QR labels that can be printed in bulk.
Paste CSV rows or upload a file when you need a quick batch without setting up Word mail merge.
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.
If you couldn't find the answer you're looking for, please feel free to ask us!
Import your spreadsheet rows, preview the Avery 5161 / 20 per US Letter sheet, and export a print-ready PDF.