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 multiple emails to excel file
Export emails to separate excel files
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
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.
Kutools for Outlook, includes powerful features and tools for Microsoft Outlook 2019, 2016, 2013, 2010 and Office 365. | ||
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
Best Office Productivity Tools
Breaking News: Kutools for Outlook Launches Free Version!
Experience the all-new Kutools for Outlook FREE version with 70+ incredible features, yours to use FOREVER! Click to download now!
🤖 Kutools AI : Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...
📧 Email Automation: Auto Reply (Available for POP and IMAP) / Schedule Send Emails / Auto CC/BCC by Rules When Sending Email / Auto Forward (Advanced Rules) / Auto Add Greeting / Automatically Split Multi-Recipient Emails into Individual Messages ...
📨 Email Management: Recall Emails / Block Scam Emails by Subjects and Others / Delete Duplicate Emails / Advanced Search / Consolidate Folders ...
📁 Attachments Pro: Batch Save / Batch Detach / Batch Compress / Auto Save / Auto Detach / Auto Compress ...
🌟 Interface Magic: 😊More Pretty and Cool Emojis / Remind you when important emails come / Minimize Outlook Instead of Closing ...
👍 One-click Wonders: Reply All with Incoming Attachments / Anti-Phishing Emails / 🕘Show Sender's Time Zone ...
👩🏼🤝👩🏻 Contacts & Calendar: Batch Add Contacts From Selected Emails / Split a Contact Group to Individual Groups / Remove Birthday Reminders ...
Instantly unlock Kutools for Outlook with a single click—permanently free. Don't wait, download now and boost your efficiency!
![kutools for outlook features1](http://cdn.extendoffice.com/images/stories/kto-ad-sun/kto19.0-kutools-100.png)
![kutools for outlook features2](http://cdn.extendoffice.com/images/stories/kto-ad-sun/kto19.0-plus-100.png)