Excel to Word form


Could you please let me know how to fill a form in word document by reading data from excel. Excel file contains list of student names, gender, section etc…

Below is the word document which needs to be filled.


  1. Create one word template file. Write some dummy text in place of text you want to update it from Excel file.

  2. Next use Read Range activity to read the text Excel file and it will give output as DataTable.

  3. Then use For Each Row activity to iterate DataTable.

    a. Use Copy File activity to copy word template to some location.

    b. Then use Replace Text activity and replace that dummy text with Excel file data and this activity should be inside Word Application Scope activity.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.