Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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 filesgood idea3

Kutools for Outlook: 100+ New Advanced Tools for Outlook.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013, 2016 and 2019.

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:
doc export email to excel file 1

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

3. Click Microsoft Excel 97-2003 in Export to File dialog, and click Next again.
doc export email to excel file 3

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.
doc export email to excel file 4

5. Then click Browse to select a folder and give a file name to the files. See screenshot:
doc export email to excel file 5
doc export email to excel file 6

6. Click OK > Next to go to the last step, click Finish.
doc export email to excel file 7

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.
doc export email to excel file 8

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 20+ powerful features and tools for Microsoft Outlook 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 > Save as File. See screenshot:
doc export email to excel file 9

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:
doc export email to excel file 10

3. Click Ok, and the selected message has been exported as Excel file.
doc export email to excel file 11

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

 

100+ Powerful Tools and Features for Outlook 2010 / 2013 / 2016 / 2019 / Office 365:

li-orangeCompatible with Outlook 2010 / 2013 / 2016 / 2019 / Office 365 (32/64);

li-orangeCompatible with Windows XP, Windows Vista, Windows 7 / 8 / 10, Windows Server 2003/2008, Citrix System and Windows Terminal (Remote Desktop) Server;

li-orangeFree trial without feature limitation in 45 days!

READ MORE | FREE DOWNLOAD | BUY NOW

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.