How to convert EML to TSV (fast + accurately)

Please follow the steps below. 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.

Step 1: Open Aid4Mail’s settings

Aid4Mail settings showing the session name set to "John Doe EML to TSV". The Source and Target sections are expanded but not set. The Filter section is not expanded. 

  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 TSV so we’ve entered John Doe EML to TSV 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 TSV as your target

Target settings for the TSV format.

  1. In the Format list, select TSV.
  2. Choose whether to create the TSV for Excel or not. Turn this option on to ensure the TSV 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 TSV 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 TSV 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 TSV 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 TSV conversion

Select the Run button or Session > Run from the menu. Aid4Mail will convert your EML files to TSV. 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.

That’s it!

We hope you found this tutorial helpful in showing you why Aid4Mail is the best EML to TSV 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 to TSV. 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