How to Export Outlook Emails to Excel Spreadsheets
By Kevin Lee
While Microsoft Excel is not a database, it can help you filter, organize and sort important data quickly. Your Outlook mail, for instance, may consist of messages from a variety of contacts that cover multiple topics. One way to analyze that mail is view it in Excel. Outlook’s Export tool enables you to get your data out of Outlook and Excel’s Import tool helps you copy it into a new spreadsheet.
Export from Outlook
Launch Microsoft Outlook and tap or click "File." Tap or click "Open & Export" and then tap or click "Import/Export" to launch the Import and Export Wizard.
Tap or click "Export to a File" and then tap or click "Next." Tap or click "Comma Separated Values" and tap or click "Next." The wizard displays a list of folders you can export. This list includes Inbox, Personal and Junk Email.
Tap or click the folder you wish to export and then tap or click "Next." Tap or click "Browse" to view the Browse window that displays your computer's folders and files.
Tap or click the folder to which you'd like to export your data and then tap or click "OK." Tap or click "Next," and then tap or click "Finish." Outlook exports the email folder you selected to the target folder you selected in the Browse window.
Import into Excel
Launch Excel and tap or click "Data." Tap or click "Get External Data" and then tap or click "From Text." Excel opens the Import Text File window that displays your hard drive's contents.
Tap or click the file you exported from Outlook and then tap or click "Import" to launch the Text Import Wizard. Tap or click the "Delimited" radio button to select it and put a check mark in the My Data Has Headers” check box. You check this box because the data that you exported from Outlook has headings Subject, Body and other headers.
Tap or click "Next" and place a check mark in the “Comma” check box located in the Delimiters section. Tap or click “Finish” and then tap or click "OK” to import the data into a new worksheet.
Review the information in the worksheet. You will see that it contains columns you see in your Outlook email.
Repeat these steps if you would like to copy other Outlook email folders to Excel worksheets.
After majoring in physics, Kevin Lee began writing professionally in 1989 when, as a software developer, he also created technical articles for the Johnson Space Center. Today this urban Texas cowboy continues to crank out high-quality software as well as non-technical articles covering a multitude of diverse topics ranging from gaming to current affairs.