LineUp Labels Open the editor

Excel · Windows and Mac · no Word needed

Print address labels from Excel, without Word or mail merge

Open your .xlsx file below or paste its cells, choose the number on your label box, and download a PDF at the sheet's exact size. Every row becomes one label: no Word, no mail merge, no fields to insert.

Open your Excel file How your columns are read

Compared with Word's mail merge

  • No upload. No account.
  • Your workbook as it is
  • ZIP codes keep their zeros
Nadia Kowalski14 Orchard LnBurlington, VT 05401Victor OseiOsei & Sons Hardware220 Main StBozeman, MT 59715Leah Brennan602 Cedar St, Apt 3BColumbus, OH 43206Tomás Herrera9 Canal StUnit 4New Orleans, LA 70130Hannah Morrow31 Aspen WayBoulder, CO 80304Eli BrandtBrandt Dental77 Harbor Rd, Suite 210Portland, ME 04101 client-list.xlsx 1Mailing list, updated October 2026 2First NameLast NameAddressCityZIP 3NadiaKowalski14 Orchard LnBurlington5401 4VictorOsei220 Main StBozeman59715 5LeahBrennan602 Cedar StColumbus43206 6TomásHerrera9 Canal StNew Orleans70130 7HannahMorrow31 Aspen WayBoulder80304 Nadia Kowalski14 Orchard LnBurlington, VT 05401

Do it here

Your workbook, as labels.

Open the .xlsx file, or select the cells in Excel, header row included, and paste them. The first sheet with a header is read, and every row becomes a label.

Cells copied from Excel, Google Sheets or Numbers, header row included, or addresses with a blank line between them.

The number on your box

Open the full editor

The sheet shows the sample: a client list with a title row, as Excel copies it. Open your file or paste the cells, and it shows yours.

Your list stays on this device. Nothing is uploaded.

Nadia Kowalski14 Orchard LnBurlington, VT 05401Victor OseiOsei & Sons Hardware220 Main StBozeman, MT 59715Leah Brennan602 Cedar St, Apt 3BColumbus, OH 43206Tomás Herrera9 Canal StUnit 4New Orleans, LA 70130Hannah Morrow31 Aspen WayBoulder, CO 80304Eli BrandtBrandt Dental77 Harbor Rd, Suite 210Portland, ME 04101Ingrid Solberg45 Birchwood DrDuluth, MN 55811Omar Haddad4410 Sunset BlvdLos Angeles, CA 90027
Sample list · 8 labels on 5160

Worked example

A title row, an Email column, two lost zeros: four clean labels.

The workbook as people keep it. Nothing to tidy first: the title row, Email and Phone stay off, the zeros come back and the line break in a cell stays.

In Excel

client-list.xlsx

First NameLast NameCompanyAddressAddress 2CityStateZIPEmail
3NadiaKowalski14 Orchard LnBurlingtonVT5401nadia.k@example.com
4VictorOseiOsei & Sons Hardware220 Main StBozemanMT59715victor@example.com
6TomásHerrera9 Canal St
Unit 4		New OrleansLA70130
8EliBrandtBrandt Dental77 Harbor RdSuite 210PortlandME4101office@example.com
On the 5160 sheet, as listed
  1. Nadia Kowalski14 Orchard LnBurlington, VT 05401
  2. Victor OseiOsei & Sons Hardware220 Main StBozeman, MT 59715
  3. Tomás Herrera9 Canal StUnit 4New Orleans, LA 70130
  4. Eli BrandtBrandt Dental77 Harbor Rd, Suite 210Portland, ME 04101
  • Row 1, the list's title, is passed over: the header is row 2.
  • 5401 prints as 05401, and 4101 prints as 04101.
  • The line break in Tomás's Address cell stays: 9 Canal St, then Unit 4.
  • Email and Phone stay off the label.

From workbook to labels in three steps.

  1. Open the file or paste the cells

    Open your .xlsx above, or select the cells in Excel, header row included, then copy and paste them in the box. A .csv file opens too.

  2. Check the labels

    The sheet beside the box shows every label as it prints: the name in bold, the apartment on the street line, each ZIP code whole. How your columns are read.

    A column missing from the labels?

    Its header is a name the page doesn't know, such as “Mail to line”. Rename it Name, Address or City, or put it on a line in the full editor.

  3. Choose the sheet, download, print at 100%

    Pick the number printed on your label box, set Start at label for a sheet you already used, download the PDF and print it at Actual size.

Sheets for an Excel list

Pick the number printed on your box. Sizes come from Avery's own template files, and the numbers in a row share one layout.

SheetLabel sizePer sheetSame layoutGood for
Avery® 5160 1 × 2-5/8 in 30 8160 · 9160 · 18160 +56 Most lists: a name, a street and a city line at 10 pt, 30 to a sheet.For an inkjet printer, the same sheet is 8160.
Avery® 5161 1 × 4 in 20 8161 · 5261 · 5909 +19 A company under the name, or long streets: the labels are 4 in wide.
Avery® 5163 2 × 4 in 10 8163 · 18163 · 48163 +27 Shipping labels from an order list, a company line included: 14 pt, 10 to a sheet.
Avery® 5167 1/2 × 1-3/4 in 80 8167 · 18167 · 5139 +30 Small labels: three short lines at 7 pt, 80 to a sheet.
  • Count your rows, not your sheets: 30 rows fill one sheet of 5160; the PDF has as many pages as it takes.
  • Half a sheet left? Set Start at label in the box above to the first free label.

Your columns

Header names in, label lines out.

Columns are matched by the names in the header row, in any order. In the sample, 8 of its 10 columns make the label.

  1. AFirst NameLine 1
  2. BLast NameLine 1
  3. CCompanyLine 2
  4. DAddressLine 3
  5. EAddress 2Line 3
  6. FCityLine 4
  7. GStateLine 4
  8. HZIPLine 4
  9. IEmailStays off
  10. JPhoneStays off

Other names it knows

Name
  • Name
  • Full Name
  • Name on envelope
  • Household
  • First Name
  • Last Name
  • Surname
Company
  • Company
  • Organization
  • Business Name
Street
  • Address
  • Street
  • Address Line 1
  • Mailing Address
  • Address 2
  • Apt
  • Suite
  • Unit
City, state and ZIP
  • City
  • Town
  • State
  • ST
  • Province
  • ZIP
  • Zip Code
  • Postal Code
  • City, State ZIP
Country
  • Country
  • Country/Region
Left off
  • Email
  • Phone
  • Mobile
  • Notes
  • Title
  • Middle Name
  • Birthday
  • Group

A column with a name it doesn't know stays off too. In the full editor you can put any column on any line.

Fixed on the way

  • A ZIP code that lost its zero gets it back: 5401 prints as 05401, for US addresses.
  • A line break inside a cell (Alt+Enter) stays a line break on the label.
  • Rows above the header, such as a title, are passed over.
  • Empty rows are dropped. The country prints only outside the US.

Which sheet of the workbook

The first visible sheet with a header row; a hidden sheet is skipped, and so is the summary sheet Numbers adds to an Excel export. The full editor says which sheet it read.

An old .xls file or one with a password gets this message: “This is an older Excel file (.xls) or a password-protected workbook. Save it as .xlsx or CSV and open it again.”

Honestly

Word's mail merge, side by side.

If Word is already on your computer, its mail merge prints the same list. Here's what each way asks of you.

HereWord's mail merge
What you needA browser, on Windows, a Mac or a Chromebook.Word, with your list in an Excel workbook.
StepsThree: open the file, pick the number on your box, download the PDF.Six, in Word's step-by-step wizard: labels, label options, recipients, address block and Update all labels, preview, print (Microsoft's steps).
A sheet you already startedSet Start at label: the used labels stay blank.The merge fills from the first label, so people put empty rows at the top of the list. Word's Labels dialog can place one single label at any row and column (Microsoft's steps).
ZIP codes like 02906The zero comes back for US addresses, whatever the column's format.Dropped unless the ZIP column is formatted as Text (Microsoft's note).
A printer that prints a little offA 1/32 in correction saved for each printer and used in every PDF (calibrate).A custom label with your own measurements: New Label, in Label Options.

Halfway through a merge that misbehaves? Here are seven fixes for mail merge labels.

No Word, or no Office

Any spreadsheet will do: save it as .xlsx or .csv.

This page reads Excel workbooks (.xlsx), CSV files and cells pasted from any spreadsheet. Other files get a note: “Open a CSV or Excel (.xlsx) file, or paste the cells from your spreadsheet.”

  • Excel, without Word

    Excel alone is enough: open the .xlsx above. A workbook with a password doesn't open here; File > Save As, then CSV in the file type box, makes a copy that does (Microsoft's steps).

  • Excel for Mac

    It works the same: open the .xlsx in Safari, Chrome or Firefox. For a CSV, File > Save As and pick CSV UTF-8 (Comma delimited) (Microsoft's list).

  • Numbers on a Mac

    Choose File > Export To > Excel, or CSV (Apple's steps). The summary sheet Numbers adds to an Excel export is passed over. Or copy the cells and paste them above.

  • LibreOffice Calc

    Choose File > Save As, then .xlsx or .csv in the Save as type list (LibreOffice's steps). Its own .ods files aren't read here.

  • Google Sheets

    Copy the cells, header row included, and paste them above. Or click File > Download and choose Excel or CSV (Google's steps). More on labels from Google Sheets.

  • An old .xls file

    In Excel, choose File > Info > Convert to save it as .xlsx (Microsoft's steps). Opened here as it is, it says so and asks for an .xlsx or CSV file.

Three things that keep 5160 labels straight.

Print at actual size

"Fit to page" can resize the sheet, and then the lower rows drift off their labels. The PDF opens at 100%; keep it there.

Feed the right side up

Printers differ: some print on the side facing up in the tray, others on the side facing down. Mark an X on a plain sheet, print once and look before you load labels.

Test on plain paper

Hold a plain-paper print over a 5160 sheet against a window. If it sits off, calibrate once and save the correction for that printer.

Questions people ask

Can you print labels directly from Excel without Word?

Microsoft's own steps print labels from an Excel list through Word's mail merge (Microsoft's steps). Here Word isn't needed: open the .xlsx above, choose the number on your box and download the PDF.

How do I print Avery 5160 labels from Excel?

Open the workbook above and pick 5160: 30 labels of 1 × 2-5/8 in to a sheet. Download the PDF and print it at 100% (Actual size). The template for Avery® 5160 labels has every measurement.

How do I print labels from Excel on a Mac?

The same way: open the .xlsx in Safari, Chrome or Firefox and download the PDF. A list in Numbers opens too once it's exported to Excel or CSV, or you can paste its cells.

How do I convert an Excel list to Avery labels?

Each row becomes one label, and its columns are matched by the names in the header row: Name or First and Last Name, Address, City, State, ZIP. Which names it knows. Pick the number on your Avery box and the PDF puts each label where Avery's template does.

Why did my ZIP codes lose their leading zero?

Excel turns 02906 into the number 2906 unless the column is formatted as Text (Microsoft's note). Here the zero comes back on the label for US addresses; to fix the workbook too, format the ZIP column as Text before typing the codes.

Can I use LibreOffice or an old .xls file?

Yes, saved as .xlsx or .csv first. In LibreOffice Calc, choose File > Save As and pick the type (LibreOffice's steps); an old .xls, Excel converts with File > Info > Convert (Microsoft's steps).

Is there a free alternative to mail merge?

This page: free, with no account and no watermark. Open the list you were merging and every row becomes a label, with nothing to insert or update. Stuck in a merge already? Here are seven fixes for mail merge labels.

Is my spreadsheet uploaded?

No. The workbook is read in your browser and the PDF is made there too. Nothing is uploaded, nothing is stored, and the list never goes in the page address.

The whole workbook, more control.

The editor opens the same file and does more: change the lines, leave out duplicates and rows with no address, sort by last name or ZIP code, print copies.

Open the editor with 5160 Calibrate your printer