How to convert EML to CSV (for Excel or databases)

Aid4Mail is the best EML to CSV converter tool for Windows. If you don’t have it yet, you can experiment with the free trial version or purchase a low-cost 2-week Aid4Mail Converter license.

Aid4Mail is the only software on the market that enables you to fully customize the content of your CSV files. You can decide exactly what email metadata to include, even the whole SMTP header and email body in plain text. Attachments can be extracted and linked from within the CSV data.

Create CSV files that are compatible with Microsoft Excel (respecting cell-size limits) or for import into a database with no limits. Aid4Mail offers lots of flexibility, is very fast and highly accurate.

Please follow the steps below to batch convert EML files to CSV with Aid4Mail. For any setting that’s not specifically mentioned, you can either use the default (preset) value or consult the Aid4Mail 5 User Guide for details. You can open it from Aid4Mail by pressing the F1 key.

Step 1: Open Aid4Mail’s settings

  1. In Aid4Mail, select the Settings tab.
  2. Update the Session name to so it describes for the task at hand. In this example, we will be converting John Doe’s EML files to a CSV file so we’ve entered John Doe EML to CSV as the session name.
  3. Below the session name there are three sections: Source, Target and Filter. Each can be displayed or hidden by selecting the +/- symbol next to the section heading. This tutorial requires them all to be displayed.

Step 2: Set EML files as your source

  1. In the Format list, select EML files.
  2. Set the Location of your EML files, either writing it directly in the field or by using the Select button to browse your file system. Set a single EML file, or a folder containing EML files, or a folder whose hierarchy (anywhere below it) contains EML files. For this example, we’ve set a folder called JohnDoe.
  3. Choose whether to Remove journaling envelope if your email files are journaled.

Step 3: Set CSV as your target

  1. In the Format list, select CSV.
  2. Choose whether to create the CSV for Excel or not. Turn this option on to ensure the CSV file respects the limits imposed by Microsoft Excel, notably the cell size. If you are not planning on using the file in Excel, you can turn this option off.
  3. Specify where you want your CSV file to be saved. You can write directly in the field or use the Select button to browse your file system.
  4. Select the Column configuration you want in the CSV file. You can select one of the default options in the drop-down list or you can create your own by using the Add button. Aid4Mail allows you to fully customize which items of information from the emails you want added to the CSV File. As shown below, there are 95+ items that can be selected. For this example, we are using All metadata with extracted attachments.

Step 4: Set your filter (optional)

  1. Under Folder filtering, pick Folder selection. Your EML files folder structure will appear in the box below.
  2. Select the folders you want Aid4Mail to process. The others will be skipped.

Step 5: Run your EML to CSV conversion

Select the Run button or Session > Run from the menu. Aid4Mail will convert your EML files to CSV. It will automatically open the Progress tab so you can monitor what’s going on. Once finished, you will find full reports in the Progress log and, if relevant, the Error log.

Step 6: Open the CSV file in Excel

You can do this by selecting File > Open  from Excel’s main menu and navigating to the target location you entered in Aid4Mail to select the CSV file.

That’s it!

We hope you found this tutorial helpful in showing you why Aid4Mail is the best EML to CSV converter on the market.

If you’re looking for further information, first take a look through the Aid4Mail 5 user guide and our knowledge base articles.

If you still have questions, don’t hesitate to contact our award-winning Helpdesk.

If you’d like to buy an Aid4Mail license, please visit the online store.

Or if you’d like to try Aid4Mail first before purchasing, download a free trial and run your own tests converting EML files to CSV. We want you to have full confidence in Aid4Mail!

About Fookes Software

Fookes Software Ltd
La Petite Fin 27
1637 Charmey (en Gruyère)
Switzerland

For over 25 years we have been developing award-winning tools and productivity software. We also have more than 20 years of expertise in the field of email processing and analysis.

Our clients include Fortune 500 companies, government agencies, law firms, universities, and professionals specializing in e-discovery and forensics from around the world.

Your outdated browser! You can download Edge or Chrome or Firefox