How to Transfer Data from Excel to Word Automatically (5 Methods)

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.

Download Workbook

5 Methods to Transfer Data from Excel to Word Automatically

The following Book List table shows 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.

How to Transfer Data from Excel to Word Automatically


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 to Word.

➤ First of all, we will select the entire data range from the table Book List > 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.

How to Transfer Data from Excel to Word Automatically

Read More: How to Copy and Paste from Excel to Word Without Cells (2 Quick Ways)


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.

How to Transfer Data from Excel to Word Automatically

➤ 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.

How to Transfer Data from Excel to Word Automatically

Finally, we can see the table in the Word file.

How to Transfer Data from Excel to Word Automatically

Read More: How to Paste Excel Table into Word in Landscape (3 Easy Ways)


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.

How to Transfer Data from Excel to Word Automatically

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.

How to Transfer Data from Excel to Word Automatically

Read More: How to Convert Excel to Word Labels (With Easy Steps)


Similar Readings


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.

How to Transfer Data from Excel to Word Automatically

Read More: How to Insert Excel Table into Word (8 Easy Ways)


Method-5: Import Text From a Text File or Microsoft Word Document

In this method, we can import data 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.

How to Transfer Data from Excel to Word Automatically

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.

How to Transfer Data from Excel to Word Automatically

Read More: How to Auto Populate Word Document from Excel (with Quick Steps)


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 know us in the comment section.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo