Integrate excel data into word document

Most of the time we come across the scenario that we have complex data in Microsoft excel spread sheet and we want to copy some or more data cell into word from excel. We do copy and paste it manually, but think if we need to do it on regular basis, what we do?  We needs to think about automation between excel to word data integration. So how can we do that? This article will explain you about to how to import excel data into word or export excels data to word document automatically.

 

So here is the data of employee for salary in excel. We want that data integrated into word without copy paste manually. 

Step 1: Create word template in which we want to be integrate from excel, please see the below screenshot for salary slip, this will be a word template for every time use in future.

Step 2: Create Excel template from which data to be imported to integrate into word template as per cell required in word template. Please see the below excel template.

Step 3: Get the value of this field by any method(i.e. Vlookup) from excel data generated by payroll system. For this see below screenshot.

Step 4: Copy data for Employee Name from excel cell, Please see below screenshot.

Step 5: Place the cursor at Employee Name in word document where actually we want data to be integrated and press Ctrl+Alt+V(Paste special). Please see below screenshot.

 Step 6: Select Paste Link option button as Unformatted Text and press OK. Please see the below screenshot.

Step 7: Do it(Step 4 to step 6) for all fields of word for which we want to be integrate data from excel.

we will get finish product which will look like below.

For any help regarding this process, feel free to write in comment.