Shipping & Labels · Free
Avery 5160 template, filled from your CSV.
Paste or open a CSV of addresses and download a PDF laid out for Avery 5160, 8160, 5163, 8163 or 5167 sheets. It is built in your browser and nothing is uploaded.
What you get and how it works
This page turns a spreadsheet of addresses into a Letter-size PDF laid out for an Avery 5160 address label sheet, or the 8160, 5163, 8163 and 5167 sheets from the same family. It is a template filled in for you: each CSV row becomes one label at the exact position of that label on the sheet, and when a sheet is full a second page starts. You print the PDF onto blank label stock. There is no account, no watermark and no limit other than 1000 labels per run.
Paste rows into the box or open a .csv or .txt file saved from Excel, Google Sheets or Numbers. Quoted fields with commas inside, such as "9 Oak Avenue, Apt 4", are read correctly because the reader follows the RFC 4180 quoting rules. If your first row is a header, the tool notices common names such as Name, Street, City, State, Province, Zip and Postal and uses them to put the city, region and postal code on one line. Rows with nothing in them are dropped, and the results table lists every row with the font size used or the reason it was skipped.
Sheet geometry used
| Layout | Label (w x h) | Grid | Left / top margin | Pitch across / down |
|---|---|---|---|---|
| Avery 5160 | 2.625" x 1" | 3 x 10 = 30 | 0.1875" / 0.5" | 2.75" / 1" |
| Avery 5163 | 4" x 2" | 2 x 5 = 10 | 0.16" / 0.5" | 4.19" / 2" |
| Avery 5167 | 1.75" x 0.5" | 4 x 20 = 80 | 0.3" / 0.5" | 2.05" / 0.5" |
Label size and the number per sheet are taken from Avery's template pages (5160, 5163, 5167). Margins and pitch were measured from the blank PDF template that each page offers, rasterised at 300 dpi, so they are good to about 0.01 inch. The 8160 and 8163 use the same numbers as 5160 and 5163 because Avery lists the same size and count and their templates measure identically. Pitch is the distance from the left (or top) edge of one label to the same edge of the next, so the 5160's 2.75 inch pitch on 2.625 inch labels leaves a 0.125 inch gap between columns, while its rows touch with no gap. If you use a different brand or product, choose Custom sheet and type your own measurements in inches or millimetres, on Letter, A4 or Legal paper.
Worked example
The sample CSV has four rows, three of them with a header that includes City, State and Zip. Jane Public's row becomes three lines: Jane Public, 12 Elm Street and Springfield, IL 62704, printed at 11 pt so the widest line fits inside the label with 0.08 inch padding. The fourth label on the sheet, the one that starts the second row, sits 0.1875 inch from the left edge and 1.5 inch from the top, which is 13.5 by 108.0 points from the top-left corner of a 612 by 792 point page. Thirty-one rows would put the thirty-first label at the top-left of a second page. Zoë Tremblay's accented name prints as typed.
Printing it so it lines up
Open the PDF in a desktop PDF viewer rather than a browser tab if you can, choose Letter paper, and set scaling to 100% or Actual size with Fit to page and Shrink oversized pages turned off. A print dialog that quietly scales to 95% to make room for its own margins is the usual cause of address labels drifting down the sheet. Print the calibration page first on plain paper: its 5 inch line must measure 5 inches with a ruler, and its outlines held over a blank sheet against a window should sit on the label edges.
- Feed label sheets the way your printer's manual says; many laser printers want them face down in the bypass tray.
- Do not print duplex on label stock and do not reuse a sheet that has been through a printer once and has missing labels, because loose edges can jam a fuser.
- Use the skip box for partly used sheets rather than cutting them.
Common mistakes
- Choosing the wrong product number. 5160 and 5163 look alike on a shelf but are 30-up and 10-up sheets with different grids.
- Leaving Fit to page on, which shifts every label by a fraction of an inch that grows toward the bottom of the sheet.
- Putting the whole address in one cell. One cell becomes one line, and a long line is shrunk or shortened, so split street, city and postal code into their own columns.
- Expecting the label to be deliverable because it printed. The tool checks layout, not the address.
What this tool does not do
It does not validate, standardise or look up addresses, it does not buy postage or print carrier barcodes, and it does not claim any address is accepted by Canada Post, USPS or any carrier. It uses one built-in sans-serif font in black, with no logos, images or colour. Text outside the Latin-1 character set is replaced with a question mark and flagged. It does not save your list: reload the page and it is gone.
Where your data goes
Your CSV is read by your browser into memory, split into rows with a small parser, and drawn into a PDF by jsPDF, a JavaScript library that runs on the page. The finished PDF is handed to you as a download from a temporary blob address inside your browser. The tool lives in a frame that the browser sandboxes without network permission, and the frame's content security policy only allows blob and data addresses, so a request to any server would be refused by the browser itself. The advertising on this page sits outside the frame and cannot read your list. Nothing is stored when you close the tab.
Common mix-ups
-
Often assumedAddress labels all come in the same size and count.
What the source saysAvery lists the 5160 as address labels, 1 in by 2-5/8 in, 30 per sheet. [1]
-
Often assumedThe 5163 is another 30-up address sheet.
What the source saysAvery lists the 5163 as shipping labels, 2 in by 4 in, 10 per sheet, so its grid, label size and count all differ from the 5160. [2]
-
Often assumedMailing addresses have to be typed in lowercase to look friendly.
What the source saysUSPS Publication 28 says uppercase letters are preferred on all lines of the address block and that lowercase is acceptable if it meets postal guidelines for OCR readability. All lines should share a uniform left margin. [3]
- Avery template 5160: address labels
- Avery template 5163: shipping labels
- USPS Publication 28, section 212: Format
Checked against these sources on .
FAQ
Is Avery 5160 the same layout as 8160?
Avery lists both as 1 inch by 2-5/8 inch labels, 30 per sheet on Letter paper; 5160 is made for laser printers and 8160 for inkjet. Both template pages download the same blank layout, and this tool uses one geometry for both.
What should my CSV columns be?
Put one address per row. If the first row is a header that includes city plus state/province or zip/postal columns, those collapse into one "City, ST ZIP" line. Without a header, every non-empty cell becomes its own line, in order.
Why do my labels print slightly off the edge?
Almost always the print dialog scaled the page. Set 100% or Actual size, turn off Fit to page, and print the calibration page first: its 5 inch line must measure 5 inches. If it does and a label is still off, your printer has a feed offset that only its own settings can fix.
Can I print on a sheet I have already used part of?
Yes. Enter how many labels to skip and printing starts at the next position, reading left to right then top to bottom. Skipped positions are left blank.
Are my addresses uploaded?
No. The CSV is read in your browser and the PDF is built in your browser with jsPDF. The tool frame is sandboxed without network access, so there is nowhere for the data to go.
Does it check that an address is deliverable?
No. It prints what you give it. Address validation is a separate service; USPS Publication 28 sets the U.S. formatting standard and Canada Post has its own postal code lookup, and neither is queried here.
What happens with accented or non-Latin names?
Accented Latin letters such as é, ñ and ö print correctly. Characters outside Latin-1, for example Chinese or Cyrillic, cannot be drawn with the PDF font used here, are replaced with a question mark, and the row is flagged in the results table so you can fix it.
Is this an official Avery tool?
No. TNAADO is not affiliated with Avery. Label sizes and counts come from Avery's template pages and the margins were measured from Avery's blank PDF templates; Avery's own template for your product number is the authority if anything differs.
Sources
Retrieved 2026-11-11: Avery template pages and USPS Publication 28 sections 212 and 222.
- Avery template 5160: label size 1" x 2-5/8", 30 per sheet, and the blank template used for margins (fetched 20 Oct 2026).
- Avery template 5163: 2" x 4", 10 per sheet (fetched 20 Oct 2026).
- Avery template 5167: 1/2" x 1-3/4", 80 per sheet (fetched 20 Oct 2026).
- Avery template 8160: same size and count as 5160 for inkjet (fetched 20 Oct 2026).
- RFC 4180, Common Format and MIME Type for CSV Files: the quoting rules the CSV reader follows (fetched 20 Oct 2026).
- jsPDF project page: the MIT-licensed library that writes the PDF in your browser (fetched 20 Oct 2026).
- USPS Publication 28, Postal Addressing Standards: the U.S. standard for address formatting, which this tool does not check against (fetched 20 Oct 2026).
- MDN: iframe and the sandbox attribute: how a sandboxed frame without allow-same-origin is isolated from its parent page (fetched 20 Oct 2026).