Hi everyone! I wasn't sure if this was even possible.
I have about 1,000 Word documents that are free-form text (not data tables or form fields) that I am looking to extract into Excel, instead of a manual copy/paste. There is basic structure to the Word document, but bullet points may vary (sometimes there are 2, sometimes there are 10).
I am hoping for a column on each line that I list here, although I'd like the bullet points in their own respective columns as well if possible (I could always put in the last columns of Excel and then move them later since the column numbers will vary for the bullet points.)
Any thoughts on if this is even possible without manually cutting/pasting the information from Word to Excel? Example from word listed below---
Program: xxx
Description: abc
Bulleted List Description:
Misc Text paragraphs that I don’t want extracted
Category: text paragraph here that may vary in length but could put into 1 column in Excel
I have about 1,000 Word documents that are free-form text (not data tables or form fields) that I am looking to extract into Excel, instead of a manual copy/paste. There is basic structure to the Word document, but bullet points may vary (sometimes there are 2, sometimes there are 10).
I am hoping for a column on each line that I list here, although I'd like the bullet points in their own respective columns as well if possible (I could always put in the last columns of Excel and then move them later since the column numbers will vary for the bullet points.)
Any thoughts on if this is even possible without manually cutting/pasting the information from Word to Excel? Example from word listed below---
Program: xxx
Description: abc
Bulleted List Description:
- Bullet point 1
- Bullet point 2
- Bullet point 3
Misc Text paragraphs that I don’t want extracted
Category: text paragraph here that may vary in length but could put into 1 column in Excel
