Explore How to Migrate Outlook Express Address Book to MS Excel

Outlook Express is an email application that offers mailing services and stores emails in DBX format. Apart from emails, contacts and many other items are stored in Outlook Express. Here, we are talking about contacts of Outlook Express. Sometimes, users find a need to export contacts from OE client to MS Excel. The users start searching for this query several times. In this segment, we have provided a complete solution to perform conversion from Outlook Express contacts to Excel spreadsheet.

How to Move Outlook Express Address Book into MS Excel?

There are basically two steps to export Address Book from OE to Excel spreadsheet.

Step 1. Exporting Address Book from Outlook Express

  1. Start Outlook Express client and select File menu
  2. select file menu
  3. Go to Export option and then choose Address Book option
  4. Click on Text File (CSV) and choose Export option
  5. Go to the Browse button to define a location and click Next
  6. Select the fields you want to convert for every contact like first name, email address, home city, last name etc.
  7. Once it is done, click on the Finish button
  8. finish button

Step 2. Import CSV File in Excel Spreadsheet

Now, you can import CSV (Comma Separated Value) file to Excel. For this, follow the given instructions –

  1. Open Excel worksheet
  2. Click on Data tab and then select From Text
  3. data tab select text
  4. Under Import Text File wizard, open the folder in which .csv file is available and choose Text Files beside to File name and select your CSV file.
  5. select csv file
  6. Click on Import option. This will open a new window of Text Import.
  7. Check the Delimited radio button. Click Next option.
  8. check delimited radio button click next
  9. Choose a Delimiter option like comma, tab, semicolon etc. Then, click Next.
  10. choose delimiter option
  11. In the next wizard, you need to choose each column and set the data format.
  12. choose each column
  13. Click on the Finish button and choose the desired location to save the imported data
  14. click finish button
  15. Click OK button and you will find CSV file will be imported into MS Excel spreadsheet.
  16. click ok

Conclusion

In the above write-up, you will get a step by step process to export address book to Excel from Outlook Express. This will help users to get complete information to perform the migration task.

tools-security