SPREADSHEET PRINTING GUIDE
Avery 5163 Label Template from Excel or CSV
PrintPiper fills 5163-compatible sheets from Excel, CSV, or TSV data with the built-in Avery 5163 stock. Choose it under Preset and consecutive records fill both columns of every Letter sheet — 10 shipping labels per page, no manual grid setup.
Print setup: use US Letter paper and print at Actual size or 100%. Turn off Fit, Shrink, and other page scaling. Test on plain paper before using label stock.
Download a free Avery 5163 CSV template
A Avery 5163 data template is a spreadsheet with one column per field and one row per label. Add your rows in Excel, Google Sheets or Numbers, then import it into PrintPiper — the headers below map directly onto a standard address-label design.
Follow the Excel import guide to load the file, or the address-label guide to build the address block first. For blank sheets you type into by hand, use Avery’s own template; for filling an entire sheet from a list, use the CSV and the browser workflow.
Avery 5163 sheet dimensions
Avery 5163 / 8163 is the 4 × 2 inch shipping-label sheet: 2 columns × 5 rows, 10 labels per US Letter sheet, with the first label 0.15625 inch from the left and 0.5 inch from the top.
5163 is laser stock and 8163 is inkjet stock. Print at Actual size and test on plain paper — shipping labels leave no room for a second attempt on adhesive stock.
| Paper | US Letter, 8.5 × 11 inches |
|---|---|
| Label | 4 × 2 inches (101.6 × 50.8 mm) |
| Grid | 2 columns × 5 rows |
| First label | 0.15625 inch from the left, 0.5 inch from the top |
| Pitch | 4.1875 inches horizontal, 2 inches vertical |
Design one label
Create a template and choose Avery 5163 / 8163 · 10 labels / sheet under Preset. The editor snaps one label to its physical size. Add reusable variables such as {{Name}}, {{Address}} and {{PostalCode}}, or add single-page PDF or image artwork.
Import spreadsheet data
Save the template, then use Import CSV / Excel. XLSX, XLS, CSV and TSV are supported. Choose your sheet and column-name row, map columns to the template variables, and check several records in the whole-sheet preview before generating.
Records fill left to right and then top to bottom across the grid; the last sheet keeps its unused positions blank. Download PDF, PNG or TIFF files, print at Actual size, and compare a plain-paper test against the stock grid before committing adhesive sheets.
How the built-in grid maps the sheet
The Avery 5163 / 8163 · 10 labels / sheet option encodes the stock’s fixed grid. Its stored values, useful if you verify the layout or print this sheet with another tool:
| Frame size | 101.6 × 50.8 mm shipping label |
|---|---|
| Printer margins | 3.96875 mm left and right, 12.7 mm top and bottom |
| Gaps | 4.7625 mm horizontal gap, 0 mm vertical gap |
| Resulting grid | 2 columns × 5 rows, centered to the stock grid |
PrintPiper centers this grid inside the printer’s printable area automatically — no manual placement needed.
Common questions
How many 5163 labels fit on one sheet?
Ten: two columns of five 4 × 2 inch labels on US Letter paper. Eleven records spill to a second sheet with one filled label.
What is the difference between 5163 and 8163?
Only printer stock: 5163 is for laser printers, 8163 for inkjet. Both use the same 4 × 2 inch, 10-up layout and the same templates.
Is 5163 suitable for addresses?
Yes — the 4 × 2 inch size fits a full postal address plus a return address or reference line, which is why warehouses use it for parcels. For 30-up envelope labels use the 5160 layout instead.