How to convert .eml emails into an Excel spreadsheet

Download Eml Viewer for email.

What is a .Eml File?
.EML files are individual email messages (RFC-822) created by Outlook Express, Thunderbird, or other email clients. .EML files contain all of the information in the email, including the sender and recipient email addresses, subject, internet header, message text, and more.

If you have a folder filled with many .EML files, it may be convenient to convert them into an Excel spreadsheet. Having the contents of the .eml files organized in a spreadsheet grid might make it easier to search the contents for key words, quickly sort them by date, analyze sender and receiver information, and to collect the email addresses for use in marketing campaigns or other purposes.

So how can you convert many .eml files, perhaps thousands of them, into a single Excel or Calc spreadsheet? This is not a capability that is natively available in Outlook Express or any other email client that I am aware of.

One way I have found to accomplish this is to use a EML file viewer like PST Viewer Pro that can export the messages to a .csv or comma separated values file. .CSV files can easily be imported into Microsoft Excel.

PST Viewer Pro (also marketed as EML Viewer Pro) is a tool for managing .eml formatted emails, as well as .pst, .ost, .msg, .mht and winmail.dat emails. These steps will work to convert any of the aforementioned email content to a .CSV file.

Let’s take a step-by-step look at how to export .eml files to .csv using the PST Viewer Pro email viewer.

First, install a free trial of PST Viewer Pro from the product website, then start the software.

Use the folder navigation in Pst Viewer Pro to select the file folder that contains your .eml files.

Navigation in PST Viewer Pro software for opening Outlook .pst files.
Select folder with .eml files

Next, select the files you want to export to a .csv file.  Hold the ctrl key and click on an email to select individual messages. To select all messages, click ctrl-A.

Selecting .eml file in Eml Viewer Pro.
Select .eml files you want to export to .csv

Now that the messages have been selected, all that remains is to start the export process. Click on the “Export” button.

Location of the Export button on the software toolbar.
Click the export button

This will bring up Pst Viewer Pro’s Export Manager from which you can select export file type. Pst Viewer Pro lets you choose from many different target formats. Let’s select .CSV.

Email export manage with "CSV" format selected.
Email export manager.

Click Start to begin the process.  You will be asked for a target folder. Choose a place where you can easily find the .csv file.  I named my file “Eml-files-converted.csv” and saved it to my Windows desktop. If you have Microsoft Excel on your computer, look on your desktop for a file like this:

Email export manage with "CSV" format selected.
Xls file.

To open this .CSV file in Microsoft Excel, all I have to do is double click on it. If the file doesn’t open for you, you may need to start Excel, and then go to File >Open and select the .csv file manually.
Excel will open the .csv file, and display the .eml file contents in the spreadsheet grid.

Email was exported to .csv and imported to MS Excel using PstViewer Pro.
Email exported to MS Excel spreadsheet.

Now that your .eml files have been converted into an Excel spreadsheet, you have full control over the data. Organizing email messages in this way can allow you to search the text very easily. It can also allow you to gather email addresses in a format that can be exported into other applications for marketing or customer service purposes.

And that’s how you convert .eml into Excel or .csv using Pst Viewer Pro!

EML to PDF: How to Merge .EML Files into One PDF Document?

PDF Logo

Eml files are individual email files that have been saved outside of an email client. Thunderbird is a popular client that saves emails as .eml files. For a variety of reasons, it is sometimes convenient to convert .eml files to different formats, such as PDF.

PDF logo
PDF is well suited for Email storage if you use the correct software.

When converting eml to pdf, consider how you want to structure your project. Questions you should answer before starting:

How many .Eml files are you working with?
If you have thousands of .eml files, then you will need software that can automate the export.

Do you need to convert .eml files to a single PDF or to individual PDF files?
Sometimes its more convenient to combine the .eml files into a single large PDF file.

How should file attachments be handled?
When converting email to PDF, file attachments are too often an afterthought, when they should be the main focus of the project. Consider whether the file attachments should be placed inside the PDF file as separate files that can be later extracted, or whether they should be combined into the PDF document image, or simply ignored.

EML Viewer Pro

EmlViewer Pro (also known as PstViewer Pro) by Encryptomatic LLC is an email viewer that can accommodate any of the above scenarios.  It is well suited to eml-to-pdf conversion.

Screen shot of .eml viewer pro software with emails in the maillist.
Eml Viewer Pro email viewer can convert multiple .eml files to a single .pdf document.

How to convert EML to PDF with EmlViewer Pro.

First, download and install the free trial of EmlViewer Pro*.

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

Second, start the software and choose the folder containing your .EML files.

Third, select the emails in the mail list that you want to convert to PDF.

Fourth, on the Export tab, select the PDF export format that you desire. To convert multiple .eml files to one PDF, select one of the “Single PDF” export profiles.

Screen image of EmlViewer Pro showing the eml to single-PDF file conversion options.
Select a Single PDF export option for the EML file conversion.

Finally, click the Export button to begin the process.  EmlViewer Pro will continue process .eml files and placing them into the single PDF file until the operation is complete.

To get you started, watch this short video about converting Eml to PDF documents.

If you have any questions, post them below! Thanks for reading.

*Note: EmlViewer Pro is also known as PstViewer Pro. Both products are developed by Encryptomatic LLC. Although once separate, they have been combined into a single product.