How to Merge an Excel File into a Word Document – 2 Examples

Example 1 – Merge a Single Page in an Excel File into a Word Document

The sample dataset showcases a sales report: Sales Rep, Product ID and Category, States, Price, Quantity, and Sales.

Dataset

1.1. Merging the Excel Dataset into the Word Document Directly

  • Select the entire dataset by moving the cursor or pressing CTRL + A.
  • Copy the dataset by pressing CTRL + C.

Import Dataset Directly

  • Open a Word document.
  • In the Home tab, choose the Paste Special in Paste. (You can also press ALT + CTRL + V)

Import Dataset Directly

  • In the Paste Special dialog box, choose Microsoft Excel Worksheet Object in As:.

Import Dataset Directly

  • Click OK.

You’ll see the dataset in the Word document.

Import Dataset Directly

If you double-click a cell within the dataset, you’ll see the Excel Ribbon.

Import Dataset Directly


1.2. Creating an Excel Table and Merging it into a Word Document

Step 1: Create an Excel Table and Copy it

  • Select the whole dataset and select Table in the Insert tab.
  • In Create Table, check My table has headers.

Create a Table

A table will be created.

  • Copy the table by pressing CTRL + C.

Merge Excel File with Single Page into Word Document

Step 2: Paste the Table into the Word Document

  • Go to the Word document and choose Microsoft Excel Worksheet Object in the Paste Special dialog box.

Merge Excel File with Single Page into Word Document

You’ll see the table in the document with the Filter Button.

Merge Excel File with Single Page into Word Document

If you click the Filter Button in Product Category, you’ll see the options.

Merge Excel File with Single Page into Word Document


1.3. Merging an Excel Chart into a Word Document

  • Select the chart and copy it.

Import Chart

  • Go to the Paste Special dialog box and choose Microsoft Excel Chart Object.

Import Chart

This is the output.

Import Chart


Method 2 – Merging Multiple Pages of an Excel File into a Word Document

The  dataset below is in B2:H73.

Merge Excel File with Multiple Pages into Word Document

Step 1: Copy and Paste the Dataset

  • Copy the entire dataset.

Merge Excel File with Multiple Pages into Word Document

  • Paste the dataset using the Paste Special dialog box.
  • Choose HTML format.

Merge Excel File with Multiple Pages into Word Document

You’ll see the dataset in the document.

Merge Excel File with Multiple Pages into Word Document

 

Step  2: Add a Header Row to Every Page

Merge Excel File with Multiple Pages into Word Document

  • Select a cell within the copied dataset.
  • Go to the Layout tab.
  • Select Repeat Header Rows in Data.

Merge Excel File with Multiple Pages into Word Document

You’ll see the header row on every page.

Merge Excel File with Multiple Pages into Word Document

  • In the Layout tab, select AutoFit and click AutoFit Contents.

Merge Excel File with Multiple Pages into Word Document

This is the output.

Merge Excel File with Multiple Pages into Word Document

You can also merge and print address labels, merge and create a mailing list.


Download Practice Workbook


<< Go Back To Merge Excel File | Merge in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdul Kader
Md. Abdul Kader

MD. ABDUL KADER is an engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SWM, GIS, RS, and SPSS. He holds a B.Sc in Urban & Regional Planning from Chittagong University of Engineering and Technology and has shifted to become a content developer. In this role, he crafts technical content centred around... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo