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.

Converting Emails from .EML to .HTML Files.

A .eml file is an individual email message that has been moved outside of an email client, such as Mozilla Thunderbird. EML files may contain pictures, file attachments, email metadata, and more.

Its very common to receive email messages that are formatted either as Text (.TXT) or HTML files. Embedding HTML in emails lets the sender mark up the text. They can add formatting, titles, colors, images and logos to their email messages.

Download Eml Viewer for email.
Download .Eml Viewer by Encryptomatic LLC.

In an earlier article, we described how to convert .eml to text files with EmlViewer Pro (also known as PstViewer Pro), the email https://www.emlviewer.net/2013/08/19/how-to-convert-multiple-eml-email-into-text-files/viewer software for Windows that lets you discover and convert email messages.  If plain old text files are too boring for you, let us show you how to convert .eml email files directly into HTML documents. You could even post them to your web server, if you like, for the entire internet to see.

Converting .EML to .HTML Files

Saving a .eml email file as html file will save the HTML code to a .html file.  Instead of having all of the elements contained in a single .eml file, an email converted from .eml to .html will be broken apart, just like a regular web page. The individual elements will be stored as separate files that are linked from the resulting .html page. Any embedded elements, like pictures, will be stored in a folder.

Converting .eml files to .html is useful if you want to preserve the email content, but also want easy access to embedded images or  file attachments.

Although we are describing how to convert .eml to .html, this same process can be used with EmlViewer Pro to create html files from emails stored in .msg, .pst, .ost and .mht files. You can convert one email to html, or bulk convert thousands of emails to .html.

Eml Viewer Pro

If you would like to follow along with the step by step instructions, download a 15 day free trial of EmlViewer Pro software (also known as PstViewer Pro)for Microsoft Windows by Encryptomatic LLC.  EmlViewer Pro is also known as PstViewer Pro. At one time EmlViewer Pro and PstViewer Pro were separate products, but they have recently been combined into a single more powerful product able to process many different email formats.

Step 1 Start EmlViewer Pro. Using the folder explorer on the left side of the screen, select the folder containing your .Eml Files. The emails will be viewable in the EmlViewer Pro mail list.

Step 2  Select the Eml files you want to convert to HTML.  Selected files will appear highlighted in the mail list.

Screen image of EmlViewer Pro with emails selected in preparation of conversion to HTML format.
Selected emails are highlighted

Step 3  Select the target export format “HTML”

Screen shot of EmlViewer Pro with HTML export profile selected in list.
Choose HTML export profile

Step 4  Click the “Export” button to begin the export process.

The Eml files will now be converted into Html.  Lets take a look at the folder and see how the files are organized.

Notice that the folder contains .html files that use the email Subject line as the file name. The image elements for emails that contain them will be placed in a sub folder, which will share the same name as the html file. Folder organization keeps the email elements (images and file attachments) from being mingled with other emails.

Screen shot of a Windows folder showing the organization of HTML index and image subfolders.
Folder structure of emails converted to HTML files

To view the email as a HTML page, click on it, and Windows will open it in your web browser,

Screen shot of an email displayed in Google Chrome web browser. The email has been converted to a HTML file by EmlViewer Pro software.
An Email that has been converted to a HTML file, displayed in Google Chrome web browser.

If you have any questions about EmlViewer Pro, post them below, or use the online chat service here to talk to a support technician.