How to Export Data from Excel to Word (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel and Word are two very useful office software when it comes to calculating data and storing it. And many times due to various reasons such as representation or printing purposes we need to export data from Excel to Word. In this article, I will discuss how to export data from Excel to Word.


How to Export Data from Excel to Word: 3 Useful Methods

In this section, we will demonstrate 3 effective methods to export data from Excel to Word. To illustrate, we have taken an Excel file where the data of Monthly Laptop Sales of X Company is shown.

On the other hand, we have a Word file where we want to export data from the Excel file.

Now, we will try to export data from an Excel file to a Word file. Let’s try our first method.


1. Use of Copy Paste to Export Data from Excel to Word

This is a very easy and quick option to export data from Excel to Word. Let’s explore how it works.

Steps:

  • First, copy the data that you want to export from Excel. To do that, select the data then right-click on the mouse. From the appeared menu, select Copy. Alternatively, you can just type Ctrl+C to do the same.

Use of Copy Paste to Export Data from Excel to Word

  • Now go to the Word file and right-click on the mouse where you want to paste the data. Consequently, a menu will appear from where you will see many paste options.

Use of Copy Paste to Export Data from Excel to Word

Use of Copy Paste to Export Data from Excel to Word

  • If you select the Use Destination Styles, your data representation format will be converted to the existing Word file format.

  • If you select Link & Keep Source Formatting, the data will be displayed in Excel format. In addition to that, it will be linked to the original Excel file. In other words, if you change anything in your original Excel file, it will be reflected in this Word file too.
  • If you select Link & Use Destination Styles, the data will be connected like the previous one but the representational format will be according to the word file.
  • If you select the Picture option, the data will be added as a picture captured from the Excel file. You can resize the picture but can’t edit the data if you want.
  • If you select Keep Text Only, only the texts will be imported from Excel to Word. So no table will be generated like Excel.

  • Here the columns are separated with tabs and rows are separated with a line gap.

Read More: How to Extract Data from Excel to Word


2. Export Data from Excel to Word by Utilizing Object Insert Feature

Microsoft Word has a very useful Insert feature that we can use to insert an Excel Spreadsheet into Word. To know how to use this feature, follow the steps below.

Steps:

  • First, go to Insert Tab and click on Object from Text group.

Export Data from Excel to Word by Utilizing Object Insert Feature

  • A new window will appear named Now, go to Create from File tab and then click on Browse to choose the Excel file you want to import.

  • From the browse window, I have selected the “Exporting Data to Word” file and clicked

Export Data from Excel to Word by Utilizing Object Insert Feature

  • Now click on OK.

Export Data from Excel to Word by Utilizing Object Insert Feature

  • Consequently, your inserted data from the Excel file will look like this in Word.

  • You can left-click double on the object and you will be able to edit the data if you want.

Export Data from Excel to Word by Utilizing Object Insert Feature

  • On the Object window, there are a couple of more options. If we click on Link to File, the inserted file will be linked and if we change anything from the main file, it will be reflected on the Word file as well. Moreover, if you double-click on the object, the main excel fill will be opened.

Export Data from Excel to Word by Utilizing Object Insert Feature

  • On the other hand, if we click on Display as Icon, the file will be displayed as an icon but the content will not be there to display.

Read More: How to Transfer Data from Excel to Word Automatically


3. Insertion of Excel Table into Word to Export Data from Excel to Word

If you just want to create an Excel table inside MS Word, there is an elegant way to do it. This is very helpful when you are unable to open Word and Excel files simultaneously due to a shortage of computer memory. Follow the steps below.

Steps:

  • On MS Word, go to the Insert tab, click on Table, and select Excel Spreadsheet.

Insertion of Excel Table into Word to Export Data from Excel to Word

  • As a result, an Excel sheet will be embedded with the Word file and you can perform any Excel task on the Word file.

Insertion of Excel Table into Word to Export Data from Excel to Word

Read More: How to Insert Excel Table into Word


Things to Remember

  • The 1st Option is very quick and you should only use it when you only need to export a portion of an Excel file to Word.
  • If you need to export an entire Excel file content to Word, the 2nd option is the best one.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

That is the end of this article. If you find this article helpful in understanding how to export data from Excel to Word, please share this with your friends. Moreover, do let us know if you have any further queries.


Export Excel to Word: Knowledge Hub

<< Go Back to Export Data from Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aniruddah Alam
Aniruddah Alam

Md. Aniruddah Alam, a graduate of Bangladesh University of Engineering & Technology, Dhaka, holds a BSc.Engg in Naval Architecture & Marine Engineering. Joining Softeko in August 2022 as an Excel and VBA content developer, he has authored 90+ articles, covering fundamental to advanced Excel topics. He actively develops VBA codes for Excel automation and offers solutions in the Exceldemy Forum. Beyond work, he finds leisure in reading books, and taking relaxing walks, showcasing well-rounded blend of professional and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo