Converting a word document to excel.?

Question

Okay, so I have about 35 word documents that have many addresses on them. I need to get these addresses onto the excel document with columns - Name, Street, City, State, Zipcode.

I know that there is a way to get the excel stuff to word, and what i'm wondering is if there is a quick and easier way(than typing it out) to get the stuff on word onto the stuff on excel.

I think its called data merging or something...

Anyways, any sort of help/links would be EXTREMELY appreciated. Thanks soooo much guys.

the word document is just typed out.

its in columns (not a table) with about 7 addresses per column.

the addresses are like:

Fake General Motors
9256 Fake Street
Fake Ciy, CA 99999

Answer 1

First save your word file as a text file

Open excel and import that file (open that file just like you open an excel file)

Select "Fixed width" and then "Next"

Create columns with black lines

Click "Ok/Finish"

Then select all of them and copy

Paste special "Transpose"

Create headings (Name, Street, City, State, Zipcode) for the first 5 columns and copy that , then select the entire header line, paste. It will get copied to all the columns. (this is not necessary if you can identify the columns easily)

Since you have duplicate header columns, copy each set separately using clipboard and paste all.

Hope this will help.

Answer 2

Can't really understand the rationale behind this. Word is for text mainly, Excel for figures but if you are converting it to a database, is it perhaps a list of names and addresses. Whatever, 200 words is not much at all so copy and paste would only take a moment then the time is taken splitting it into different cells to make the fields. However, if you open Excel, go up to Data, Import External Data and across to Import Data and browse to find your Word document then follow the instructions it should go into separate cells. Again though depending on what you are trying to achieve you might still need to do a bit of fiddling around. Once you've sorted into appropriate fields, its then a question of opening Access, creating a blank database then up to File, External Data and using either the import or link options.

Answer 3

If your address information in word document is in a table and all the word documents has the same columns order for the address information. You could do a copy operation in word and do a paste operation in excel.

Answer 4

If your text is in tables in Word, you can simply copy it and paste it into Excel. Each table cell will paste into an Excel cell.

If your text is in tabbed columns, suggest you convert it to a table with the built in Word feature to do that, then copy and paste.

Answer 5

Converting Word to Excel

Here is a free app that will allow you to convert from Excel to Word

ABC Amber Word2Excel Converter is an advanced utility which helps you convert tables from DOC (MS Word) files to XLS (MS Excel) easily and quickly.

The software supports a batch conversion, a run from command line, more than 50 languages. Batch conversion ability allows you to convert a unlimited number of DOC files at a time.

http://www.processtext.com/abcword.html

Hope this helps




Pat