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

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 MSG to CSV". 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 MSG files to CSV so we’ve entered John Doe MSG 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 MSG files as your source

  1. In the Format list, select MSG files.
  2. Choose whether to Process using Outlook. This means using Outlook’s internal engine (MAPI) to collect the MSG files. Using Outlook’s engine is faster, and provides access to more email metadata, but requires Outlook to be installed on the same computer as Aid4Mail. If you don’t have Outlook installed, keep this option off.
  3. Set the Location of your MSG files, either writing it directly in the field or by using the Select button to browse your file system. Set a single MSG file, or a folder containing MSG files, or a folder whose hierarchy (anywhere below it) contains MSG files. For this example, we’ve set a folder called JohnDoe.
  4. 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 MSG 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 MSG to CSV conversion

Select the Run button or Session > Run from the menu. Aid4Mail will convert your MSG 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 MSG to CSV converter on the market. As shown above, Aid4Mail can convert MSG files to a CSV file quickly and accurately.

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