How to Put a Large Excel Table into Word (7 Easy Methods)

As a regular Excel user, sometimes you may need to put a large table into word. There is no in-build system through which you can convert an Excel table into word. In this article, we will focus on how to put a large Excel table into word effectively. I hope you enjoy the whole article and gain some valuable knowledge.


Download Practice Workbook

Download this practice workbook and the word file from below.


7 Easy Methods to Put a Large Excel Table into Word

To put a large Excel table into word, we find out the seven most useful and user-friendly ways through which you can solve the mentioned problem. To show all the methods, you need to have an excel file with a large dataset or you can create it now. We take a dataset that includes some cars model with their tag price and final price.

Put a Large Excel Table into Word


1. Put a Large Excel Table into a Pre-Made Table in Word

In the first method, we need to create a table in word and then insert the excel table value in it. This method is really easy to use. To use this method, you need to follow the following steps.

Steps

  • First, open the Excel file from where you want to take the Excel table.
  • Select the data table from your Excel.

  • Right-click on it and an options dialog box will pop up. From there, select the Copy option.

  • Now, open a new Microsoft Word document.
  • Select the Insert tab in the ribbon. Select Table from Tables group.

Put a Large Excel Table into Word

  • In the Table option, select Insert Table through you can insert a table with your preferred row and column number.

Put a Large Excel Table into Word

  • An Insert Table dialog box will pop up. In the Table size section, change the Number of columns and Number of rows according to your dataset. Set the Fixed column width as Auto. Finally, click on OK.

Put a Large Excel Table into Word

  • It will eventually create a table with 7 columns and 10 rows. Now, select the whole table.

  • Go to the Home tab in the ribbon and select Paste from the Clipboard group.

  • From the Paste option select Paste Special.

Put a Large Excel Table into Word

  • A Paste Special dialog box will appear. Select Unformatted Unicode Text and click on OK.

Put a Large Excel Table into Word

  • Now, you can see all the copied data are placed in the pre-made table in word and look exactly the same as the Excel worksheet.

Put a Large Excel Table into Word

Read More: How to Copy from Excel to Word Without Losing Formatting (4 Easy Ways)


2. Paste Excel Table as a Plain Text into Word

Secondly, in this method, you can copy your Excel table and paste it as plain text. A major drawback of this method is that it will provide a static solution where you can change any data in your Excel but that doesn’t affect the table in word format.

Steps

  • Open the Excel dataset. Select the data table from your Excel.

  • Right-click on it and an options dialog box will pop up. From there, select the Copy option.

  • Now, open the Microsoft Word document.
  • Go to the Home tab in the ribbon and select Paste or use ‘Ctrl+V’ as a keyboard shortcut.

  • That will give us a static solution. If you want to change any data, you need to do it manually.

Read More: How to Copy Only Text from Excel to Word (3 Quick Methods)


3. Utilizing Large Excel Table as a Linked Object

In the previous method, we got a static solution. To eliminate this problem, we find out a method based on the linked object where you copy and paste an Excel table into word but if you change any data in Excel, it will automatically change it in the word table. But you need to have both files because if you give the word file to someone, he can’t use it without the linked Excel file.

Steps

  • Select the Excel dataset table.

  • Right-click on it and an options dialog box will pop up. From there, select the Copy option.

  • Now, open a new Microsoft Word document. Go to the Home tab in the ribbon and select Paste from the Clipboard group.

  • From the Paste option select Paste Special.

Put a Large Excel Table into Word

  • A Paste Special dialog box will appear. Select Paste link.

Put a Large Excel Table into Word

  • Now, select the Microsoft Excel Worksheet Object from the options. Finally, click on OK.

  • There we have the desired result.

Put a Large Excel Table into Word

  • Now, if you double-click on the table, it will open up the original Excel file. It provides a dynamic solution. To show this dynamic solution, change any cell value in your original dataset in Excel. We change cell G5 value from $23000 to $24000.

  • Go to the Word document. Right-click on the table and select Update Link.

  • This will change the dataset according to your alternation of the original Excel data table.

Put a Large Excel Table into Word


Similar Readings


4. Enabling Excel Interface

In the previous method, you need to have both Excel and Word files to access. This method will eliminate this problem and it will embed the Excel table in Word.

Steps

  • Select the Excel dataset table.

  • Right-click on it and an options dialog box will pop up. From there, select the Copy option.

  • Now, open a new Microsoft Word document. Go to the Home tab in the ribbon and select Paste from the Clipboard group.

  • From the Paste option select Paste Special.

Put a Large Excel Table into Word

  • A Paste Special dialog box will appear. Select the Paste option.

  • Now, select the Microsoft Excel Worksheet Object from the options. Finally, click on OK.

Put a Large Excel Table into Word

  • There we have our desired result.

  • Now, if you double-click on the table, it will open up the Excel file in the word interface. You will get the Excel interface there and can easily change any data which will reflect in the word document table.

Put a Large Excel Table into Word

Note

The biggest advantage of using this method is that there is no need to think about two separate Excel and Word files.


5. Put Large Excel Table into Word as a Static Image

If you are doing any report where you need some random large Excel table in Word without any alteration, you can use this method.

Steps

  • Select the Excel dataset table.

  • Right-click on it and an options dialog box will pop up. From there, select the Copy option.

  • Now, open a new Microsoft Word document. Go to the Home tab in the ribbon and select Paste from the Clipboard group.

  • From the Paste option select Paste Special.

Put a Large Excel Table into Word

  • A Paste Special dialog box will appear. Select the Paste option.

  • Select Picture(Enhanced Metafile) from the options. Then click on OK.

  • This will give a static solution.


6. Using Linked Image

To have the flexibility of managing images in Word, you can link it to the original Excel dataset. This method will show you step by step procedure for it.

Steps

  • Select the Excel dataset table.

  • Right-click on it and an options dialog box will pop up. From there, select the Copy option.

  • Now, open a new Microsoft Word document. Go to the Home tab in the ribbon and select Paste from the Clipboard group.

  • From the Paste option select Paste Special.

Put a Large Excel Table into Word

  • A Paste Special dialog box will appear. Select Paste link.

Put a Large Excel Table into Word

  • Select Picture(Enhanced Metafile) from the options. Then click on OK.

  • This will provide the required image which is linked with the original Excel file.

Put a Large Excel Table into Word

Note

If you share the Word file with someone, then make sure you share the linked Excel file only. Otherwise, it will act as a regular image.


7. Utilizing Object Command

Our last method is based on using object command. You can insert the Excel file using this method.

Steps 

  • In Microsoft Word, go to the Insert tab in the ribbon, and there is a Text group to use.

  • From the Text group, select the Object command.

  • An Object dialog box will appear. Select Create from File and Browse the Excel file from your computer and then click on OK.

Put a Large Excel Table into Word

  • This will open up the Excel table in Word.


Conclusion

We have shown the seven most useful methods to put a large Excel table into Word. All seven methods are fairly easy to understand. I wish you enjoy the whole article and gain some valuable knowledge. If you have any questions, feel free to ask in the comment box, and don’t forget to visit our Exceldemy page.


Related Articles

Durjoy Paul

Durjoy Paul

Hi there! I'm Durjoy. I have completed my graduation from the Bangladesh University of Engineering and Technology. I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo