How to Create Labels in Word from an Excel Spreadsheet

If you’re looking tocreate and print labelsof any kind, look no further than Microsoft Word and Excel. You can store your label data in Excel and then fetch that data in Word to save or print your labels.

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:

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 yourprinter is connected to your computerwhen 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.

Mahesh has been obsessed with technology since he got his first gadget a decade or so ago. Over the last few years, he’s written a number of tech articles on various online publications including but not limited to MakeTechEasier and Android AppStorm.Read Mahesh’s Full Bio

Welcome to Help Desk Geek- a blog full of tech tips from trusted tech experts. We have thousands of articles and guides to help you troubleshoot any issue. Our articles have been read over 150 million times since we launched in 2008.

HomeAbout UsEditorial StandardsContact UsTerms of Use

How to Create Labels in Word from an Excel Spreadsheet#

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

2. Configure Labels in Word#

3. Bring the Excel Data Into the Word Document#

4. Add Labels from Excel to a Word Document#

5. Create Labels From Excel in a Word Document#

6.Save Word Labels Created from Excel as PDF#

7.Print Word Labels Created From Excel#