Document Editing Problems

How to Create Mailing Labels in Word from an Excel Spreadsheet

Steve K Sep 29, 2026 869 views

Question details

The user needs to generate and print mailing labels in Word by importing a contact list directly from an Excel spreadsheet.

Word mail merge labels with Excel fields and Update Labels

Product: Microsoft Word / Excel
Device & OS: not provided
Scenario: Preparing a large batch of physical mailing labels for letters or packages using an existing contact database.
Observed behavior: Generating formatted mailing labels using the Mail Merge feature in the desktop version of Word, linking directly to Excel data.

Before you start

Ensure your Excel spreadsheet is properly formatted with clear column headers in the first row (e.g., Name, Address, City, State, ZIP Code) and no blank rows or columns before the data.

Solution 1Recommended

Use the Mail Merge Feature in Word Desktop

Import your Excel data directly into Word's label templates using the built-in Mail Merge wizard to automatically generate properly formatted labels.

Word for the web does not support full Mailings and label-merge controls. You must use the desktop version of Microsoft Word to complete this task.

Start the Mail Merge for Labels

Open a blank document in the Word desktop app. Select the 'Mailings' tab on the ribbon, click 'Start Mail Merge', and choose 'Labels'. Select your label vendor and product number, then click OK.

Select the Excel Data Source

Still under the 'Mailings' tab, click 'Select Recipients' and choose 'Use an Existing List'. Browse your computer to locate and open your prepared Excel spreadsheet.

Insert Merge Fields

Click 'Insert Merge Field' and add the necessary headers (like First Name, Last Name, Address, City) into the first label cell. Format the text spacing exactly how you want it to appear on the printed label.

Update All Labels

Once the first label is formatted correctly, click the 'Update Labels' button in the Mailings tab. This copies your layout to all the other labels on the sheet.

Preview and Finish

Click 'Preview Results' to verify that your Excel data is displaying correctly. Finally, click 'Finish & Merge' and select 'Print Documents' to print directly, or 'Edit Individual Documents' to save the generated labels as a new file.

Use the Mail Merge Feature in Word Desktop

Missing Mailings Tab: If you do not see the Mailings tab in your Microsoft 365 Word, you can enable it by going to File > Options > Customize Ribbon, checking the 'Mailings' box under Main Tabs, and clicking OK.

Efficient Label Generation

Create Mailing Labels Seamlessly with WPS Office

WPS Office Writer provides a powerful, built-in Mail Merge tool that allows you to easily import contact lists from WPS Spreadsheet or Microsoft Excel to generate precise mailing labels, completely free of charge.

1. Open Mail Merge: Open a new blank document in WPS Writer, navigate to the 'References' tab, and click on 'Mail Merge' to reveal the Mailings toolbar.
2. Connect Spreadsheet: Click 'Open Data Source' on the toolbar and select your saved Excel or WPS Spreadsheet contact list.
3. Design the Label: Use the 'Insert Merge Field' button to place your column headers (Name, Address, etc.) into the document layout.
4. Generate Final Labels: Click 'Merge to New Document' to generate a file containing all your customized labels, ready for reviewing and printing.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Built-in intuitive Mail Merge wizard for labels, letters, and envelopes.Free, lightweight, and easy to navigate with a familiar ribbon interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I find the Mail Merge options in Word for the web?

Word for the web does not support the full Mail Merge feature, including label creation. You must open the document in the desktop version of Microsoft Word or use an alternative like WPS Office to access these advanced mailing tools.

How do I fix a missing Mailings tab in Word Desktop?

If the Mailings tab is hidden in your desktop app, go to 'File' > 'Options' > 'Customize Ribbon'. In the right-hand column under 'Main Tabs', check the box next to 'Mailings' and click 'OK' to restore it.

Why are ZIP codes missing leading zeros in my Word labels?

Excel sometimes drops leading zeros in ZIP codes if the column is formatted as General or Number. To fix this, change the format of the ZIP code column in your Excel spreadsheet to 'Text' and re-type the missing zeros before running the mail merge in Word.

Can I use a Google Sheets file for a Word Mail Merge?

Word cannot directly link to a live Google Sheet for mail merges. You must first open your Google Sheet, go to 'File' > 'Download', and save it as a Microsoft Excel (.xlsx) or CSV file. You can then select that downloaded file as your recipient list in Word.

Document & File Issues