In this guide, you’ll learn how to create a label spreadsheet in Excel that’s compatible with Word, configure your labels, and save or print them.

1. Enter the Data for Your Labels in an Excel Spreadsheet

The first step is to create an Excel spreadsheet with your label data. You’ll assign an appropriate header to each data field so you can retrieve the headers in Word.For the following example, we’ll create a spreadsheet with the following fields:

First NameLast NameStreet AddressCityStateZIP Code

To start creating your Excel spreadsheet:Your Excel spreadsheet is now ready.

2. Configure Labels in Word

The second step is to configure the dimensions of your labels in Word. There are several predefined label layouts that you can choose from. You can even create your own label with custom dimensions, if you want.

3. Bring the Excel Data Into the Word Document

Now that your labels are configured, import the data you saved in your Excel spreadsheet into your Word document. You don’t need to open Excel to do this.To start:

4. Add Labels from Excel to a Word Document

You will now specify the fields you’d like to use in your labels.To do that:

5. Create Labels From Excel in a Word Document

Word now has all the data it needs to generate your labels. You will now finish the process and Word will display the actual data for each label:You can now save this labels document, generate a PDF out of it, or physically print the document (labels).

6. Save Word Labels Created from Excel as PDF

You don’t have to use a third-party tool to save your Word’s label document as PDF:

7. Print Word Labels Created From Excel

You can print your labels directly from Word. Make sure your printer is connected to your computer when you perform printing:And you’re all set.As you can see above, Word and Excel help you create nearly all kinds of labels on your Windows and Mac computers. If this helped you generate the type of labels in Excel that you wanted, let us know in the comments below. How to Create Labels in Word from an Excel Spreadsheet - 63How to Create Labels in Word from an Excel Spreadsheet - 35How to Create Labels in Word from an Excel Spreadsheet - 43How to Create Labels in Word from an Excel Spreadsheet - 74How to Create Labels in Word from an Excel Spreadsheet - 5How to Create Labels in Word from an Excel Spreadsheet - 37How to Create Labels in Word from an Excel Spreadsheet - 97How to Create Labels in Word from an Excel Spreadsheet - 24How to Create Labels in Word from an Excel Spreadsheet - 16How to Create Labels in Word from an Excel Spreadsheet - 81How to Create Labels in Word from an Excel Spreadsheet - 30How to Create Labels in Word from an Excel Spreadsheet - 88How to Create Labels in Word from an Excel Spreadsheet - 29How to Create Labels in Word from an Excel Spreadsheet - 82How to Create Labels in Word from an Excel Spreadsheet - 26How to Create Labels in Word from an Excel Spreadsheet - 14How to Create Labels in Word from an Excel Spreadsheet - 74How to Create Labels in Word from an Excel Spreadsheet - 32How to Create Labels in Word from an Excel Spreadsheet - 3How to Create Labels in Word from an Excel Spreadsheet - 29How to Create Labels in Word from an Excel Spreadsheet - 63How to Create Labels in Word from an Excel Spreadsheet - 48How to Create Labels in Word from an Excel Spreadsheet - 83How to Create Labels in Word from an Excel Spreadsheet - 61