For many purposes, we need to extract data from Excel to MS Word. There are several ways to do that. But in this article, I’ll show 4 quick and useful methods to extract data from Excel to Word with sharp steps and clear screenshots.
How to Extract Data from Excel to Word: 4 Ways
Let’s get introduced to our dataset first that represents some Salespersons’ sales in two consecutive Months and Total Sales.
1. Using Paste Special to Extract Data from Excel to Word
In our very first method, we’ll use Paste Special to extract the dataset from Excel to Word.
Steps:
- Select the data range. Here, I selected the range B4:E11.
- Then copy it by using the Ctrl + C
- Now open a new Word file and click as follows: Paste > Paste Special.
Soon after, a dialog box will open up.
- Later, mark the Paste link.
- Then select Microsoft Excel Worksheet Object from the As: box and press OK.
Or you can choose any desired format from the As: box as shown in the image below.
Soon after you will get the extracted data in the Word file.
Read More: How to Export Data from Excel to Word
2. Insert Excel Object to Extract Data from Excel to Word
Here, we’ll use the Object command in Word to extract data from Excel.
Steps:
- Keep the sheet active from which you want to extract data.
- After that open a doc file and click as follows: Insert > Text > Object > Object.
- After appearing in the dialog box of Object, click on Create from File and then press Browse.
- Select your file from the file explorer and press OK and it will take you back to the previous dialog box.
- At this moment, just press OK.
Thus, we have inserted data from the Excel Spreadsheet into Word.
Read More: How to Transfer Data from Excel to Word Automatically
3. Inserting a Blank Excel Table to Extract Data from Excel to Word
You can easily insert a blank Excel table into the Word app and then you can work there like working in Excel. It will seem that you are using Excel. Let’s see how to do it.
Steps:
- Open a new Word file.
- Then click as follows: Insert > Table > Excel Spreadsheet.
Now see that an Excel window is opened in the Word file. Now you can do anything as you did in Excel.
4. Do Mail Merge from Excel to Word
Finally, we’ll learn an amazing feature of Excel and Word. For that, I have modified the dataset, it contains the Salespersons’ Last Names, Addresses, and Emails.
Then I have opened a new doc file and wrote a letter to send to the salespersons. Now we’ll extract the Address, Email, and Last Name from the Excel file.
Steps:
- First, click as follows in the Word app: Mailings > Start Mail Merge > Letters.
- Later, click Select Recipients > Use an Existing List.
- Select the Excel file and press Open.
- Then select the specific sheet and press OK.
- After that click on the Match Fields from the Mailings tab.
- By pressing the drop-down icon from any field you can choose the related header name of your Excel file if Excel failed to set it automatically.
Now let’s add the address.
- Keep the cursor where you want to get the address.
- Then click on the dropdown icon from the Insert Merge Field.
- Select Address.
See that the Address is added successfully.
- In the same way, add the Email id.
- And add the last name after “Dear” in the letter.
Now see that the letter is filled with the specific fields for the first salesperson. If you press the Next button the same letter will be shown for the next salesperson.
The same letter is for the next salesperson.
You can print them or send Emails too.
- For that, click on Finish & Merge and then select your desired option Print Documents or Send Email Messages.
Practice Section
You will get a practice sheet in the Excel file given above to practice the explained ways.
Download Practice Workbook
You can download the free Excel template from here and practice on your own.
Conclusion
I hope the procedures described above will be good enough to extract data from Excel to Word. Feel free to ask any question in the comment section and please give me feedback.
Related Articles
- How to Copy Only Text from Excel to Word
- How to Copy from Excel to Word Without Losing Formatting
- How to Copy a Chart from Excel to Word
- How to Link Excel Cell to Word for Automatic Update
- How to Copy and Paste from Excel to Word Without Cells
- How to Insert an Excel Spreadsheet into Word
<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!