How to export Outlook message headers to Excel as a list?

Evgeny Shupik 191 Reputation points
2022-02-14T10:36:25.58+00:00

Hi, guys! Need some help - is there any method to export Outlook 365 message headers to Excel as a list? Don't need message body just "mail from", "date" and "subject". Thank you for support.

Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,001 questions
{count} votes

Accepted answer
  1. ChristyZhang-MSFT 21,591 Reputation points Microsoft Vendor
    2022-02-15T03:08:10.17+00:00

    Hi @Evgeny Shupik ,

    Welcome to our forum!

    According to your description, I have tried to export directly in Outlook client, but can just export Subject and From field but not Date field.

    As a workaround, we can easily copy the emails directly in the view containing only these three fields and paste them into excel, so as to meet your needs.(the effect drawing is as follows)
    174293-4.png

    For more specific steps, please refer to:
    1.First, please create a new view that contains only Subject,From and Received field via View>Change View>Manage Views…>click New… and type a name of new view>Under Type of view, just keep the default Table, click Ok.
    174288-5.png

    2.In the Advanced View Settings window, click Columns…>Remove the other columns except the three columns, click Ok.

    174289-6.png

    3.Click Other Settings…>turn off Reading Pane, click OK.
    174200-7.png

    4.After applying the new view, hold the Ctrl key and click emails, or hold the shift key to choose the emails you want to export and right click to copy them.
    5.Open an Excel file and paste them down.

    Hope the above help!


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


    7 people found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. Evgeny Shupik 191 Reputation points
    2022-02-15T07:10:32.303+00:00

    Great! Thank you very much! :-) But just one more question about 'date' column - is there any method to convert it to "mm-dd-yyyy" view?


  2. Linda Fiato 0 Reputation points
    2023-08-18T22:43:11.23+00:00

    ist here a way to get the times along with the dates?

    0 comments No comments