How to Insert Excel Table into Word (8 Easy Ways)

Excel is very handy for various calculations and data analysis. But, to represent the summary of the analysis, MS Word becomes handier. This creates a new challenge for us. That is, inserting an Excel table into Word. In this article, I have discussed 8 easy ways to insert an Excel table into Word.


How to Insert Excel Table into Word: 8 Easy Ways

Here, we have taken a dataset of sales of different items of an electronic store throughout the year. We will insert this Excel table into Word in the following 8 easy ways.

Insert Excel Table into Word


1. Insert Excel Table into Word as Plain Text

You can insert an Excel table into Word as plain text. This is the easiest approach. You can follow the given steps to do so.

Steps:

  • At first, select the table that you want to insert into Word. Then, right-click on the table and click on Copy from the context menu.

  • Next, go to your Word file. Click on the place where you want to insert the table. Then, select the Home tab, and afterward, click on the Paste button. You can also press Ctrl + V to paste.

Insert Excel Table into Word

  • By default, the table will be inserted into Word, keeping source formatting. And the result will look like this. 👇

  •  You can also choose the destination style to insert the table. Here, you have to select the Home `first. Then, click on the arrow sign below the Paste button and choose the second option.

  • The table is now inserted as the destination style. And, the result will look like this now. 👇

Read More: How to Copy Table from Excel to Word


2. Insert Excel Table into Word as Microsoft Excel Worksheet Object

You can insert an Excel table into Word as Microsoft Excel Worksheet Object. This way is more dynamic than the previous one. Follow the steps below to do so:

Steps:

  • At first, select the table that you want to insert into Word. Then, right-click on the table, and click on Copy from the context menu.

Insert Excel Table into Word

  • Then, go to your Word file. Hover the cursor where you want to insert the table.
  • Now, select the Home tab >> click on the small arrow below the Paste button >> select Paste Special from the Paste dropdown menu.

Insert Excel Table into Word

  • Now, Paste Special window will appear. Here, select Microsoft Excel Worksheet Object from the listed options. Click on the OK button.

Insert Excel Table into Word

Thus, the table is inserted into Word. The result will look like this. 👇

Insert Excel Table into Word

Here, a great advantage is added in this way. You can double-click on the table inside the Word and it will pop up the table inside MS Excel which will enable you to use Excel features. This will look like this. 👇

Read More: How to Put a Large Excel Table into Word


3. Insert an Excel Table into Word and Link Them

You can insert an Excel table into Word as a linked object too. In this way, your Excel table will be fully dynamic which means if you change the Excel table, the inserted table will automatically change. Use the following steps to do so:

Steps:

  • At first, select the table that you want to insert into Word. Then, right-click on the table and click on Copy from the context menu.

Insert Excel Table into Word

  • Then, go to your Word file. Hover the cursor where you want to insert the table.
  • Now, select the Home tab >> click on the small arrow below the Paste button >> select Paste Special from the Paste dropdown menu.

Insert Excel Table into Word

  • Now, Paste Special window will appear. Here, Click on the Paste link option from the left. And, choose Microsoft Excel Worksheet Object from the listed options. Click on the OK button.

Insert Excel Table into Word

Thus, the table will be inserted into Word. And, the result will look like this. 👇

Insert Excel Table into Word

Read More: How to Insert Excel Table into Word with Formulas


4. Insert Excel Table as a Fixed Image

You can insert an Excel table into Word as a static image too. Follow the steps below to do so:

Steps:

  • At first, select the table that you want to insert into Word. Then, right-click on the table and click on Copy from the context menu.

Insert Excel Table into Word

  • Then, go to your Word file. Place the cursor where you want to insert the table.
  • Now, select the Home tab >> click on the small arrow below Paste button >> select Paste Special from the Paste dropdown menu.

Insert Excel Table into Word

  • Now, Paste Special window will appear. Here, Click on the Paste option from the left. And, choose Picture (Enhanced Metafile) from the listed options. Click on the Ok button.

Insert Excel Table into Word

Thus, the Excel table is inserted into Word as a static image. So, you can not edit any data inside the table anymore. And, the result will look like this. 👇

Read More: How to Paste Excel Table into Word in Landscape


5. Insert Excel Table as a Linked Image

You can insert your Excel table into Word as a linked image too. Here, you can not edit the data of the table inside the Word file. But, if you change the Excel table, the inserted table would also change dynamically. You can do this by following steps:

Steps:

  • At first, select the table that you want to insert into Word. Then, right-click on the table and click on Copy from the context menu.

Insert Excel Table into Word

  • Then, go to your Word file. Place the cursor where you want to insert the table.
  • Now, select the Home tab >> click on the small arrow below the Paste button >> select Paste Special from the Paste dropdown menu.

Insert Excel Table into Word

  • Now, the Paste Special window will appear. Here, Click on the Paste link option from the left. And, choose Picture (Windows Metafile) from the listed options. Click on the OK button.

Insert Excel Table into Word

Thus, the table will be inserted into Word as a linked image. And the result will look like the one below. 👇

Insert Excel Table into Word


6. Insert Excel Table into Word by Embedding Worksheet

You can insert an Excel table into Word by inserting new Excel Worksheets. Follow the steps given below to do so:

Steps:

  • At first, open the Word file and place the cursor where you want to insert the Excel table.
  • Then, click on the Insert tab >> press on the Object icon in the Text group.

Insert Excel Table into Word

  • Now, the Object window will appear. Select the object window tab as Create from the File tab. Browse your desired Excel file. Click on Ok.

Insert Excel Table into Word

Thus, the Excel table will be inserted into Word. And, the result will look like this. 👇

Insert Excel Table into Word

Read More: How to Paste Excel Table into Word Fit to Page


7. Insert Excel Table as Unformatted Unicode Text

You can insert a table into Word as Unformatted Unicode Text. In this method, all formatting will be removed when the table is inserted. You can follow the given steps to do so:

Steps:

  • At first, select the table that you want to insert into Word. Then, right-click on the table and click on Copy from the context menu.

  • Then, go to your Word file. Place the cursor where you want to insert the table.
  • Now, select the Home tab >> click on the small arrow below the Paste button >> select Paste Special from the Paste dropdown menu.

Insert Excel Table into Word

  • Now, Paste Special window will appear. Here, Click on the Paste option from the left. And, choose Unformatted Unicode Text from the listed options. Click on the Ok button.

Insert Excel Table into Word

Thus, the table will be inserted into Word. And, the result looks like this. 👇


8. Embed Excel Table into Word by Inserting Excel Spreadsheet

You can embed an Excel table into Word by directly inserting the Excel spreadsheet. Follow the steps given below to do so:

Steps:

  • First, open the Word file and place the cursor where you want to insert the Excel table.
  • Then, click on the Insert tab >> press on the small arrow below the Table tool >> click on Excel Spreadsheet from the Insert Table dropdown.

Insert Excel Table into Word

  • Now, a new Excel worksheet will open inside the Word file. You can write your table data here.

  • You can also copy the table data from your previous Excel file.

  • Then, format this new table like the actual Excel table. Then, right-click on a cell of your new Excel table. And choose the Paste option from the dropdown list.

Thus, the table will be inserted into the Word. And, the result will look like this. 👇

Insert Excel Table into WordRead More: How to Copy Excel Table to Word with Gridlines


Things to Remember

  • You can edit the table inside the Word as your wish if you do not insert the table as a picture.
  • If you do not link your Excel while inserting, then your table will be static after insertion. But, if you link your Excel file while inserting, then the inserted table will automatically update if you update your Excel table.

Download Practice Workbook

Here, you can practice by downloading our workbook. It is given below:


Conclusion

These are the several ways to insert Excel tables into Word. I hope you find this information to be useful and educational. Please feel free to contact us if you have any further queries or recommendations.


Related Articles

<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Tanjim Reza
Tanjim Reza

Md. Tanjim Reza Tanim, a BUET graduate in Naval Architecture & Marine Engineering, contributed over one and a half years to the ExcelDemy project. As an Excel & VBA Content Developer, he authored 100+ articles and, as Team Leader, reviewed 150+ articles. Tanim, leading research, ensures top-notch content on MS Excel features, formulas, solutions, tips, and tricks. His expertise spans Microsoft Office Suites, Automating Finance Templates, VBA, Python, and Developing Excel Applications, showcasing a multifaceted commitment to the... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo