I have multiple word documents (over 100 files) that I want to import and map to a single excel sheet. Currently, the excel sheet has fields across (columns) and the rows should be the data from the word documents (each file representing one row). My word documents are not currently formatted in any particular way. They are plain word documents with a table that has text/data that needs to be mapped across to the specific fields in the excel sheet.
I'm wondering what's the best way to prepare the multiple word documents for importing where the fields can be mapped from word document to excel sheet?
