Converting multiple .eml email files into a .csv file for import into a spreadsheet app.

Screen shot of Microsoft Excel.
Eml email files can be converted into a .csv (comma separated values) file using EmlViewer Pro.
The .csv file may then be imported in to a database or spreadsheet application. The various values of the .eml email will be separated into different columns, which is useful if trying to extract email addresses.

.EML File Extension

EML, which stands for ‘E-mail’, is the file extension of the Outlook Express Saved Mail Messages files. It belongs to the Microsoft range of e-mail management programs and is used for saving e-mails for storage and forwarding purposes. EML is a file extension for an e-mail message saved to a file in the MIME RFC 822 standard format by Microsoft Outlook Express as well as some other email programs. Files that contain the .eml file extension are email files that have usually been sent or received by a POP3 email application.

Download Eml Viewer for email.

.CSV File Extension

CSV (“Comma Separated Value”) file format is often used to exchange data between disparate applications. The file format, as it is used in Microsoft Excel, has become a pseudo standard throughout the industry, even among non-Microsoft platforms. A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab.

CSV is a common, relatively simple file format that is widely supported by consumer, business and scientific applications. One of its most common usage is moving tabular data between programs that natively operate on incompatible (often proprietary and/or undocumented) formats.

This works because so many programs support some variation of CSV at least as an alternative import/export format. For example, a user may need to transfer information from a database program that stores data in a proprietary format, to a spreadsheet that uses a completely different format. The database program most likely can export its data as “CSV”; the exported CSV file can then be imported by the spreadsheet program.

Quick Steps

For those who just want to get to the point quickly, here is the essence of converting a .eml to .csv with EmlViewer Pro.

Simply highlight the selected emails from the mail list, choose “Export to CSV” from the drop down list, and then click the “Export” button.

Export profiles can be configured to do many different things. Any of the existing export profiles in EmlViewer Pro may be configured with additional settings and parameters. You can also design new profiles to meet your custom requirements.

The rest of this article explains the process in fine detail, and demonstrates exactly how to configure a csv export profile using EmlViewer Pro’s export wizard.

Steps to convert .eml to csv

To begin converting the EML file into CSV, start the program Eml Viewer Pro. On the left extreme right below the status bar and tools, you will find an explorer tree where you choose the windows folder which contains the emails stored in .eml format (Not to mention that Eml Viewer Pro can also open .pst, .ost, .pst, winmail.dat, and even .mht files as well and it’s a six viewer in one).

EmlViewer Pro file explorer. Select .eml files to be converted to .csv.

Email explorer

From Email Explorer, select the emails you want to convert. If you want to convert just one email, just select that email. If you want to select a range of emails in that folder, hold down windows shift key to select those range of emails. And above all, if you want to convert all the emails in that folder, press control-A to select all of the emails. The selected emails will be highlighted. You can select random emails in a folder at one time too by pressing ctrol and clicking on the desired emails whose format is to be changed.

Image shows .eml files in the EmlViewer Pro mail list. Selected emails to be converted to .csv.

.eml files listed in EmlViewer Pro.

Now the selected emails to be converted are selected. Since the desired format is .csv format, we will need to choose the “Export to CSV” profile. To do so click on the “New Profile” icon given in the Tools below the Status bar. This same option of “New Profile” is also given in the “Export” heading in the Status bar. On clicking “New Profile” a new widow pops up named as “New Export Profile Setup”.

Screen shot shows the image of the New Profile wizard in EmlViewer Pro.

Creating a csv export profile in EmlViewer Pro. 

  1. Once “New Export Profile Setup” window appears, click on Next. A new window will prompt on your screen asking two things; the new profile name and the export profile format. Give any desired profile name such as “into CSV” for my case and select the export profile format as desired which is CSV format currently. Once you have done this, click on Next.
Screen shot of Eml Viewer Pro's target export profile, with CSV selected.
Setup of .csv export profile.
  1. On clicking next, a window appears which asks you to select the folder in which exported items (converted items) are to be saved. There will be another option, if to save the exported file in a direct folder or in a zipped folder in compressed form. This is for you to decide. Once you do this, click on Finish.
Selecting target folder for .csv file in EmlViewer Pro.
Setting up a .csv export profile in EmlViewer Pro.

 

  1. Once the profile has been created, now all you have to do is to export the emails to the desired format using that profile. This is the easiest of the steps since all you have to do is to press ctrol-E or click on “Export” in the status bar or the “Export” icon in the tools. (Note: When clicking on Export icon in the tools, make sure that the selected profile is the one you created or the one that you have made for the desired format of converting)
Screen image shows the location of EmlViewer Pro's export to csv function.
Eml Viewer Pro export to csv function.

 

  1. The task has of converting the file extension from .eml to .csv has been finished. The selected emails .eml format have been converted into .csv format. The export folder that you selected contains the converted items.

 

  1. Now the next task is to import these csv files into Microsoft Excel. As it has already been mentioned that csv files generally contain tabular data that can be best manipulated and displayed via Microsoft Excel. Open the Microsoft Excel, any version would be equally compatible. You will need a blank workbook open.

 

Microsoft Excel empty spreadsheet.
Microsoft Excel

 

  1. Go to menu >> Data >> Get External Data >> Import Text File. (If the menu options are greyed out this could be because you do not have a new workbook open). Now select the file you have just converted into csv from eml format. You may need to set ‘files of type’ drop-down box to ‘All Files ‘ to see your file. Having selected your file click ‘Import’.
Importing external data into MS Excel
Location of Excel’s External Data function

 

  1. A new window of Text Import wizard at step 1 of 3 will appear on screen. Ensure that the ‘Delimited’ option is selected. The other option is Fixed Width which is rarely to be chosen. Click Next.
Excel text import wizard, step one.
  1. Step 2 of 3 in Text Import Wizard appears. In the delimiters section tick ‘Comma’ (Sometimes comma is not the separating variable, the separating variable can be judged easily from the csv file preview at the bottom of this Text Import Wizard). The text qualifier box should show the double-quote symbol. Click Next.
Excel text import wizard, step two.

 

  1. Step 3 of 3 in Text Import Wizard appears. You now need to set every column to be data format ‘Text’. The first column will initially be highlighted. Move the horizontal cursor as far as it will go to the right, and holding the shift key down, click the column heading on the very last column. You should now have every column highlighted together.
Excel text import wizard, step three.
  1. Click the ‘Text’ data format. It will now say ‘Text’ in the header of every column. Click Finish.

 

  1. It may ask you ‘Where do you want to put the data?’. It will allow you to click into any cell on the blank worksheet to determine where the data should go. Click ‘OK’ to proceed.
Screen image showing Excel Import Data Window, with Existing Worksheet selected.
Import .csv data to Excel

 

  1. The data should now appear in the spreadsheet. Where column headings are included these will appear in the top row. Check that fields have not lost leading zeros where applicable.
Email content that has been imported to a Microsoft Excel spreadsheet.
Excel Spreadsheet

 

For more information about EmlViewer Pro and a free trial, go to the EmlViewer Pro home page.

How To Convert .EML Email Files Into .PDF Files?

PDF Document image. Convert eml/mbox to PDF.

An .EML files is an individual email file. It contains the email message and any file attachments that were included with the message.  Eml files was once part of a larger file, such as a Mbox, Pst or Ost file, but has been saved outside of that larger storage file.

If you find yourself with a batch of .eml files that you need to convert into .PDF files, EML Viewer Pro software by Encryptomatic LLC can help you.

Why would someone ever have .eml files? There are many situations where you may encounter them.  As a published open standard (RFC-822) .eml files are used by many different email clients, including Windows Mail, Outlook Express, Thunderbird, and others.  If you are involved in a court case, or received a FOIA request fulfillment from a government agency, you may have received the emails in .eml format.

Converting .eml emails into common .pdf files sounds like it should be a very simple thing to do; and if you have the correct software, it is simple.

Many people encounter problems by attempting eml to pdf conversion using software that is not designed for that purpose.  For example, a free .pdf printer app might do a great job rendering the email message as a .pdf file, but may fail to convert file attachments.

Specialized functions, such as adding an email individually to an existing .pdf file, or embedding file attachments inside the pdf may not be supported. What if you need to convert thousands of .eml files to individual pdf files, and apply a specific naming structure to the files?  No free app that we’re aware of can support these complex operations.

EML Viewer Pro can!

Main screen of Eml Viewer Pro software, which can be used to convert .eml files into .pdf files.
Eml Viewer Software for MS Windows

Getting starting with .eml to .pdf file conversion

 

Download a free trial copy of Eml Viewer Pro software (also known as PstViewer Pro). The trial runs for 15 days. Although the registered version of the software can convert an unlimited number of emails to pdf in a single batch, while in trial mode it will only export up to 50 at a time.

When Eml Viewer Pro starts, use the folder navigation on the left side to select the folder where your .eml files reside.  Eml Viewer Pro will read in your .eml files and display them in a message list.

Image shows .eml files in an organized list in Eml Viewer Pro software for Windows.
.eml files in a list

To export a single .eml file to .pdf, follow these steps.

First, select the file(s) in the list that you want to convert to .pdf.
Next, from the Export drop down list, select the appropriate method for converting your .eml files from.

Finally, click the yellow “Export” button to start the operation.

A list of options for converting .eml files into .pdf files. Choose the correct option.
Select the eml to pdf export method

Eml Viewer Pro will go to work processing your eml files. You may be prompted to choose a destination folder.

Choosing the correct PDF export method.

As we mentioned earlier, any free pdf printer can suffice if you only wan to convert a single email into a single pdf file, especially if it does not contain file attachments.

EML Viewer Pro adds value by providing you with a wide of methods for converting .eml to .pdf.

Some of the possibilities include:

  • Exporting many email to a single pdf
  • Exporting many emails to multiple pdfs
  • Exporting an email into an existing pdf
  • Converting to pdf while extracting file attachments
  • Converting to pdf while embedding file attachments
  • Converting to pdf and attempting to convert file attachments into the pdf image
  • Applying a special name to the newly created .pdf files

Eml Viewer Pro accomplishes tasks through “Export Profiles.” These are sets of instructions that tells Eml Viewer Pro how it perform the task.  Export profiles appear from the drop down list. You can create brand new export profiles, or edit the ones that Eml Viewer Pro ships with.

Select the method for exporting eml emails into .pdf files.
Edit any export profile to customize

To edit an export profile, first select that profile from the list, and then click “Edit Profile.  This will open the profile editor. While we won’t go into great detail here, the profile editor allows you to customize many of the values and parameters to Eml Viewer Pro uses to accomplish its tasks.

The export profile editor, showing configurable settings for .eml-to-pdf export.
Edit the pdf export profile.

Download a free trial of EmlViewer Pro.

If you have any questions about exporting eml files into .pdf files, post them in the comments below, or email us at supportline at encryptomatic.com and we’ll be glad to help.