Importing from Word to Excel

manic111 · 16 Apr 2020 at 10:58

Hi all.

I've got a folder of Word documents all of which are in table format (they copy/paste to Excel perfectly, but obviously it's time consuming).

Is there any way to automatically import them into Excel, ideally each table into a separate tab, and to name the tabs the file name of the corresponding Word doc?

Thanks!

Hades · 17 Apr 2020 at 09:27

Do you know python?

Using some external modules python can create excel spreadsheets. A quick google also suggests there are ways for python to read word documents. So this is probably what I would look at. However if you don't know python then the effort to learn everything would probably outweigh the effort in doing it manually.

chroniclard · 17 Apr 2020 at 10:01

Depending how many there are it is probably quicker to do it manually rather than spend a while coding something.

(Maybe not if there are hundreds of them)

gpuerrilla · 23 Apr 2020 at 20:28

First save your Word files as web pages (HTML) into one directory. In Excel, Data > Get Data > From File > From Folder >

Paste the folder path exactly as explorer has it in the Folder Path dialogue box.

Now you can use Power Query to tidy and automate it into one large data set.