Need Help importing data from Word to Excel?

Question

Say you wanted to create an excel spreadsheet that would import only very specific data from Microsoft word. For example, I have a list of over 50,000 Names, Addresses, phone numbers, and some other various information. I only want the Names, Addresses, and phone numbers to be exported from the Word document to and excel spreadsheet. Is that even possible to set up an excel sheet to perform a command like that?

Answer 1

You can simply copy and paste depending on how your data in MS Word is organized... if it is in a table, then the task would be very easy... even otherwise this could be done, but you need to give an example of how your word looks.
.

Answer 2

Piece of cake.

First, to be safe, I would make a copy of your Word data file and work with that. In this way, you would be covered if anything goes wrong.

In the copy -- and I'm assuming these are in tabbed column format -- delete the columns you do not want, leaving only those you want.

Control+A will select all these data. Edit, Copy.

Open a new Excel worksheet.
In cell A1, Paste.

Should read in. Give the file a name. Be sure to make note of the directory to which you are saving, the filename, and that the filetype (on the bottom) indicates "Excel worksheet."

Now you can go back and delete the temporary Word file which is no longer of use to you.

Answer 3

the proper way is to jot down CSV document The format of XLS document were replaced lots considering that 95, so write your records like this Head1, Head2, Head3, and so on Value1, Value2, Value3, and so on In an ASCII document utilising Open command like this Open Filename for output as #a million Write #a million, Fullline Then double click the document will run Excel even if it really is put in VBAXLMAn is the following to feed your Excel desires

Answer 4

Try this out
http://www.divorceplanner.com/webhelp/Divorce_Planner_2006/Utilities/Printing_Export_to_Word_Excel.htm
Alternatively, put your data in a table in the Word document and then cpoy the table and paste it into Excel sheet.

Answer 5

It would be much easier to make a backup and delete everything but the wanted infomation then import it