Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.