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

LayoutLabel (w x h)GridLeft / top marginPitch across / down
Avery 51602.625" x 1"3 x 10 = 300.1875" / 0.5"2.75" / 1"
Avery 51634" x 2"2 x 5 = 100.16" / 0.5"4.19" / 2"
Avery 51671.75" x 0.5"4 x 20 = 800.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.

Common mistakes

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

  1. Avery template 5160: address labels
  2. Avery template 5163: shipping labels
  3. 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.

Advertisement
Advertisement