How to Merge Excel Data Into Word Documents

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

When compiling a report or working on a project, sometimes it's easiest to collect data in a table format via Microsoft Excel. This information can easily be transferred from Excel to a document in Microsoft Word. It's simply a matter of copying the data from a Microsoft Excel document and pasting it into a Microsoft Word document.

Advertisement

Step 1

Open both the Microsoft Word document and the Microsoft Excel spreadsheet in separate windows on the computer screen. Bring the Excel document to the foreground.

Video of the Day

Step 2

Highlight the block of spreadsheet cells that need to be included in the Word document. Copy the cells by hitting the control button and "C" at the same time, or by selecting the "Copy" option underneath the "Edit" menu at the top of the screen.

Advertisement

Step 3

Bring the Word document to the foreground. Position the cursor where the Excel data should be placed in the document. Go to the "Edit" menu in the Word Document and select "Paste Special."

Advertisement

Step 4

Wait for a box entitled "Paste Special" to pop up on the screen. Select "Paste" on the left side of the box. In the center of the box, there is a menu entitled "As." Select "Microsoft Excel Worksheet Object" under this heading. Click "OK."

Step 5

Scan the document. The Excel table should now be in the Word document, in the spot where the cursor had been placed.

Video of the Day

Advertisement

Advertisement