Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Merge Excel File into Word Document

While working in Excel, you might need to merge the file to Word for preparing a report or something else. As these applications are part of Office, owned by Microsoft, you can easily synchronize from one to another application. In this instructive session, I’ll show you 2 methods on how to merge an Excel file into a Word document with proper explanation.


Download Practice Workbook 


1. Merge Excel File with Single Page into Word Document

Let’s introduce today’s dataset as shown in the following screenshot. Here, the sales report is given along with the necessary information e.g. Sales Rep, Product ID and Category, States, Price, Quantity, and lastly Sales. More importantly, the dataset belongs to the B2:H23 cell range.

Dataset

I’d like to say first for your convenience, here the ‘merge a file in the case of a single page’ refers to the merging of a smaller range of cells covering a single page in the Word document.

However, I’m going to discuss 3 individual ways under this method. These are-

  • Merge dataset into Word document directly
  • Create an Excel table and then merge
  • Merge an Excel chart into the document

1.1. Merge Dataset into Word Document Directly

➔ Initially, select the entire dataset by moving the cursor manually till the end of the dataset or press CTRL + A. And copy the dataset by pressing CTRL + C.

Import Dataset Directly

➔ Then, open a Word document and choose Paste Special option (shortcut ALT + CTRL + V) from the drop-down list of the Paste option in the Home tab.

Import Dataset Directly

Immediately, you’ll see a dialog box namely Paste Special and choose the Microsoft Excel Worksheet Object option from the list of As.

Import Dataset Directly

After pressing OK, you’ll get the following dataset in the Word document.

Import Dataset Directly

Surprisingly, if you double-click over any cell within the dataset, you’ll see the Excel Ribbon in your document!

Import Dataset Directly


1.2. Create Excel Table and Merge

Sometimes, you have to keep certain formatting e.g. Filter Button in the Word document. In such a situation, you may create an Excel table from the dataset and then merge it into the document.

Step 01: Create an Excel Table and Copy

➔ Primarily, you need to create a table. So, select the whole dataset and pick the Table option from the Insert tab. Next, you’ll get a dialog box namely Create Table where you have to check the box before My table has headers option.

Create a Table

➔ Instantly, a table will be created as shown in the following screenshot. Now, copy the entire table by pressing CTRL + C.

Merge Excel File with Single Page into Word Document

Step 02: Paste the Table into Word Document

➔ Later, go to the Word document and choose the Microsoft Excel Worksheet Object option from the Paste Special dialog box.

Merge Excel File with Single Page into Word Document

Eventually, you’ll get the table in the document with the Filter Button.

Merge Excel File with Single Page into Word Document

If you click on the Filter Button of the Product Category, you’ll see the options. And this will work the same as it does in Excel.

Merge Excel File with Single Page into Word Document


1.3. Merge Excel Chart into Word Document

Again, if you want to export a chart into a Word document, you can execute this method.

➔ Firstly, select the chart and copy the chart.

Import Chart

➔ Next, go to the Paste Special dialog box and choose the Microsoft Excel Chart Object option.

Import Chart

So, the output will be as follows.

Import Chart

Read More: How to Merge Excel Files into One Using CMD (4 Steps)


Similar Readings


2. Merge Excel File with Multiple Pages into Word Document

This method will be handy if your dataset is the larger one and it will cover multiple pages in the Word document.

The below dataset belongs to the B2:H73 cell range.

Merge Excel File with Multiple Pages into Word Document

Step 01: Copy and Paste the Dataset

➔ In the beginning, you need to copy the entire dataset.

Merge Excel File with Multiple Pages into Word Document

➔ Then, paste the dataset using the Paste Special dialog box where you have to choose the HTML format.

Merge Excel File with Multiple Pages into Word Document

Within seconds, you’ll get the dataset in the document.

Merge Excel File with Multiple Pages into Word Document

Step 02: Add Header Row for Every Page

If you look closely at the copied dataset in the document, you’ll find that the header row of the dataset is missing except for the first page. Certainly, you have to add this header row.

Merge Excel File with Multiple Pages into Word Document

➔ For adding the header row, you have to select a cell within the copied dataset and then go to the Layout tab. And select the Repeat Header Rows from the drop-down list of the Data option.

Merge Excel File with Multiple Pages into Word Document

Immediately, you’ll find the missing header row for every page.

Merge Excel File with Multiple Pages into Word Document

➔ Besides, you may apply the AutoFit Contents from the drop-down menu of the AutoFit option in the Layout tab for making the dataset readable.

Merge Excel File with Multiple Pages into Word Document

Finally, you’ll get the following output.

Merge Excel File with Multiple Pages into Word Document

Furthermore, if you want to merge and print address labels, merge and create a mailing list from the separate cells e.g. Street Address, City, State, and ZIP code in Excel, you can do that quite easily.

Read More: How to Merge Multiple Excel Files into One Sheet by VBA (3 Criteria)


Conclusion

That’s the end of today’s session. I’m sure from now you can easily merge an Excel file into a Word document utilizing the above methods. However, if you have any queries or recommendations, please share them in the comments section below.


Related Articles

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo