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

Aid4Mail is the best email to CSV converter software on the market. Unlike competing tools:

  • Aid4Mail offers full control over the CSV content.
  • Preserves email status information (unread, read, replied, …).
  • Faster than competitors

If you don’t have Aid4Mail yet, you can experiment with the free trial version or purchase a low-cost 2-week Aid4Mail Converter license.

Aid4Mail can convert email from many different formats such as EML or Mbox. Aid4Mail can also be used to export Outlook emails to CSV (from formats like PST, MSG, OLM and OST). When converting from Outlook email formats to CSV, Aid4Mail does not need Outlook installed in order to complete the conversion. However, you will get better performance when Outlook is present.

Aid4Mail also enables you to fully customize the CSV data and attachments can be stored separately in their native format.

Please follow the steps below to convert EML to CSV with Aid4Mail. This tutorial uses EML files but Aid4Mail can convert any of the supported email formats to CSV. 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

Session name EML to CSV

  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 CSV so we’ve entered John Doe EML to CSV as the session name. When converting email to CSV, you can convert emails from any of the available Source formats.
  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

EML files as Source format

  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 tool to convert emails to CSV.

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 emails 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