Automate data extraction from word to excel and then format into template

Copper Contributor

Hi,

I need to complete a manually intensive taks which requires me to manually copy information from a word document for it to be viewed and analised in excel.

Attached a sample of the word document with the headers and table data I'm extracting and an example of what this should look like in excel when extracted.

 

Is there a recommended method for extracting the data and headings into a template sheet with my desired format as shown in the sample?

 

At the moment I can copy all data from word into an excel sheet which I have added into the excel sample. But can i then automate the building of the template format based on the data I have pasted in?

 

Thanks in advance.

 

1 Reply

@studentjohn 

 

Yes, with limitations to Merged cells. see attached