How do I export data from a word document into excel?
Posted on 2014-12-02
I have many word documents in a fixed format. All documents have a set of 32 questions and their answers. The questions are identical across all documents and are in the same order, numbered from 1 to 32. The answers vary in length and formatting (some are blocks of text while some are bulleted lists). I want to automate the upload of this questionnaire into a web form and for that, I would like to export the data into excel. In excel, each question will be represented by one column. I am looking for a way to extract the answer to the first question and place it in Column A, 2nd question in Column B, and so on with one row representing one document. Can someone help?