Outlook Express is the most leading email application that offers different services such as emails and contacts. Each user mailbox is associated with the DBX file format, which stores the data contents of the mailbox. It is the file extension, which stores multiple messages within a single folder. Initially, it was included in Microsoft Office but after Windows Vista is replaced by MS Outlook. Due to which Outlook Express loses its popularity. Thus, users start searching for another platform i.e., Microsoft Excel. Further, they can easily export address book from Outlook Express to Excel. Nevertheless, in the upcoming section, we will discuss a complete solution to perform conversion from Outlook Express contacts to Excel Spreadsheet.

 

Outlook Express address book to Excel

How to Transfer Outlook Express Address Book into Excel

 

There are two steps by which users can export address book from Outlook Express to Excel spreadsheet. Some of them are described below:

Also Read: How to Export Outlook Notes to Excel Mac? – Know The Top Two Techniques

Step 1: Export Address Book From Outlook Express

If you are still running Windows 98/ 2000/ XP, then you can use Outlook Express email program. Outlook Express has a slightly different approach, but very simple also. Let us have a look:

 

  • Start Outlook Express and then, select File menu

 

Outlook Express File menu Export Address Book

  • After that, you can choose Export, and then Address Book option
  • Now, click on Text File (CSV) and choose Export button
  • Click on Browse to define a location to save the particular file or type it in manually
  • Next, choose Next and then, select all of the fields that you need to convert for each contact, i.e. First name, Street, Email address, Company, Phone, etc

 

Export contacts from Outlook Express to CSV

 

  • Once the migration process is done, press Finish button

 

Step 2: Import CSV File to Excel Workbook

 

Next, if you want to import CSV file (Comma Separated Value) to MS Excel, you can perform as this:

  • Enable Worksheet you need to import a .csv file, click on Data and then, From Text

 

Excel Data tab From Text option
 

  • Under the Import Text File dialog box, open the folder in which your .csv file available, and choose Text Files from the drop-down list beyond the File name text, and select your CSV file

 

Excel Import Text File dialog

 

  • Now, choose Import option and the Text Import Wizard is popped on the screen. Check the particular option you need in Choose file type best describe your data field. Now, you can check the Delimited because the entire data is delimited by commas

 

Text Import Wizard Delimited option

 

  • Press Next button to go to the next step, and check the delimiters you want to separate that data by in Delimiters section

 

Text Import Wizard comma delimiter

 

  • Select Next to proceed to the step 3 of the Text Import Wizard, and choose a specific column from the Data preview, and then select the format you need to apply in this column under the section Column data format.

 

Text Import Wizard column data format
 

  • Click Finish button. Then, the Import Data dialog box popped out for you to select the desired location for importing the data

 

Excel Import Data dialog box

 

  • Press OK button. Now, the CSV file has been imported into MS Excel spreadsheet

 

 

Imported CSV contacts in Excel sheet

 

Note: When an original CSV file has been changed, you can select Data and, then Refresh All option. For this, you can choose this .csv file format again to refresh the CSV data in MS Excel.

Limitations of Manual Approach

The above-stated method is very beneficial to transfer Outlook Express contacts to Excel but, it has some drawbacks. The main drawback is that it is a time-consuming procedure and internet connection is needed during migration. Once the export process was interrupted it cannot be resumed. Sometimes Outlook Express may also generate error like : Error Exporting the Address Book

Efficient Solution to Export Address Book from Outlook Express to Excel

To overcome all such constraints, users can opt for WAB Converter. It is designed especially to save Outlook Express contacts to Excel without any data loss. It is capable enough to perform bulk conversion from Outlook Express to CSV file without any platform dependency. It has a user-friendly interface that even a novice user can use it without having any extra knowledge.

The Bottom Line

In the above write-up, we have discussed a manual solution to export address book from Outlook Express to Excel spreadsheet. But, sometimes the manual solution will not deliver the best results. Therefore, in this blog, we have recommended tool by SysTools that will help to transfer Outlook Express contacts to Excel file without any hassle.

Also Read: How to Export Outlook Calendar to Excel? – Know Effective Methods Here