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

%3CLINGO-SUB%20id%3D%22lingo-sub-2580481%22%20slang%3D%22en-US%22%3EAutomate%20data%20extraction%20from%20word%20to%20excel%20and%20then%20format%20into%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2580481%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20need%20to%20complete%20a%20manually%20intensive%20taks%20which%20requires%20me%20to%20manually%20copy%20information%20from%20a%20word%20document%20for%20it%20to%20be%20viewed%20and%20analised%20in%20excel.%3C%2FP%3E%3CP%3EAttached%20a%20sample%20of%20the%20word%20document%20with%20the%20headers%20and%20table%20data%20I'm%20extracting%20and%20an%20example%20of%20what%20this%20should%20look%20like%20in%20excel%20when%20extracted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20recommended%20method%20for%20extracting%20the%20data%20and%20headings%20into%20a%20template%20sheet%20with%20my%20desired%20format%20as%20shown%20in%20the%20sample%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20the%20moment%20I%20can%20copy%20all%20data%20from%20word%20into%20an%20excel%20sheet%20which%20I%20have%20added%20into%20the%20excel%20sample.%20But%20can%20i%20then%20automate%20the%20building%20of%20the%20template%20format%20based%20on%20the%20data%20I%20have%20pasted%20in%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2580481%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2581989%22%20slang%3D%22en-US%22%3ERe%3A%20Automate%20data%20extraction%20from%20word%20to%20excel%20and%20then%20format%20into%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2581989%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111145%22%20target%3D%22_blank%22%3E%40studentjohn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20with%20limitations%20to%20Merged%20cells.%20see%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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