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’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.
- Select the entire dataset and copy it.
- Open the Word document.
- Click on the arrow under the Paste box.
- Select Microsoft Excel Worksheet Object from the list and click OK.
- You’ll see the table in the Word file.
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.
- 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.
- You’ll see the table embedded as an image in the Word file. This means the data inside can’t be edited.
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.
- The table will be copied from Excel to Word.
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.
- 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.
Download the Workbook
Transfer Data from Excel to Word.xlsx
