Search Us

Loading...

Tuesday, July 29, 2014

Exporting Outlook Emails From a .PST File To A .CSV File

Email content all around us, yet is surprisingly difficult to convert into different formats. A specialized tool like PstViewer Pro will enable to accomplish many different conversion tasks with email. One useful capability it posses is to take a selected quantity of email messages and convert them into a neutral format which is easily imported into spreadsheet or database applications. 

This article will discuss how to use PstViewer Pro to accomplish the conversion of email messages to a .CSV file which can be imported into Microsoft Excel.  CSV stands for Comma Separated Values.  The CSV file that PstViewer Pro creates will contain multiple email messages, converted to text, with each row in the Excel spreadsheet representing a single email message.  

PstViewer Pro can access emails from Outlook .pst files, and even email that exists in a single-file form, such as .eml or .msg format. You'll find that the process of converting email from .Pst to .Csv is exactly the same as converting from .Eml to .Csv, and .Msg to .Csv.  

Download a free 15 day trial of PstViewer Pro and follow along. 

When PstViewer Pro starts, select the specific .pst file you wish to access, or a folder that contains the .eml and .msg files you want to convert to .csv.


Screen shot of Pst Viewer Pro software with email messages in the list, pending conversion to CSV.
Pst Viewer software for converting email to .csv files.
Select the files in the mail list that you want to convert into a .CSV file.  Using the "Ctrol-A" command will select all of the emails in the list.   You can use PstViewer Pro's "Search" menu to refine the list to a specific set of email messages. 

When the messages are selected, go to the Export tab, and select the "CSV" export profile from the drop down list.  


Select .CSV from the Export Menu
Now that you have selected the emails, and the CSV export profile, begin the export operation by clicking the "Export" button, and select the location where the CSV file will be saved.

The final step is importing the CSV file into Microsoft Excel. In most cases, opening the CSV file in Excel is is as simple as clicking on it.


Image shows email text in Microsoft Excel which were imported from a .csv file.
Emails imported into Microsoft Excel
PstViewer Pro has many capabilities, and this article only highlights one. Explorer the many Export Profiles that are shown in the drop down list. The same process of selecting and exporting email messages applies to any of the various export operations.

PstViewer Pro is $69.99 for a single license.









Wednesday, June 4, 2014

Outlook Email Viewer, PstViewer Pro, Is Updated To Version 6

PstViewer Pro, the leading commercial Outlook email viewer has been updated. Version 6.0 includes improvements around replying/forward operation, particularly with Microsoft Outlook.  A number of inconsistencies between RFC-822 .eml and Outlook .msg and .pst email were reconciled. This has lead to a better user experience when PstViewer Pro is used for viewing and search operations, and Microsoft Outlook is used for replies.

PstViewer Pro 6 also includes a new user interface. Users can choose their favorite such as imitating the apperance of Outlook 2013, or selecting one of the fun, colorful UI's.

Updated PST Viewer Pro screen shot, showing new user interface for managing Outlook email content.

PstViewer Pro version 6.0