How to Make Mailing Labels from Excel?

Open your Excel file and make sure each column has a clear header, such as Name, Address, City, State, and ZIP

Clean and verify the data so each row contains one complete mailing address

Save the Excel file

Open Microsoft Word

Go to the Mailings tab

Select Start Mail Merge

Choose Labels

Select the label vendor and product number, or create a custom label size

Click Select Recipients

Choose Use an Existing List

Browse to your Excel file and open it

Select the correct worksheet and check that the first row contains headers

Insert the address fields into the first label using Insert Merge Field

Format the label layout as needed

Click Update Labels to apply the layout to all labels

Use Preview Results to check the merged data

Complete the merge by choosing Finish & Merge

Select Edit Individual Documents or Print Documents

Print the labels on label sheets

Save the Word mail merge document for future use

Suggested for You

Trending Today