Next, you’ll get a dialog box namely Create Table where you have to check the box before My table has headers option. So, select the whole dataset and pick the Table option from the Insert tab. In such a situation, you may create an Excel table from the dataset and then merge it into the document. Sometimes, you have to keep certain formatting e.g. Surprisingly, if you double-click over any cell within the dataset, you’ll see the Excel Ribbon in your document! Immediately, you’ll see a dialog box namely Paste Special and choose the Microsoft Excel Worksheet Object option from the list of As.Īfter pressing OK, you’ll get the following dataset in the Word document. ➔ 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. And copy the dataset by pressing CTRL + C. ➔ Initially, select the entire dataset by moving the cursor manually till the end of the dataset or press CTRL + A. Merge Dataset into Word Document Directly Merge dataset into Word document directlyġ.1.However, I’m going to discuss 3 individual ways under this method. 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. More importantly, the dataset belongs to the B2:H23 cell range. Sales Rep, Product ID and Category, States, Price, Quantity, and lastly Sales. Here, the sales report is given along with the necessary information e.g. Let’s introduce today’s dataset as shown in the following screenshot. Merge Excel File with Single Page into Word Document