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.
How to Put a Large Excel Table into Word: 7 Easy Methods
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 car models with their tag price and final price.
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.
- In the Table option, select Insert Table through you can insert a table with your preferred row and column number.
- 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.
- 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.
- A Paste Special dialog box will appear. Select Unformatted Unicode Text and click on OK.
- 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.
Read More:Â How to Copy Excel Table to Word with Gridlines
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 Insert Excel Table into Word
3. Utilizing Large Excel Table as a Linked Object
In the previous method, we got a static solution. To eliminate this problem, we need a proper way to auto populate Word document from Excel. We found 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.
- A Paste Special dialog box will appear. Select Paste link.
- Now, select the Microsoft Excel Worksheet Object from the options. Finally, click on OK.
- There we have the desired result.
- 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.
Read More:Â How to Copy Table from Excel to Word
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.
- 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.
- 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.
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.
- 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.
Read More: How to Paste Excel Table into Word in Landscape
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.
- A Paste Special dialog box will appear. Select Paste link.
- 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.
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.
- This will open up the Excel table in Word.
Read More: How to Insert Excel Table into Word with Formulas
Download Practice Workbook
Download this practice workbook and the word file from below.
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 hope you enjoy the whole article and gain some valuable knowledge. If you have any questions, feel free to ask in the comment box.
Related Articles
- How to Paste Excel Table into Word Fit to Page
- How to Add Drop-Down List in Word from Excel
- How to Create Multiple Word Documents from Excel
<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
