Microsft 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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
3 Useful Methods to Export Data from Excel to Word
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 Monthly Laptop Sales Data for 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.
- 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.
- 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.
- If you want to keep the source formatting, select the first option. Your data will look exactly what it was in the excel file.
- 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, the data will be imported as text. 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 Copy from Excel to Word Without Losing Formatting (4 Easy Ways)
- How to Insert Merge Fields in Word from Excel
- Copy Table from Excel to Word (3 Easy Ways)
- How to Copy a Chart from Excel to Word (2 Easy Ways)
- Link Excel Cell to Word for Automatic Update
- How to Convert Excel to Word Labels (With Easy Steps)
2. Export Data from Excel to Word by Utilizing Object Insert Feature
Microsoft Word has a very useful Insert feature which we can use to insert various types of files including Excel. To know how to use this feature, follow the steps below.
- First, go to Insert Tab and click on Object from Text group.
- 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
- Now click on OK.
- 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.
- 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.
- 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 (5 Methods)
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.
- On MS Word, go to the Insert tab and click on Table, and select Excel Spreadsheet.
- As a result, an excel sheet will be embedded with the word file and you can perform any Excel task on the word file.
Read More: How to Paste Excel Table into Word Fit to Page
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.
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. Finally, please visit ExelDemy for more exciting articles on Excel.