How to Print Mailing Labels from Excel

What You’ll Need

Microsoft Excel with your address list (columns like Name, Street, City, State, ZIP)
Microsoft Word (desktop version, not the online browser version)
A printer and label sheets (e.g., Avery 5160 or compatible)
The label product number (usually on the label package)

Step-by-Step

Prepare your Excel data – Make sure your spreadsheet has a header row (e.g., First Name, Last Name, Address, City, State, ZIP). Each column should contain one piece of information, and each row should be one recipient. Save and close the file.
Open Word and start Mail Merge – In Word, go to the Mailings tab, click Start Mail Merge, and select Labels.
Choose your label size – In the dialog that appears, pick your label vendor (like Avery) and the product number (e.g., 5160). If you don’t see it, choose New Label and enter the dimensions from the label package. Click OK.
Select recipients from Excel – Click Select Recipients > Use an Existing List. Browse to your Excel file, select it, and click Open. If prompted, choose the sheet that contains your data and click OK.
Insert address fields – Click Insert Merge Field and add each field (First Name, Last Name, etc.) in the order you want them to appear on the label. Press Enter between lines to create separate lines for address, city, state, and ZIP.
Format the first label – Adjust the font, size, and alignment of the first label as desired. This formatting will be applied to all labels.
Update all labels – Click Update Labels in the Write & Insert Fields group. This copies the layout from the first label to all other labels in the sheet.
Preview your labels – Click Preview Results to see how the labels will look with your actual data. Use the arrow buttons to scroll through recipients and check for any issues.
Print the labels – Load the label sheets into your printer (check the label package for correct orientation). Go to File > Print, choose the correct printer, and print a single test page first to verify alignment. Then print the full batch.

Common Mistakes

Forgetting to close the Excel file before starting Mail Merge – Word may have trouble reading it if it’s open.
Not having a header row – Word needs column names to insert fields, so if your data starts in row 1, add headers.
Choosing the wrong label size – Using a product number that doesn’t match your actual label sheets will cause misalignment.
Not updating labels – If you only format the first label and skip Update Labels, the rest will be blank.
Printing a full sheet before testing – Always print one page first to catch alignment issues early.

Tips

Use a consistent address format in Excel – for example, put the street address in one column, not split across multiple columns.
If your labels have a different brand, check the label package for the equivalent Avery number or enter custom dimensions.
For large mailing lists, consider sorting your Excel data by ZIP code before merging – this can save postage costs if you’re using bulk mail.
Save the Word document as a template so you can reuse it for future mailings – just update the Excel file with new addresses.
If you need to edit a recipient’s address after merging, go back to Excel, fix the data, and then refresh the merge in Word (click Edit Recipient List and re-select the file).

Troubleshooting

Labels print misaligned – Check that the label size in Word matches your label sheets exactly. Try printing on plain paper first and holding it over the label sheet to see if the text lines up. Adjust printer settings like paper size and margins if needed.
Only the first label shows data – You likely forgot to click Update Labels. Go back, click Update Labels, then preview again.
Word says the Excel file is not valid – Make sure the Excel file is saved as .xlsx or .xls (not CSV) and that it’s closed. If the issue persists, open the file in Excel, check for any merged cells or special characters in headers, and save again.
Fields appear as «First_Name» instead of actual data – Click Preview Results to see the actual data. If you want to see the data permanently, you can click Finish & Merge > Edit Individual Documents to create a new document with all labels filled in.
Addresses have extra spaces or blank lines – In Excel, clean up your data using TRIM() to remove extra spaces, or use Find & Replace to remove double spaces. Also check for empty rows in your spreadsheet.
Printing only one label instead of a full sheet – Make sure you’re printing the merged document, not the original label template. Go to Finish & Merge > Print Documents and select All.

Frequently Asked Questions

Can I print labels without Word?

Yes, but it’s more manual. You can use Excel’s built-in label templates (search for “labels” in the template gallery) and copy-paste addresses into each cell, but this is time-consuming for large lists. Word Mail Merge is the standard method.

What if my Excel file has more than one sheet?

When you select the file, Word will ask you to choose a sheet. Make sure you pick the sheet that contains your address data. If your data is in a named range, you can use that instead.

How do I add a return address label?

You can create a separate mail merge for return labels, or simply type your return address in the first label and then copy it to all others using Update Labels (without inserting merge fields).

Can I use Google Sheets instead of Excel?

Yes, but you’ll need to export your Google Sheet as an Excel file (.xlsx) first. Go to File > Download > Microsoft Excel (.xlsx), then use that file in Word.

Why do my labels print with only one address repeated?

This usually happens if you didn’t click Update Labels after inserting fields, or if you selected a single record in the recipient list. Check the Edit Recipient List to ensure all records are selected.

How do I print a single label for testing?

In the Print dialog, set the page range to print only page 1. Or, use Finish & Merge > Print Documents and select Current Record to print just the label you’re viewing.

Sources: Microsoft Support. Menus and buttons can differ slightly by version. Spotted something out of date? Tell us.