Often you may want to export emails from Outlook to an Excel file.
Although you can’t directly export emails from Outlook to a .xlsx file, you can use the following steps:
Step 1: Export Outlook Emails to CSV File.
Step 2: Open CSV File and Save As an Excel File.
The following step-by-step example shows exactly how to do so.
Example: How to Export Outlook Emails to CSV
Suppose that we would like to export all emails from our inbox to an Excel file.
To do so, we must first open Outlook.
Then click the File tab along the top ribbon, then click Open & Export:
Next, click the Import/Export icon:
In the next window that appears, choose Export to a file, then click Next:
In the next window that appears, choose Comma Separated Values, then click Next:
In the next window that appears, choose a folder to export emails from. For this example we will choose Inbox. Then click Next:
In the next window that appears, click the Browse button to browse to a specific location on your computer and choose a name to use for the exported CSV file. Then click Next:
In the next window that appears, you will have the option to click Map Custom Fields to specify which information you would like to export from the emails.
If you would simply like to export all of the default information, click Finish:
Your emails will be exported to a CSV file in the location that you specified on your computer.
Next, navigation to this location to open the CSV file.
The file should automatically open in Excel:
To save this file as an Excel file, click the File tab along the top ribbon. Then click Save As:
Then click the dropdown arrow under the name of the file and choose Excel Workbook (*.xlsx) as the file extension:
The file will automatically be saved as an Excel file.
You have now successfully exported all emails from your inbox in Outlook to an Excel (.xlsx) file.
Related Tutorials
The following tutorials explain how to perform other common tasks in Outlook:
Outlook: How to Search Emails by Date Range
Outlook: How to Search for Multiple Keywords in Emails
Outlook: How to Search for Emails with Attachments
