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.
Download Practice Workbook
You can download the free Excel template from here and practice on your own.
4 Ways to Extract Data from Excel to Word
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 Extract Specific Data from a Cell in Excel (3 Examples)
2. Insert Excel Object to Extract Data from Excel to Word
Here, we’ll use the Object command in the Word app 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 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.
Now have a look that the data from the Active Sheet is extracted.
Read More: How to Import Data into Excel from Another Excel File (2 Ways)
Similar Readings
- How to Import Text File with Multiple Delimiters into Excel (3 Methods)
- How to Import Data from Secure Website to Excel (With Quick Steps)
- Transfer Data from One Excel Worksheet to Another Automatically with VLOOKUP
- How to Convert Notepad to Excel with Columns (5 Methods)
- How to Extract Data from Image into Excel (With Quick Steps)
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.
Read More: How to Extract Data From Table Based on Multiple Criteria 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 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.
Read More: Import Data from Excel into Word Automatically Using VBA (2 Ways)
Practice Section
You will get a practice sheet in the Excel file given above to practice the explained ways.
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
- Excel Macro: Extract Data from Multiple Excel Files (4 Methods)
- How to Pull Data from Multiple Worksheets in Excel VBA
- How to Extract Year from Date in Excel (3 Ways)
- Extract Text After a Character in Excel (6 Ways)
- How to Extract Month from Date in Excel (5 Quick Ways)
- Excel Formula to Get First 3 Characters from a Cell(6 Ways)