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.
- 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 copy from Excel to Word without losing 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, 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.
- 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.
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, 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 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.
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
- Copy a Chart from Excel to Word
- Link Excel Cell to Word for Automatic Update
- Copy and Paste from Excel to Word Without Cells
- Copy Only Text from Excel to Word
- Put a Large Excel Table into Word
- Auto Populate Word Document from Excel
- Create Multiple Word Documents from Excel
- Insert Excel Table into Word with Formulas
- Paste Excel Table into Word in Landscape