Preparation for importing multiple word documents to excel

[jw2022]

I have multiple word documents (over 200 individual word files), that I need to import to an excel spreadsheet. The excel sheet is already populated with specific fields (columns) that the data from the word documents needs to be mapped to. However, the word file is not really prepared in any particular way. I'm wondering what's the best way forward to map the data in word to the specific fields in excel and then automate the process to import multiple files.

Currently, the word files are formatted in a table, but not using a form, it's just plain text within the table. Each column is supposed to map to a different field in the excel spreadsheet and all the word files have the same table format.

What's the best way format to map for importing and then import multiple files?

 

[NdNoviceHlp]

Hi jw2022. Here's a general outline that may help. Dave

Loop through all word documents in a folder, and extract tables and reformat and paste them in excel

Hello, I need a bit help with the below request. I need to loop through all word documents in a given folder, probably about 30-50 word documents. Each one has the same template, and I need to extract information from the first and second tables from each word document. The two tables look like...

www.mrexcel.com