Explore How to Export Address Book from Outlook Express to Excel
Outlook Express is the most leading email application that offers different services such as emails, contacts, etc. 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.
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:
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
- 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
- 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
- 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
- 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
- Press Next button to go to the next step, and check the delimiters you want to separate that data by in Delimiters section
- 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.
- Click Finish button. Then, the Import Data dialog box popped out for you to select the desired location for importing the data
- Press OK button. Now, the CSV file has been imported into MS Excel spreadsheet
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 genertae 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.