Export a list of emails to Excel

In classic Outlook for Windows

File › Open & Export › Import/Export › Export to a file › Comma Separated Values, then pick a folder. This exports message fields including the body, one folder at a time, and only from mailboxes connected to Outlook. Microsoft's new Outlook does not offer this wizard.

From any mail file, without Outlook

1. Open the PST, OST, MBOX, MSG or EML files in Letterlark.
2. Filter by folder, date or search term, and select the messages.
3. Choose CSV. Columns: date (UTC), folder, from name, from email, to, cc, subject, number of attachments, attachment names, source file.
4. Open the CSV in Excel, Google Sheets or LibreOffice (it is UTF-8, so non-Latin names keep their characters).

The CSV is an index – it does not contain the message bodies. Use PDF or EML export for the content.

Useful Excel steps afterwards

• PivotTable on from_email to see who sent the most mail.
• Filter attachments > 0 to find the messages with files.
• Convert the date column with =DATEVALUE(LEFT(A2,10)) if your Excel doesn't recognise it.