If you want to transfer data from Excel to Word automatically, this article is for you. Here, we describe the 5 most effective methods that will help you to do the task effortlessly.
How to Transfer Data from Excel to Word Automatically: 5 Methods
The following Book List table shows the Author, Book, Genre, and Published Year Columns. We want to transfer this table from Excel to Word. Here, we used Excel 365. You can use any available Excel version.
Method -1: Using Copy and Paste Option to Transfer Data from Excel to Word Automatically
In this method, we will copy the data from Excel and paste it into Word.
➤ First of all, we will select the entire data range from the table Book List and right-click on it.
➤ After that, a context menu will appear, and select Copy.
We can also copy by using the keyboard shortcut CTRL+C.
➤ After that, we will open our Word file > right-click > click on the red marked box from the Paste Options.
We can also type CTRL+V to paste the data.
Finally, we can see the table in Word.
Read More: How to Copy from Excel to Word Without Losing Formatting
Method-2: Using Paste Special Option
In this method, we will use the Paste Special option to paste data from Excel to Word.
➤ First of all, we will select the entire dataset > right-click > select Copy from the context menu.
➤ Afterward, we will open our Word document > click on the down arrow which is in the Paste box.
We can see several paste options appear.
➤ After that, select Paste Special.
A Paste Special window will appear.
Select As as Microsoft Excel Worksheet Object > click OK.
Finally, we can see the table in the Word file.
Read More: How to Export Data from Excel to Word
Method -3: Using Copy as Picture Option to Transfer Data from Excel to Word Automatically
In this method, we can copy the data as a picture, and therefore, the data is not editable in Word.
➤ First of all, we will select the entire dataset > go to the Home tab > click on Copy > select Copy as Picture.
A Copy Picture window will appear.
➤ Keep Appearance and Format as it is, Click OK.
➤ After that, we will open our Word file > click on the down arrow of the Paste box > select Paste Special.
A Paste Special window will appear.
➤ Click OK.
Finally, we can see the data in the Word file.
Read More: How to Copy and Paste from Excel to Word Without Cells
Method-4: Using Insert Excel Object Option
We can insert data from Excel to Word directly. Let’s see that option in this section.
➤ First of all, we will open our Word file > go to the Insert tab.
➤ After that, we will click on Object > select Object option.
An Object window will appear.
➤ We will select Create from File > click on Browse to give the location of the Excel file.
➤ Here, we selected our desired Excel file and clicked on Insert.
After that, we will see the Object widow again.
➤ Now, we will click OK.
Finally, we can see the table from Excel to Word.
Method-5: Import Text From a Text File to Microsoft Word Document
In this method, we can import text only to Word from an Excel CSV file.
➤ First of all, we will open our Word document > go to the Insert tab.
After that, we will click on Object > select Text from File.
➤ Now, we will select our required CSV file, we have to select the All Files option to find out the CSV file.
➤ Click on Insert.
Afterward, a File Conversion window will appear.
We can see the preview and the CSV file type in the window.
➤ Click OK.
After that, we can see the data in the Word file. However, we have to re-arrange this dataset for better understanding.
Finally, after manually re-arranging the dataset we can see the data in Word file.
Read More: How to Copy Only Text from Excel to Word
Download Workbook
Conclusion
Here, we tried to show you 5 methods to transfer data from Excel to Word automatically. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, feel free to contact us in the comment section.
Related Articles
- How to Extract Data from Excel to Word
- How to Link Excel Cell to Word for Automatic Update
- How to Insert an Excel Spreadsheet into Word
- How to Copy a Chart from Excel to Word
<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
