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.


Download Practice Workbook

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


8 Easy Ways to Insert Excel Table into Word

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 Cntrl + 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 tab 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 from Excel to Word Without Losing Formatting (4 Easy Ways)


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 (7 Easy Methods)


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 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


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. πŸ‘‡


Similar Readings


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, 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 at 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


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 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 Word


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.

Conclusion

These are the several ways for inserting 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. For many more articles like this, visit exceldemy.com.


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo