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

How to Copy Excel Sheet into Word (4 Simple Methods)

For various purposes, we can copy an Excel sheet into MS Word. For example, copying Excel sheet into MS Word helps to make reports in MS Word with data tables from Excel. Copying Excel sheet into MS Word can be done in many ways. In this article, I will show 4 simple methods to copy Excel sheet into MS Word.


Download Practice Workbook

You can download the practice workbook from here.


4 Simple Methods to Copy Excel Sheet into Word

We can copy Excel sheet into MS Word following different methods. And we get different advantages following each method. In this section, I will discuss 4 simple methods to copy Excel sheet into MS Word. For demonstration purposes, I have introduced a dataset having Salesperson, Sales (Jan), Sales (Feb), Sales (Mar) and in the bottom row, there’s a Total of all sales of a month.


1. Copy Excel Sheet to MS Word as Plain Text

The simplest method of copying an Excel sheet to MS Word is using Copy and Paste options. Here, I will show the procedures stepwise.

  • Firstly, open the Excel worksheet and select the dataset.
  • Then, copy the selected dataset by using Copy from the context menu or by using the keyboard shortcut Ctrl + C.

 how to copy excel sheet into word

  • Afterward, open MS Word and paste the copied data table by using the keyboard shortcut Ctrl + V or by using the context menu.
  • Instantly, we will see the data table is pasted into the MS Word document. The data of the table won’t change with the change of data in the Excel sheet.

Read More: [Fixed!] Move or Copy Sheet Not Working in Excel


2. Import Excel Sheet as Linked Object

If we want to copy the Excel sheet into MS Word so that the data table gets updated with a change in the data of the Excel sheet, we can copy the data table as Linked Object. I am showing below the stepwise procedures for this method.

  • Firstly, select and copy the dataset from the Excel sheet by using the keyboard shortcut Ctrl + C or by using the context menu.

Import Excel Sheet as  Linked Object

  • Next, open the MS Word document and select the small icon below the Paste option in the Home tab.
  • Further, select Paste Special from the options.

  • Consecutively, the Paste Special window will appear.
  • Now, click on the Paste link and choose Microsoft Excel Worksheet Object.
  • Finally, press OK.

  • We will see the Excel sheet copied successfully into MS Word.

how to copy excel sheet into word result

Read More: How Do I Duplicate a Sheet Multiple Times in Excel?


3. Embed Excel Sheet into MS Word

Another way to copy Excel sheet into MS Word is by embedding the Excel worksheet into MS Word. In this way, an Excel sheet will be included in the MS Word document. Let’s follow the stepwise procedures given below.

  • Firstly, select and copy the Excel worksheet by using the keyboard shortcut Ctrl + C.

Embed Excel Sheet into MS Word

  • Afterward, open an MS Word document and click on the small expansion icon below the Paste option in the Home tab.
  • Further, select the Paste Special option from there.

  • A Paste Special window will pop up.
  • Next, click on the Paste option and select Microsoft Excel Worksheet Object from there.
  • Finally, press OK.

  • Instantly, we will see the Excel sheet copied to MS Word. we can double-click it to open it in Excel sheet.

how to copy excel sheet into word result

Read More: Excel VBA to Copy and Rename a Worksheet Multiple Times


Similar Readings


4. Create Copy of Excel Sheet in MS Word as Image

Another way to copy the Excel sheet to MS Word is by copying it as an image. The image can have static or dynamic nature. In this section, I will show the procedures for that.

4.1 Copy As Static Image

Please, follow the steps given below for copying the Excel sheet as a static image.

  • First, open the Excel worksheet and select the dataset.
  • Afterward, copy the selected dataset by using the keyboard shortcut Ctrl + C.

Create Copy of Excel Sheet in MS Word as Image

  • Now, open the MS Word document.
  • Further, click on the small icon below the Paste option in the Home tab.
  • Consecutively, select the Paste Special from the options.

  • In the Paste Special window, click on the Paste option.
  • Then, select Picture (Enhanced Metafile) and press OK.

  • Finally, we will see the static image pasted into MS Word.

how to copy excel sheet into word result


4.2 Copy As Dynamic Image

We can also copy the dataset from Excel worksheet into MS Word as a dynamic image which means the image can be updated with the change of data in Excel worksheet. Please follow the steps given below for the method.

  • First of all, select and copy the dataset from the Excel worksheet by using the keyboard shortcut Ctrl + C.

Copy As Dynamic Image

  • Now, open the MS Word document.
  • Next, select the small expansion icon below the Paste option in the Home tab.
  • Further, select Paste Special.

  • Later on, from the Paste Special window click on the Paste link and select Picture (Windows Metafile).
  • Finally, press OK.

  • Now, we will see the dataset is copied successfully.

  • If we change any data in the original Excel worksheet, all we need to do is right-click on the image and select Update Link. it will update the image according to new data.

Read More: Excel VBA: Copy Worksheet to Another Workbook Without Opening


How to Use the Insert Object Feature of MS Word to Import Excel Sheet into MS Word

Instead of copying the Excel worksheet, we can include the worksheet in the MS Word document directly. Then, we can access the Excel worksheet from an MS Word document. Let’s follow the steps given below for the method.

  • Firstly, open an MS Word document.
  • Next, go to the Insert tab in the ribbon and select a small expansion icon beside the Object option.
  • Further, select Object from the options.

How to Use the Insert Object Feature of MS Word to Import Excel Sheet into MS Word

  • An Object window will show up.
  • Afterward, select Create from File option.
  • Then, browse and select the Excel file from your computer.
  • Next, click on Disaplay as icon button.
  • Finally, press OK.

  • We have successfully included the Excel file into MS Word document. We can access the document by double clicking on the icon.


Conclusion

Copying the Excel worksheet into word comes in handy sometimes. In this article, I have shown 4 simple methods to copy Excel Sheet into word. If you have any queries or suggestions, please leave a comment. Visit our ExcelDemy site for similar articles regarding Excel.


Related Articles

Mehedi Hasan Shimul

Mehedi Hasan Shimul

Hi! I am Mehedi Hasan Shimul. As I am an Engineer solving different problems with the help of Excel amuses me. I write Excel related different problem solving articles here. Hope it will help you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo