How to Transfer Data from Excel to Word Automatically (5 Methods)
to Transfer Data from Excel to Word Automatically" width="795" height="415" />
The following Book List table shows the Author, Book, Genre, and Published Year Columns. We’ll transfer this table from Excel to Word.
Method 1 – Using the Copy and Paste Option to Transfer Data from Excel to Word Automatically
- Select the entire data range from the table Book List and right-click on it.
- A context menu will appear. Select Copy. You can also use the keyboard shortcut Ctrl + C.
- Open the Word file.
- Click where you want to insert the table.
- Right-click and select Paste (A) the Paste Options. You can also use the Ctrl + V keyboard shortcut.
- You can see the table in Word.
to Transfer Data from Excel to Word Automatically" width="806" height="697" />
Method 2 – Using the Paste Special Option
- Select the entire dataset and copy it.
to Transfer Data from Excel to Word Automatically" width="726" height="460" />
- Open the Word document.
- Click on the arrow under the Paste box.
- Select Microsoft Excel Worksheet Object from the list and click OK.
to Transfer Data from Excel to Word Automatically" width="787" height="489" />
- You’ll see the table in the Word file.
to Transfer Data from Excel to Word Automatically" width="806" height="697" />
Method 3 – Using the Copy as Picture Option to Transfer Data from Excel to Word Automatically
- Select the entire dataset.
- Go to the Home tab, click on Copy, and select Copy as Picture.
to Transfer Data from Excel to Word Automatically" width="799" height="616" />
- A Copy Picture window will appear. Keep Appearance and Format as-is and click on OK.
- Open the Word file.
- Click on the down arrow of the Paste box and select Paste Special.
- Click OK in the Paste Special dialog box.
to Transfer Data from Excel to Word Automatically" width="806" height="697" />
Method 4 – Using the Insert Excel Object Option
- Open the Word file and go to the Insert tab.
- An Object window will appear. Select Create from File and click on Browse.
- Find the Excel file and click on Insert.
to Transfer Data from Excel to Word Automatically" width="806" height="697" />
Method 5 – Import Text from a CSV File to Microsoft Word Document
- Open the Word document and go to the Insert tab.
- Select the CSV file by clicking on the All Files option to find the CSV file in the folder.
- Click on Insert.
- A File Conversion window will appear. You can see the preview and the CSV file type in the window. Click on OK.
to Transfer Data from Excel to Word Automatically" width="731" height="410" />
- You can see the data in the Word file, but it needs to be rearranged.
- We created a table manually and pasted the data to make it presentable.
to Transfer Data from Excel to Word Automatically" width="763" height="735" />
Download the Workbook
Transfer Data from Excel to Word.xlsx
