If yous're looking to create and impress labels of any kind, look no further than Microsoft Word and Excel. You can store your characterization data in Excel and 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'south compatible with Word, configure your labels, and salvage or print them.

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

The beginning step is to create an Excel spreadsheet with your label data. You'll assign an advisable header to each information field so you can retrieve the headers in Word.

For the following case, nosotros'll create a spreadsheet with the post-obit fields:

  • First Proper name
  • Concluding Proper name
  • Street Address
  • City
  • Country
  • Nix Lawmaking

To starting time creating your Excel spreadsheet:

  1. Launch Microsoft Excel on your Windows or Mac figurer and create a new spreadsheet.
  2. On Excel's spreadsheet screen, select the kickoff jail cell in the first row and blazon First Name.
  1. Select the first jail cell in the B column and blazon Terminal Proper noun. Similarly, add together Street Address, City, State, and ZIP Code to the C, D, E, and F columns' kickoff rows, respectively.
  2. At present add together the data below each header you lot just created. Your spreadsheet should look something like this:
  1. When you lot've finished adding information, save your spreadsheet by selecting File at the top.
  2. Select Save in the left sidebar.
  3. Select Browse in the pane on the right.
  1. Choose a folder to save your spreadsheet in, enter a name for your spreadsheet in the File proper noun field, and select Save at the bottom of the window.
  1. Close the Excel window.

Your Excel spreadsheet is now set.

2. Configure Labels in Give-and-take

The second step is to configure the dimensions of your labels in Word. In that location are several predefined label layouts that you can choose from. You lot can fifty-fifty create your ain label with custom dimensions, if y'all desire.

  1. Launch Microsoft Word on your Windows or Mac calculator and beginning a new blank document.
  2. On the document editing screen, select the Mailings tab from the meridian toolbar.
  3. In the Mailings tab, select Start Mail Merge and and then cull Labels from the menu.
  1. In the window that opens, select a label vendor from the Label vendors dropdown menu. So, select a label type from the Product number list, Finally, select OK.
  1. If you lot'd like to create a custom label, select the New Label push and specify your label dimensions on the following window.
  1. Your characterization layout is now configured, and continue this document open up in Word.

3. Bring the Excel Data Into the Word Document

At present 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 practise this.

To start:

  1. While your Give-and-take document is still open, select the Mailings tab at the top.
  2. In the Mailings tab, select Select Recipients and choose Apply an Existing List. You're telling Discussion you desire to use a predefined list for your labels.
  1. In the File Explorer window that opens, navigate to the folder containing the Excel spreadsheet you created in a higher place. Double-click the spreadsheet to import information technology into your Word document.
  1. Discussion will open a Select Table window. Here, select the sheet that contains the label data.
  2. Tick mark the First row of data contains column headers option and select OK.

4. Add Labels from Excel to a Word Document

You will now specify the fields y'all'd like to use in your labels.

To practice that:

  1. Ensure you're still on the labels document in Word.
  2. Select the Mailings tab at the top, and so from the Write & Insert Fields department, select the Address Block choice.
  1. On the Insert Address Block window that opens, select the Match Fields push button.
  1. Discussion opens a Match Fields window. Here, make certain each field in the Required for Accost Cake matches with the appropriate field in your spreadsheet. For example, Address 1 should exist set to use Street Address from your spreadsheet, and and then on.
  1. Select OK to shut the window.
  2. Back on the Insert Address Block window, you tin see a preview of your characterization. Ensure this preview represents the actual labels you want to create. Then, select OK at the lesser of the window.
  1. In your Discussion document, you'll notice the first label at present says <<AddressBlock>>.
  2. Select the Mailings tab at the meridian and so select Update Labels.
  1. All labels in your document should now say <<AddressBlock>>.

5. Create Labels From Excel in a Discussion Document

Discussion at present has all the data information technology needs to generate your labels. You will now finish the process and Word will display the actual information for each label:

  1. In the Mailings tab of Word, select the Finish & Merge option and choose Edit Individual Documents from the menu.
  1. In the window that opens, cull All and select OK.
  1. Your Give-and-take document should at present display all your labels with their individual data.

You can now relieve this labels document, generate a PDF out of information technology, or physically print the certificate (labels).

vi. Salvage Discussion Labels Created from Excel every bit PDF

You don't have to use a third-party tool to salvage your Word'due south label document as PDF:

  1. Select the File tab at the top of the Discussion window.
  2. From the sidebar on the left, select Save As.
  3. Choose Browse on the correct pane.
  1. Select a binder to save your PDF in, enter a name for your PDF in the File name field, choose PDF from the Save as type dropdown carte du jour, and select Save.

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 y'all perform printing:

  1. Select the File tab at the top of the Discussion window.
  2. Select Impress in the left sidebar.
  1. Choose a printer from the Printer menu on the right pane, and then select Print at the top.

And you lot're all set.

As you can see above, Word and Excel assist you create well-nigh 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 the states know in the comments beneath.