What is the .EML File Extension?
EML, which stands for ‘E-mail’, is the file extension that Outlook Express appends to individual email messages when they are saved. It is used by a range of e-mail client programs for storage and forwarding purposes. The EML extension means that e-mail message was saved to a file in the MIME RFC 822 standard format. Most EML files you will encounter have been sent or received by a POP3 email application although not always, since it’s possible that a locally created and stored email could be saved as a .eml file before it has been sent.
What is a .CSV File?
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 character or string, most commonly a comma or tab.
Why might you want to convert an EML file into CSV?
Both .EML and .CSV files are very common. CSV is a 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 is useful because so many programs support some variation of CSV at least as an alternative import 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.
If you need to manage the contents of multiple .eml files, or wish to import them into a database for analysis, then converting your .eml files to .csv will likely enable you to import those emails.
There are very applications that can complete this task efficient. PstViewer Pro has the capability to both read and search directories of .eml files. Once the emails are loaded into PstViewer Pro’s mail list, you can then export the text and common email fields (such as To, From, Subject, Date, etc) into a .CSV file.
Here’s how to convert your .eml files into .csv format using Pst Viewer Pro. Download a free trial of PstViewer Pro and follow along!
1) To begin converting the EML file into CSV, start the program PST 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 PST Viewer Pro can also open .pst, .ost, .pst, winmail.dat, and even .mht files as well and it’s a six viewer in one).
Selecting .eml files
2) Choose which emails you want to convert into csv format. If you want to convert just one email, just click on that it. If you need to select a range of emails in that folder, hold down windows shift key to select those range of emails. To convert all the emails in that folder, press ctrol-A to select all the messages. The emails you select will be highlighted. You can also select random emails in a folder at one time too by holding the ctrol key while clicking on the desired emails.
Choose which emails you want to convert into csv format.
3) Now that you have selected your emails, it’s time to select your target export format. Since the desired format is .csv, we will create an export profile for .csv format. To do this we 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”.
Set the eml to csv export target format
4) 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.
Select CSV as the target export format
5) 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.
New Export profile setup for .csv
6) 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).
Select CSV from the drop down list
7) 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.
8) 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.
9) 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’.
10) 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 1
11) 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.
Text Import Wizard, Step 2
12) 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.
13) Click the ‘Text’ data format. It will now say ‘Text’ in the header of every column. Click Finish.
14) 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.
MS Excel Import Data Window
15) 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.