Importing Word Content into Excel

[littlejilly]

Hi all,

I have hundreds of word documents. I would like to extract the contents from the word documents and add them into excel with each cell in a single representing a unique word document.

For example, B1 would represent word doc 1
B2 would represent word doc 2
....
...
.
B897 would represent word doc 987.

I do have hundreds of word document making a manual process one that is incredibly inefficient. Any thoughts on how I could execute this?

I can say that each word document does follow consistent formatting but are not set up with any heads.

Thanks!
Jillian

 

[Rijnsent]

Hi Jillian,
you can definitely make your life easier with some VBA code for that. See e.g. this post (needs adaption for your situation): https://www.mrexcel.com/forum/excel...-through-multiple-word-files.html#post3640153
Are all of your 800+ files in one directory? And is there some structure to the contents of the file - as in: what would you like to find/extract from those word files?
Cheers,
Koen