How to Export Email Addresses From .Eml Files To CSV/Excel?

Screen image of Microsoft Excel.

 .Eml files are text files that contain individual email messages. They have been formatted in a special manner that is described in a standards document called RFC-822.   Software that understands this text encoding can display the contents of the email message, including file attachments (yes, even binary files are encoded as text in an .eml file).  Virtually any standard email client can open .eml files, including Outlook, Thunderbird, Windows Live Mail, etc.

While email clients can open individual .eml files, they fall short when it comes to searching and managing a directory filled with hundreds or thousands of these files.  EML Viewer Pro is a specialized viewer for both .eml and Outlook .msg files. It lets you analyze the contents of thousands of .eml files and even convert them to different formats.

Saving Email Addresses in .Eml Files to .CSV Format

A customer wrote us recently and said that when she decided to leave her ISP’s email service for Gmail, the only way she could take her emails with her was to download them as a large batch of .eml files. She then wanted to create a list of her email contacts.  To accomplish this, she used EML Viewer Pro to export the email messages to a comma separated values (.CSV) file which she could then import into Microsoft Excel.

Here are the steps you can take to save email addresses from .eml files into an Excel spreadsheet.

First, download a trial of EML Viewer Pro (also known as PstViewer Pro). You can use the free trial for 15 days.

Then, select the folder where your .eml email files are stored. This can be a local, network or cloud folder, as long as it appears in your Windows folder structure.  When the folder is selected, EML Viewer Pro will read in the email messages and display them in a list.

You can use the sort and search functions to find emails that are important to you.

Form for searching your .eml email files.
EML Search Window

Any .eml files that match your search query will appear in the list. You can select messages to export individually, or you can select all of them. To select all, type “Ctrol-A.”

The final step is to tell EML Viewer Pro the format that we want to export the selected .eml files to. In this case, we want to collect the email addresses from our .eml files, so we’ll tell EML Viewer Pro to convert the selected emails into a .CSV file.   To do this, look to the toolbar, and select the export profile called “CSV,” then click the yellow and green Export button to start the operation.

Animated gif shows how to select the Eml to CSV export profile in EmlViewer Pro software for MS Windows.
Select CSV export profile.

EML Viewer Pro will begin converting your .eml emails into an organized .CSV file. Various fields will be copied from the .eml file into corresponding columns in the .CSV file.

In this image, we have opened the CSV file in Microsoft Office Excel.  The email content is now fully available to be analyzed and manipulated in Excel.

creen image of MS Excel with email content imported from CSV file.
CSV File with Email Content Imorted to MS Excel

If you are converting thousand of emails, it may take it several minutes to complete the operation.  At the end, you’ll have a .csv file that has the main email data fields separated into into columns.  Use Excel’s de-duplication function to remove any duplicate email addresses.

That’s all there is to it!  Download your EML Viewer Pro free trial from here.

EML to JPG: How To Bulk Convert .EML Into .JPG Files

Software screenshot.

People need to do all kinds of different things with email. In this article, we are continuing our series on converting .EML email files into different formats.  Today’s target format is the venerable .JPG or .JPEG file, which has existed in one form or another since 1987.

JPG is the most widely used format on the internet for encoding pictures. JPG image files are widely accessible and may be displayed on virtually any computer, tablet or smart phone. Because they are so accessible, JPG format is handy for a variety of reasons, including archiving image files for long term storage.

Eml Viewer Pro (also known as Pst Viewer Pro) is a multi-format email viewing tool that has strong export abilities.  One of the little known features of EML Viewer Pro is its ability to bulk convert email (both .msg and .eml files) into JPG files.

The image file below shows the entire process. Download a free 15 day trial of Eml Viewer Pro for your Windows computer and follow along.

Download Eml Viewer for email.

Animated image shows user selecting JPG export profile in EmlViewer Pro software s
Converting .eml files to .jpg format

The first step is to use the file explorer on the left side of the Eml Viewer Pro window to navigate to the location where your files are stored.They will be read into Eml Viewer Pro and displayed in an organized mail list. Your list may contain one, hundreds, or even thousands of .eml files.

Select the email(s) from the list that you want to export to JPG format. To select all of the emails in your list, type Ctrol-A on your key board. To select only one, just click on it. You can select a range of emails by holding down the shift key.

The next step is to locate the drop down list on the Eml Viewer Pro main menu. Choose the JPG export profile. This simply indicates to Eml Viewer Pro that the target format for it’s next export operation will be JPG.

Lastly, click the Export button. You may be asked to select the folder where Eml Viewer Pro will save the JPG files.  Select a folder and continue. The export operation will continue until the .eml files you selected have been converted into .jpg format.

This is an image of an image that has been converted into a .jpg file by Eml Viewer Pro.
An email converted into .jpg format

The image shown above is an actual html email file that has been converted into a jpg image. The border was not part of the original email, which was actually very long and so we cropped it so that it would fit in this article. The actual dimensions of the resulting jpg image will depend upon the length of the message within the email file.

EML Viewer Pro will append the header information to the top of the jpg file, including From, Sender, To, and Subject line. The email message will follow. The message will be rendered as a html or rich text document first, or a text file.

Currently, file attachments are not converted to jpg format, and are ignored during the processing. If you need to convert emails into a format that supports converting file attachments, we recommend this article about how to use Eml Viewer Pro to convert your .eml files into pdf.

Thanks for reading this article! We hope it helps you accomplish your goals. Post any comments below! You can also find us on Facebook.