How to Extract Data from Excel to Word (4 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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

Use Paste Special to Extract Data from Excel to Word

  • Now open a new Word file and click as follows: Paste > Paste Special.

Soon after, a dialog box will open up.

Use Paste Special to Extract Data from Excel to Word

  • 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.

Insert Excel Object to Extract Data from Excel to Word

  • After that open a doc file and click as follows: Insert > Text > Object > Object.

Insert Excel Object to Extract Data from Excel to Word

  • After appearing the dialog box of Object, click on Create from File and then press Browse.

Insert Excel Object to Extract Data from Excel to Word

  • 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.

Insert Excel Object to Extract Data from Excel to Word

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


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.

Insert a Blank Excel Table to Extract Data from Excel to Word

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.

Do Mail Merge from Excel to Word

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.

Do Mail Merge from Excel to Word

Steps:

  • First, click as follows in the Word app: Mailings > Start Mail Merge > Letters.

Do Mail Merge from Excel to Word

  • Later, click Select Recipients > Use an Existing List.

Do Mail Merge from Excel to Word

  • Select the Excel file and press Open.

Do Mail Merge from Excel to Word

  • Then select the specific sheet and press OK.

Do Mail Merge from Excel to Word

  • After that click on the Match Fields from the Mailings Tab.

Do Mail Merge from Excel to Word

  • 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.

Do Mail Merge from Excel to Word

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.

Do Mail Merge from Excel to Word

See that the Address is added successfully.

  • In the same way, add the Email id.

Do Mail Merge from Excel to Word

  • And add the last name after Dear in the letter.

Do Mail Merge from Excel to Word

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.

Do Mail Merge from Excel to Word

The same letter for the next salesperson.

Do Mail Merge from Excel to Word

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

Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is an amazing software to learn or work. Here, I will post Excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo