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

Get FREE Advanced Excel Exercises with Solutions!

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


How to Copy Excel Sheet into Word: 4 Simple Methods

We can copy Excel sheets 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 sheets into MS Word. For demonstration purposes, I have introduced a dataset having Salesperson, Sales (Jan), Sales (Feb), and 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.

  • 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: How to Copy a Sheet to Another Sheet 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 a Linked Object. I am showing below the stepwise procedures for this method.

  • 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


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.

  • 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 an Excel sheet.

how to copy excel sheet into word result

Read More: How to Copy Excel Sheet to Another Sheet with Same Format


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 a 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 the 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: [Fixed!] Move or Copy Sheet Not Working in Excel


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 the Display as icon button.
  • Finally, press OK.

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


Download Practice Workbook

You can download the practice workbook from here.


Conclusion

Copying the Excel worksheet into Word comes in handy sometimes. In this article, I have shown 4 simple methods to copy Excel sheets into Word. If you have any queries or suggestions, please leave a comment.


Related Articles


<< Go Back to Copy Sheet | Worksheets | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mehedi Hasan Shimul
Mehedi Hasan Shimul

Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content.... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo