Skip to main content
 

 Quickly export the emails or tasks listing information to Excel file from Outlook

Author: Xiaoyang Last Modified: 2024-06-21

Supposing, you need to export the emails or tasks listing information to an Excel file, normally, the Import / Export feature in Outlook can help you to export all emails. But, here, I will introduce an easy tool-Kutools for Outlook’s Quick Report, with this utility, the information of the messages or tasks in any selected folder will be exported to an Excel file.

Generate an XLM report file for the emails listing information
Generate an XLM report file for the tasks listing information

Office Tab - Enable Tabbed Editing and Browsing in Microsoft Office, Making Work a Breeze
Unlock Kutools for Outlook's free version now and enjoy over 70 features with unlimited access forever
Boost your Outlook 2024 - 2010 or Outlook 365 with these advanced features. Enjoy 70+ powerful features and elevate your email experience!

Generate an XLM report file for the emails listing information

To export the information of messages in Inbox, Sent Items or other folders, please do as this:

1. Select the email folder that you want to export, and then click Kutools Plus > Quick Report > Quick Report, see screenshot:

2. And then, in the displayed Save Report window, choose a folder to locate the file, and specify the file name as you need, and then click the Save button.

shot quick report 2

3. A message box pops out to remind you if you want to open the exported file, see screenshot:

shot quick report 3

4. Click Yes to open the file, and you can see the emails' information displayed in an Excel workbook as shown in the screenshot below.

shot quick report 4

Note: By default, the exported email fields are Subject, From, Received Time, Size, Categories and Importance. You can specify the fields to be exported as you need. Please do as follows:

1) Click Kutools Plus > Quick Report > Settings.
2) In the Quick Report Settings dialog box, only check the fields you want to export, and then click OK to save the changes. Or you can click the Quick Report button to export the email information with the newly specified fields.

Generate an XLM report file for the tasks listing information

To export the information of tasks to Excel, please do with the following steps:

1. Go to Task pane, select the task folder you want to export, and then click Kutools Plus > Quick Report > Quick Report to apply this utility.

2. In the displayed Save Report window, choose a folder to locate the file, specify the file name as you need, and then click the Save button.

shot quick report 5

3. A message box now pops out to remind you if you want to open the exported file, see screenshot:

shot quick report 3

4. Click the Yes button, and you can see the tasks' information displayed in an Excel workbook as shown in the screenshot below.

shot quick report 6

Note: By default, the exported task fields are Subject, Start Date, Due Date, Size, Categories and Importance. You can specify the fields to be exported as you need. Please do as follows:

1) Click Kutools Plus > Quick Report > Settings.
2) In the Quick Report Settings dialog box, only check the fields you want to export, and then click OK to save the changes. Or you can click the Quick Report button directly to export the task information with the newly specified fields.

Demo: Quickly export the emails or tasks listing information to Excel file

Discover the Kutools / Kutools Plus tab in this video, added by Kutools for Outlook. Now, most features, including AI functionalities, are free! Pro features come with a 30-day trial without limitations!


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 : Uses advanced AI technology to handle emails effortlessly, including replying, summarizing, optimizing, extending, translating, and composing emails.

📧 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 ProBatch 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 kutools for outlook features2