How to Create Labels Microsoft Excel

Quick summary

Creating mailing labels from Excel in Microsoft Word uses the Mail Merge feature to pull contact data from a spreadsheet and print formatted labels in bulk. This step-by-step process lets you select a label template, map data fields, and print a full sheet of personalized labels in minutes.

Steps

1. Open a new Word file and navigate to the Mailings tab.
2. Click Start Mail Merge and select Labels from the dropdown.
3. Select the label type matching the brand and product number on your label sheet, then click OK.
4. Click Select Recipients and choose Use an Existing List to link your data source.
5. Locate your Excel file and confirm the contact data is on the first sheet.
6. Use Insert Merge Field to add fields such as First Name, Last Name, Address, and City to the label template, ensuring proper spacing between each field.
7. Click Update Labels to apply the merge field format to all labels on the sheet.
8. Select Finish & Merge and choose Edit Individual Documents to preview and make final edits.
9. Specify the number of labels to print (e.g., 1–10) and click OK to complete printing.