Share via

I want to download my emails into excel files to analyze types of emails. How can I download?

Anonymous
2024-10-07T18:11:09+00:00

I want to download my emails into excel files to analyze types of emails. How can I download?

Outlook | Windows | New Outlook for Windows | For home

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2024-10-07T22:17:56+00:00

    Dear Latonia Jenkins,

    Good day! Thank you for posting to Microsoft Community.

    May I please know if you are using classic outlook for Windows with new build or the new Outlook for windows preview version?

    If you are using a new outlook for windows, I do understand your query here, but export/import outlook file feature is not yet available in the new outlook. However, if you are using classic outlook, you can export your outlook email to Microsoft Excel or Comma Separate Value (CSV) to analyze the exported emails, kindly follow the steps below:

    1. Export Emails from Outlook:

    2. Open the Exported File in Excel:

    • Open Excel and go to File > Open.
    • Navigate to the location where you saved the exported file and open it.

    3. Analyze Your Emails:

    • Once the file is open in Excel, you can use various Excel features like sorting, filtering, and pivot tables to analyze the types of emails.

    However, if you want to download just small number of emails, you can use a copy and paste feature in classic outlook. To do this, hold ctrl key and click on emails to select, then right click -->Select Copy -->Open your Excel Sheet and paste. this will allow you to move the email from outlook to excel file.

    If your scenario is difference from the above, could you please provide us with more information.

    Thanks for your precious time. Have a nice day! 

    Sincerely,

    Libeamlak | Microsoft Community Moderator

    1 person found this answer helpful.
    0 comments No comments