Guide

How to print address labels from Excel without Word

Convert an Excel or Google Sheets mailing list into correctly formatted Avery-compatible address labels without setting up Word mail merge or copying addresses one at a time.

Published: July 13, 2026

Affiliate links: some links on this page go to Amazon. As an Amazon Associate I earn from qualifying purchases, at no extra cost to you.

Quick answer

Put one recipient on each Excel row with separate columns for name, street, city, state, and ZIP. Save the active sheet as CSV UTF-8, then open the free Address Label Maker or the exact Avery 5160-compatible template. In Text mode, select Import CSV, map the columns, preview the formatted addresses, and download the printable PDF.

1. Arrange the mailing list in Excel

Use one row for each recipient and one column for each address part. Separate columns make it easier to sort, check missing ZIP codes, and format every label consistently.

Recommended headings are Name, Company, Street, Street 2, City, State, ZIP, and Country. The importer recognizes common alternatives such as Full Name, Organization, Address, Address 2, Province, Postal Code, and Postcode.

Keep ZIP codes as text when necessary

Excel may remove the leading zero from ZIP codes such as 02108. Format the ZIP column as Text before entering or importing the data, or use a custom five-digit format. Check the exported CSV before printing because a missing leading zero makes a real mailing address incorrect even if the label looks tidy.

2. Save the sheet as CSV UTF-8

From Microsoft Excel

1. Make sure the mailing-list worksheet is active.
2. Choose File > Save As.
3. Select CSV UTF-8 (Comma delimited) (.csv).
4. Save a copy and keep the original Excel workbook.

From Google Sheets

1. Open the mailing-list tab.
2. Choose File > Download > Comma Separated Values (.csv).
3. The current sheet downloads as a CSV file.

3. Import and map the address columns

1. Open the right template. Choose Avery 5160 for common 30-up address sheets, or start at the Address Label Maker when you need another size.
2. Switch to Text mode. The CSV import button appears below the text input.
3. Select Import CSV and choose the exported file.
4. Confirm the header row. Keep “First row contains headers” checked when the sheet begins with Name, Street, City, and similar headings.
5. Map each field. Match spreadsheet columns to Name, Company, Street, Street 2, City, State, ZIP, and Country.
6. Review the preview. MakeMyStickers combines city, state, and ZIP on one line and omits fields that are blank.
7. Import the labels. Each spreadsheet row becomes one multi-line address label.

4. Choose the correct label sheet

The product number matters because margins and gaps differ. Do not choose a layout only because the label dimensions look close. Check the package number, use the matching exact preset, and run a test before putting an expensive sheet through the printer.

5. Review the list before printing

• Search Excel for blank names, streets, cities, states, or postal codes.
• Check leading-zero ZIP codes and international postal codes.
• Remove empty rows at the end of the sheet.
• Look for apartment or suite data stored in the wrong column.
• Check the longest company and recipient names in the preview.
• Deduplicate the spreadsheet if each recipient should receive only one mailing.

6. Print a plain-paper test at 100%

1. Download the PDF from MakeMyStickers.
2. Print the first page on ordinary copy paper.
3. Choose US Letter for standard Avery address sheets.
4. Set scale to 100% or Actual Size.
5. Disable headers, footers, and fit-to-page.
6. Hold the test page behind the blank label sheet against a light.
7. If the labels align, load the real sheet in the orientation required by the printer.

When the entire print is shifted equally, use the X/Y printer-alignment nudge in an exact Avery preset. When the error grows farther down the sheet, the cause is usually scaling, the wrong paper size, or a printer driver setting.

Printing a partially used sheet

You can blank individual cells so MakeMyStickers prints only on labels that remain. Before reusing a sheet, inspect the feed edge for curled backing, exposed adhesive, or loose labels. Never run a damaged label sheet through a laser printer. The complete safety and setup checklist is in how to print on a partially used label sheet.

Common Excel-to-label problems

Frequently asked questions

Can I print Avery 5160 labels from Excel without Word?

Yes. Save the Excel mailing list as CSV, import it into the free Avery 5160-compatible maker, map the address columns, and download a 30-up PDF. Word and mail merge are not required.

How should address columns be arranged in Excel?

Use one recipient per row with separate headings for Name, Company, Street, Street 2, City, State, ZIP, and Country. Separate columns make formatting and error checking easier.

Can I print only part of an address-label sheet?

Yes. Blank individual cells or start the imported addresses after used positions, then inspect the sheet for curled edges or missing labels before feeding it through the printer.

Are imported mailing addresses uploaded?

No. MakeMyStickers reads and formats the CSV locally in the browser. The mailing list is not uploaded to a server and no account is required.

What to read next

For exact sheet geometry and alignment, read the Avery 5160 setup guide. If some labels have already been peeled, continue with the partial-sheet printing guide. For event badges rather than mailing labels, use printing name tags from Excel or CSV.