How to create and print labels from an Excel list

Using Excel to create labels can be a bit tricky due to the way spreadsheets appear in the program. For newer users, it can be difficult to know where a page begins and ends, so customizing something like a label page may seem daunting. Luckily, Microsoft Word has a function that allows you to create labels from Excel spreadsheets. Let’s review how to make an Excel sheet into labels.

How to create mailing labels in Word from an Excel sheet

For this to work, you must already have an Excel spreadsheet with the data you need for your mailing labels. For example, we will be using this Excel document containing our targets’ names, addresses, cities, ZIP codes, and phone numbers. Not all data will transfer, but you can customize your labels after they’re set up.

Launch Microsoft Word. Go to the Mailings tab from the document where you wish to create your labels.

In the Start Mail Merge section, click the Start Mail Merge dropdown.

Select Step-by-Step Mail Merge Wizard… from the options below.

Under Select document type, click Labels, then click Next: Starting document.

Next, it’s time to identify the kind of label you’re using for your document layout.

Under Select starting document, click Change document layout. Then, under Change document layout, click the Label options… button.

Identify the labels you will be printing on. Use the Label vendors dropdown to choose your brand, then identify the exact product number of the labels you are using. When finished, click OK.

Once you’ve identified your labels for your document layout, click Next: Select recipients.

Under Select recipients, click Use an existing list. Then, under Use an existing list, click the Browse… button.

In File Explorer, locate the Excel spreadsheet containing all the address data for your labels. Select it, then click Open.

Click the sheet in the Select Table menu, then click OK.

Select all addresses you want to include in your labels using the checkboxes. When satisfied, click OK.

Click Next: Arrange your labels.

Under Arrange your labels, click the Address block… button.

You can customize the way your address data appears for the labels here. When finished, click OK.

Under Replicate labels, click Update all labels. This will add all of your selected addresses to the template.

Click Next: Preview your labels.

When satisfied, select Next: Complete the merge.

Your label sheet created from the original Excel document is now complete. You can click Print… to print them immediately, Edit individual labels to further customize the sheet, or save the document for later.