help importing data from word file into excel

Hello,

I am trying to import data I have saved into word documents into excel. The data is in tables right now, but there is a lot of extra information I do not need. I will post a sample of the word document and what I would like the excel document to look like. I have about 100 similar word documents that it needs to be done to. The sample one just has 2 items, but some have hundreds of items. The layout is always the same, except sometimes the table has a hundred items in it under some of the tables and one or two items under another table. Thank you for taking a look at this for me. Cheers!

Originally Posted by snb

You can import those data directly from the websites.

No, you cannot. That is why I had to save the webpage as "webpage complete" and then choose "Edit with Microsoft Word" to get the information into Word at all.

Originally Posted by snb

hear, hear....

ahem...errrr.....sorry. What I meant was...How do you import it direct from the website? I couldn't figure out a way except to use the "Edit with Microsoft Word" option in my browser options. I didn't see anything in my browser or on the webpage to export the data into excel or csv or anything... Thank you for your time.

Can someone even tell me if this is possible to do easily? or would it be prohibitively time consuming? If anyone knows of an existing script or micro I can tweak, I would certainly be willing to give it a try. Thanks in advance for any help.

BBB

Originally Posted by snb

Use a webquery in Excel.
In E 2010 you can indicate which table you want to be retrieved from the site.

Please excuse my ignorance, but can you explain to me how to do a webquery? This is some very welcome information you have given me. I will try looking up "excel webquery" in google and see what I can find, but if you can easily explain it, I would be much obliged. Thanks for your help!


BBB

Well, this works pretty well. Is there any way to exclude certain parts of the table (such as the headers repeating for each similar table on a page an thus giving me a list that is broken up with duplicate headers? I am attaching a sample of what I was able to do with a webquery import. I would also like to eliminate a couple of the columns (such as FSC code and the column with the numbers (i.e. 1,2,3,4,5,6 etc) next to each item) from the import process, but this is a fantastic start. Thank you so much. Any other ideas for me? Thanks again!!!!! :D :D :D


BBB

Ok, I found a way to delete all the extraneous data from the workbook by using the "replace" feature and replacing the duplicate headers with blank cells...now how can I remove all blank cells from the columns to make one nice long continuous list?