How to download Microsoft Outlook emails to Excel

Authored by: Support.com Tech Pro Team

1. Introduction

One thing you must remember is that if you want to export an email into an Excel spreadsheet, the only thing transferred will be the data itself, and the basic links. In this guide, you'll learn how to download Microsoft Outlook emails to Excel.

2. How to Download

1. Download Outlook emails to Excel using Import / Export

1. Open Microsoft Outlook
   
   
2. Press File
   
   

1. Select Open and Export
   
   

1. 
   
2. Click Import/Export
   
   

1. Choose Export to a File
   
   

1. Click Browse
2. Set the file type as CSV
3. Check the Export E-Mail messages from the folder option to open the Map Custom Fields dialog box
4. Add or remove the fields you need in the workbook
5. Select the location where you want your file to be saved
6. Give the file a name for easier recognition
7. Select Finish

2. Download Outlook emails to Excel using Copy

1. Open Microsoft Outlook
2. Go to Mail view
3. Go to View
4. Select Reading Pane
5. Click Off
6. Click View
7. Select Add Columns
8. The Show Columns dialog box will appear
9. Choose All Mail Fields from the Select available columns drop-down list
10. Click to highlight the Message option in the Available columns section
11. Click the Add button and OK button one by one
12. Select all the emails in the email folder
13. Copy them all using Ctrl + C
14. Create a new workbook in Microsoft excel
15. Paste the emails in that workbook
16. Save the workbook

3. Use a Microsoft Outlook Add-in

You can use Add-ins for Microsoft Outlook to make mail to excel conversion far more easier.

These programs usually have a wizard-like guide that needs following, and you will be done in no time.