Catalog

How to Create Labels in Word from Excel List (Step-by-Step)

November 13, 2023 750 views

You know the data and information should be well organized when dealing with large data. It may be a difficult step to create the labels in the order form Excel. When you import information from Excel to Word, you may worry about creating labels in Word from Excel lists.

If you are thinking about creating labels to sort out the information, you must read this blog and learn how to create labels in Word form Excel list.

How to Create Labels in Word from Excel List on Windows

Suppose you are dealing with Excel data and want to create labels in your Word documents. Still, you do not know how to create labels in word from excel list; here, you will know how to create labels in word from excel list on your windows with the help of some steps and their images for your clarity.

Step 1: First, you must create the data in your Excel spreadsheet and the headings. It will help you get the label in Word along with the headers.

”excel data”


Step 2: In the second step, ensure the zip codes are properly formatted to avoid the mess.

”zip code entries”


Step 3: The next step is to save your file of the spreadsheet in the folder where you can get easy access.

”save file”

”save file”

”save file”

”save file”


Step 4: The next step is to open blank Word documents. Afterward, you must go to the Mailing tab, select Mail Merge, and click on the Label Options.

”mailing and mail merge tab”


Step 5: Then choose the option from the Label vendor and select your Product number. After that, click OK.

”label vendor and product number options”


Step 6: In this step,  you will see the blank file in your Word document. In this window, select the Select Recipients and then click the Use an Existing List to select the file you have already made in your Excel.

select recipients option in word document

Step 7: You must click on the address block in this step. Then, you need to click on the Match Field to ensure that your field matches your desired entries.

”match field option”

Step 8: In the final step, you can see that the data in your label is according to you and what you want to have in your label layout.

label in word document

How to Create Labels in Word from Excel List on Mac

If you want to create and print labels in Word from an Excel sheet, you can store your data in the Excel sheet and then fetch the data in Word. You may not know how to create labels in word from excel list. Here, you will know the steps that will be helpful for you to create the labels in Word form Excel list. The steps are given below:

Step 1: The first step is adding the data to the Excel spreadsheet. You have to assign the heading to each field so that you can retrieve the same header in your Word file. You must select the first cell in the first row on your Excel spreadsheet and type your first name.

”excel sheet with first column”

Step 2: The second step starts when you have finished adding data; you must save your spreadsheet by selecting the File at the top and Save in the left sidebar.

”save file of your excel sheet”

Step 3: In the third step, choose the folder you want to store your spreadsheet. Enter the name in the File name, then select Save to save your file.

save a file with name

Step 4: The next step is to configure labels in Word. For this purpose, you can create your label with custom dimensions or choose from predefined label layouts. Next, you have to click the Mailing tab from the top toolbar. In the Mailing tab, you can select the Start Mail Merge and choose the Labels from the menu.  

”click on label option”

Step 5: In the window that opens after selecting the menu labels, you must go to the Lael vendors from the drop-down menu. Then select the label type from the Product number list and select OK.

”product number list”

Step 6: In this step, you must bring the Excel data into the Word document. After the configuration, your data is ready to import from your Excel sheet to a Word document. Next, select the Mailing tab, Select Recipients, and Use an Existing List.

”use an existing list option”

Step 7: After selecting the existing list, navigate the folders containing your Excel spreadsheet in the open file explorer window. Double-click on your spreadsheet to import it into Word.

”select existing list”

Step 8: In this step, you have to add the labels from Excel to your Word document. To do that, you have to ensure that you will stay at the label documents in Word. Then select the Mailing tab and the Address Block for this tab.  

address block option

Step 9: Select the Match Fields button on the address block window.

”click on match field option”

Step 10: You must ensure that the Address Block matches the required field in the match field.

”recipient list match”

”recipient list match”

Step 11: In your Word document, you can see that your first label says address block. Select the Mailing tab and then choose the Update Labels.  

”update labels option”

”update labels option”

Step 12: In this step, you must create the labels from Excel in your Word document. When you are worried about creating the labels in Word form Excel list, you must do all the steps to prepare the documents to generate the labels.

You will finish this process, and Word will display the actual data for each label. For this purpose, go to the Mailing tab, select the Finish & Merge option, and choose Edit Individual Documents from the menu.

”edit individual document option”

”edit individual document option”

Step 13: In this step, the window opens where you must select All and OK.

”select all and ok options

”select all and ok options

Step 14: You will see that your Word document will display all your labels with their data.

”labels in word document”

”labels in word document”

Excel Label Templates Free Download

You can also get the Excel label template freely. You can choose all types of labels and also get a customizable template. You must look at the examples to learn more about the Excel label template.

Example 1: In this example, you will know that you can download a free hexagon label template. In this template, you can have 30 per-page entries.

”mailing labels with serenity design”

”mailing labels with serenity design”

Example 2: You can also download the mailing labels template free. You can get the design you want in your Excel label, such as the serenity design.

”hexagon labels”

”hexagon labels”

Example 3: In the third example, you should know that you can download the gift label template for your work. In this template, you can have 8 gifts per page.

”gift labels template”

”gift labels template”

Free Office Suite for Word, Excel, PowerPoint ——WPS Office

You know that Microsoft Office has been a market leader in office productivity for decades and has multiple applications such as Word, Excel, and powerpoint. However, with the rise of cloud-based solutions, it has gained popularity.

The free alternative to Microsoft Office is the WPS Office, which has gained popularity. There are many reasons for choosing the wps office as an alternative to the Microsoft office. The reasons are given below:

  • Data Cleaning

  • Substring Extraction

  • Data Transformation

  • Improved Data Manipulation

Now, you can download the WPS Office for free from the official website of WPS Office, such as https://www.wps.com/.

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

FAQs

How do I update labels if my Excel list changes?

When you see that the Excel list has changed, you can update your spreadsheet with the help of creating or adding the new data in your Word document. For this purpose, you have to open the new Word document and go to the mailing tab, where you will get an option to update the labels. So, it is the simplest method to update your Excel list with the new data.

Can I customize the appearance of my labels?

Yes, you can customize the appearance of your label on your own. You may not know how to create the labels in Word form Excel list and then make it according to the design you want in your label.

You can do it by changing the font, and colors and adding the design you want to your labels. Here are some steps that will help you customize the appearance of your labels. The steps are given below:

Step 1: First, you must go to Avery Design & Print and enter your product number.

label template

label template

Step 2: In the second step, select the design template you want to personalize and use for your labels.

design template of label

design template of label

Step 3: In the next step, you can choose the predesigned or blank template to create the scratch independently. If you want to change the predesign, you can simply click and delete the existing graphic and then use the image option on the left side to add the image or graphics you want to your label.

”add image option”

”add image option”

Step 4: In the fourth step, you have to navigate the sheet on the right side and choose Edit All to make the changes you want in your labels. This way, you can apply different designs and text to your labels.

”edit all option on label template”

”edit all option on label template”

Step 5: In the final step, you must review your personalized label. To get a review of your label, you have to click Preview & Print. If you want to adjust, click on the Back button. And when your design is ready, click the Print button to start printing yourself.

”customizable label template”

”customizable label template”

WPS Office as an Alternative to Microsoft Office

In this blog, you learned how to create labels in word from excel list. When you are dealing with a large amount of data in Excel and want to create a label in your Word, you can do that with the help of the methods mentioned above.

If you want an alternative to the Microsoft Office for dealing with your data and information, the WPS Office is the best option, which has many benefits over Microsoft Office. You can download WPS Office from the WPS website.  


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.