1. Outlook Excel Previewer
2. Outlook Excel Mail Merge Instructions
3. Outlook Excelsior
4. Excel Outlook Online
5. Microsoft Word Excel Outlook Training

How to export one or multiple emails to excel file in Outlook?

Have you ever tried to export one or multiple emails to an excel file in Outlook? That means to save the emails as excel file. In this article, I introduce some methods on handling this task.

Export emails to separate excel files

As soon as we receive your email, your mail will automatically appear in your Excel. How to Create a Microsoft Flow for saving Outlook Email to Excel Spreadsheet Here, we can connect Outlook and Excel. Microsoft Account – Corporate ID. Outlook Account. Follow the below steps to build a Flow using a template. Microsoft Excel Mobile is the best app for reviewing, updating, and creating spreadsheets on Windows phones and tablets (with a screen size of 10.1 inches or smaller).On January 12, 2021 this app will reach End of Support on phones using Windows 10 Mobile. Learn more at https://aka.ms/OfficeWindows10MobileEOS. Outlook 2019, Excel 2019, Word 2019, PowerPoint 2019, Outlook 2016, Excel 2016, Word 2016, PowerPoint 2016, Outlook 2013, Microsoft Outlook 2013 Service Pack 1, Outlook for Office 365, Word 2013, Word for Office 365, Excel 2013, Excel for Office 365, PowerPoint 2013, PowerPoint for Office 365; In this article. Original KB number: 3020607. Export multiple emails to excel files. In Outlook, you can batch export all emails in one folder to one excel file. Click File Open Import in Outlook 2010; in Outlook 2013 or later version, click File Open & Export Import/Export. See screenshot: 2. In the Import and Export Wizard, click Export to a file, and click Next. See screenshot: 3.

Export multiple emails to excel files

In Outlook, you can batch export all emails in one folder to one excel file.

1. Click File > Open > Import in Outlook 2010; in Outlook 2013 or later version, click File > Open & Export > Import/Export. See screenshot:

2. In the Import and Export Wizard, click Export to a file, and click Next. See screenshot:

3. Click Microsoft Excel 97-2003 in Export to File dialog, and click Next again.

Note: Since Outlook 2013, it does not support to export to Microsoft Excel 97-2003 directly. Please click Comma Separated Values.

4. Select a folder you want to export the emails as Excel file, click Next.

5. Then click Browse to select a folder and give a file name to the files. See screenshot:

6. Click OK > Next to go to the last step, click Finish.

Note: If the Finish button is invalid, please check the Export “E-Mail messages” from folder: option firstly.

Now the emails in Inbox (the folder you select) have been exported to an Excel file.

Note: If you are using Excel 2013 or later versions and check Comma Separated Values at Step 3, the emails will be exported as a CSV file. You can convert the CSV file to an Excel workbook easily by Save as feature.

Export emails to separate excel files

Outlook Excel Previewer

With above method, all emails are crowed put into one excel file which does not look well. However, if you have Kutools for Outlook, you can use the Save as File function to save one email as one Excel file.

Outlook Excel Mail Merge Instructions

Free install Kutools for Outlook, and then do as below steps:

1. Click on the email you want to export to Excel file, click Kutools > Bulk Save. See screenshot:

2. Then in the Save message as other files dialog, select one path you want to save the new file, and check Excel format option. See screenshot:

3. Click Ok, and the selected message has been exported as Excel file.

Tip: With the Save as File function, you also export multiple emails to separate Excel files.

Demo

Outlook Excelsior

Kutools for Outlook - Brings 100 Advanced Features to Outlook, and Make Work Much Easier!

Excel Outlook Online

• Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features...
• BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
• Reply (All) With All Attachments in the mail conversation; Reply Many Emails in seconds; Auto Add Greeting when reply; Add Date into subject...
• Attachment Tools: Manage All Attachments in All Mails, Auto Detach, Compress All, Rename All, Save All... Quick Report, Count Selected Mails...
• Powerful Junk Emails by custom; Remove Duplicate Mails and Contacts... Enable you to do smarter, faster and better in Outlook.

Microsoft Word Excel Outlook Training

• To post as a guest, your comment is unpublished.
  I am sad to see that bulk saving email does not put them all in one file. Power Query can do that, but what a waste of space to have two lines used in hundreds of .csv files instead of all in one for the emails selected. Is this happening because I am in an Exchange account, or is it a feature of the program?