Print Address Labels from Excel

Print address labels from an Excel, Google Sheets or CSV list on Avery 5160 and other sheets, or download a PDF. No Word, no upload — your list never leaves your device.

Your address list is read on this device and never uploaded

Print mailing labels from a spreadsheet without Word mail merge

What to print

.xlsx, .csv or .txt — read on this device, never uploaded

Or paste your list (copy the cells in Excel or Google Sheets, header row included, and paste them here)

Read the list as

First row has column names

What goes on each label (one line per label line; {Column} is replaced by that column, and lines that come out empty are skipped)

Columns:

Label sheet

Start at label (to finish a partly used sheet)

Copies of each label

Text size (long addresses shrink to fit)

Alignment

Bold first line USPS style: CAPITALS, no periods or commas Print a thin outline around each label

Printer adjustment

Move right

Move down

In inches; use negative numbers to move left or up. Print the alignment test first to see how far off your printer is.

—Labels

—Sheets

—Labels per sheet

—Smallest text

In the print dialog choose Actual size (100%) — never “Fit to page” — and margins “None” or “Default”. Print the test on plain paper first and hold it against a label sheet up to the light.

Paid link Avery 5160 label sheets on Amazon →
We earn a commission if you buy, at no extra cost to you. As an Amazon Associate I earn from qualifying purchases.

Preview

How to print address labels from Excel or Google Sheets

Quick answer: open your Excel file (or copy the cells from Excel or Google Sheets and paste them), check the label template — {Name}, {Address}, {City}, {State} {ZIP} — pick your sheet, such as Avery 5160 (30 labels of 1 × 2⅝ in), and print at Actual size (100%). Columns are matched by their names, empty lines are skipped, and a long address shrinks to fit its label instead of spilling into the next one. You can also download a PDF to print later or send to a print shop. It is built for Christmas card lists, wedding invitations and club or client mailings, and it needs no Word: Word for the web can’t make mail merge labels at all.

Most misprinted labels come from the print dialog, not the template: “Fit to page” scales the sheet down a few percent, so the labels drift further off with every row — the usual reason an Avery 5167 sheet “isn’t lining up”. Print at 100% on the matching paper size, run the one-page alignment test on plain paper first, and use the printer adjustment if your printer is slightly off. Excel also drops leading zeros from ZIP codes — every Puerto Rico ZIP starts with 00 — and the tool puts them back when the column has other five-digit codes. Your list is read in this browser tab and never uploaded.

Label sheets and sizes

Sheet	Label size	Labels per sheet	Typical use
Avery 5160 / 8160	1 × 2⅝ in	30	Envelopes, Christmas cards, invitations
Avery 5161 / 8161	1 × 4 in	20	Longer addresses
Avery 5162 / 8162	1⅓ × 4 in	14	Addresses with a company line
Avery 5163 / 8163	2 × 4 in	10	Packages and shipping
Avery 5164 / 8164	3⅓ × 4 in	6	Large shipping labels
Avery 5167 / 8167	½ × 1¾ in	80	Return address
Avery 5195 / 8195	⅔ × 1¾ in	60	Return address
Avery L7160 (A4)	63.5 × 38.1 mm	21	Envelopes (A4 paper)

The numbers measured by Avery for each sheet are built in; any other sheet works through Custom size: measure the label, the top and left margins, and the distance from one label to the next.

Print labels from Excel, step by step

Open your .xlsx or .csv file, or select the cells in Excel or Google Sheets (header row included), copy, and paste them in the box.
Check “What goes on each label”: each line is a line of the label, and {Column} is replaced by that column. Click a column name to add it.
Choose the label sheet. If the first labels on your sheet are already used, set “Start at label” to the first free one.
Click Print alignment test and print it on plain paper at Actual size (100%). Hold it against a label sheet up to the light.
Load the label sheet and click Print labels, again at 100%. Or download the PDF and print it from any PDF reader.

FAQ

Why do my labels print shifted down the page?

Usually because the print dialog is scaling the page: “Fit to page” or “Shrink oversized pages” makes everything a few percent smaller, so each row lands a little higher than the label below it. Choose Actual size (100%), the paper size of your sheets (Letter for Avery 5160) and margins “None” or “Default”, print the alignment test on plain paper, and if your printer is still a millimeter or two off, use the printer adjustment.

Can I print address labels from Excel or Google Sheets without Word?

Yes. Open the .xlsx or .csv file here — or select the cells in Excel or Google Sheets, copy and paste them — check which columns go on each label, choose your sheet and print or download a PDF. There is no data source to connect and no “Next Record” field to copy to every label.

Why did my ZIP codes lose the leading zero?

Excel stores 00926 as the number 926 unless the column is formatted as Text, and a custom 00000 format only hides the problem. This tool restores the zeros when the ZIP column also has five-digit codes. In Excel itself, format the column as Text before typing or importing.

How do I address a label in Puerto Rico with an urbanization?

Put the urbanization on its own line above the street line, as USPS asks: MRS MARIA SUAREZ / URB LAS GLADIOLAS / 150 CALLE A / SAN JUAN PR 00926-3232. Keep CALLE and AVENIDA in Spanish. A column named Urbanization (or Urb) is placed above the street automatically.