Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hai , I have a word file with n number of employee address in it... Now i want to convert it to an excel file... I am using windows xp.. Is there a way to do so?

name
streetname
area
city
contactno

name
streetname
area
city
contactno

share|improve this question
    
what is the format of 1 employee address? All on 1 line? Edit your question with a sample of address. – Snark Dec 2 '09 at 13:29
    
Please add a screeny from your word file. – Mehper C. Palavuzlar Dec 2 '09 at 14:53
    
And what version of Office? – Ivo Flipse Dec 2 '09 at 14:55
up vote 1 down vote accepted

In Word, reformat the data to be tabular - each field separated by tabs, each record on a separate line:

  1. Press Ctrl+H to bring up the Find & Replace window.
  2. In the "Find what" box, type ^p^p, and in the "Replace with" box, type ^l. Press the Replace All button. [This replaces any two consecutive paragraph marks with a line break. It assumes that your records are separated by a blank row, which is what it looks like in your example.]
  3. Now type ^p in the Find what box, and ^t in the Replace with box, then Replace All. [This replaces any remaining (single) paragraph marks with tab characters.]
  4. Probably optional, but just for completeness, type ^l in Find what, and ^p in Replace with, then Replace All. [This replaces the line breaks from step 2 with paragraph marks.]

Now you can simply copy & paste the data into Excel.

share|improve this answer

You could try to select all the document in Word (Edit > Select All), copy and paste it directly in an Excel spreadsheet. Doing it, each row in word will become a row in excel. Then you could select each block in excel and then paste special/transpose it.

Another way is edit your word document, in order to have your records in one line (just join the lines, using a ";" to separate the fields. Then save the document as TXT and import it in Excel.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .