1
Open the address list in Word and arrange the entries so that each address is separated by a delimiting character. You can choose any character to delimit the fields, although it is best to use a character that does not otherwise occur in your data. For example, if you were using semicolons to delimit the addresses, your file might read “1 Example Street, New York, NY;2 Example Street, New York, NY;” and so on.

2
Click “File” and select “Save As” to open the Save dialog box. Browse to the location you want to save the file to, and enter a name into the “File Name” box. Select “Text File” from the Save As Type drop-down menu, and then click “Save” to save the file as plain text.

3
Close Word and open Excel. Click “File,” then “New” and then double click on “Blank Workbook” to open a new Excel spreadsheet.
Select the “Data” tab and then click on the “From Text” button. The Import Text File dialog box displays. Browse to the location of your saved text file, select it and then click the “Import” button to open the Text Import Wizard.

5
Click the “Delimited” radio button in the Original File Type field, and set the Start Import At Row option to “1.” Click “Next” to open the next page of the wizard.

6
Select the delimiter character you used in your text file by clicking on the corresponding check box. By default, Excel provides as choices Tab, Semicolon, Comma and Space as delimiters. If you used a different character, check “Other” and enter the character into the text field. Click “Next” to go to the final page of the wizard.

7
Select “General” from the Column Data Format list and then click “Finish” to open the Import Data pop-up box. Select the “Existing Worksheet” radio button and click “OK” to finish importing the list.

I hope these steps will be helpful!
Matt Henry