Learn more

Wednesday, January 13, 2016

How to Import Email Messages to an Excel Spreadsheet

Ann P. called today with a question:
"Our company is involved in a lawsuit. The attorney wants my boss to review a large email set. He lives in Microsoft Excel and wants me to convert the emails to Excel for him.  How can I do this?"

Screen shot of PstViewer Pro email viewer with CSV export profile selected.
PstViewer Pro Export Menu

Spreadsheets like Microsoft Excel are a common and useful way to organize numbers and data.  Once in a spreadsheet, it is easy to view, sort, organize, search, and manipulate the data.  Although there are probably better options for reviewing email, such as our PstViewer Pro application, we understand that converting email to use in a spreadsheet can be very useful.

Encryptomatic's PstViewer Pro email viewing software for Windows has the ability to convert selected email messages to CSV format which can easily be imported to Excel, Calc, and other spreadsheets.   The way it works is simple:  just select the email messages from the mail list, choose "CSV" from the export box, and click "Export."  You'll be asked to select a name and a folder for your CSV file.

Screenshot that shows a marked image diagraming how to use PstViewer Pro software to convert email messges to CSV format.
Convert Email to CSV/Excel spreadsheet format.

When PstViewer Pro finishes with the export operation, you can now open your .CSV file in any spreadsheet app.

PstViewer Pro can export to CSV from Outlook .pst, .ost and .msg email files. It also supports .eml and soon MBOX to CSV export.



You can download a free trial of PstViewer Pro here.  If you have any questions, just posted them below int he comments.



No comments:

Post a Comment