How to extract or export tasks list to Excel in Outlook?
While using Outlook, you can extract the task list to Excel for other usage. With the powerful Export feature in Outlook, you can easily export your tasks list to Excel. Please do as below tutorial shows.
Export tasks list to Excel in Outlook
- Automate emailing with Auto CC/BCC, Auto Forward by rules; send Auto Reply (Out of Office) without requiring an exchange server...
- Get reminders like BCC Warning when replying to all while you're in the BCC list, and Remind When Missing Attachments for forgotten attachments...
- Improve email efficiency with Reply (All) With Attachments, Auto Add Greeting or Date & Time into Signature or Subject, Reply Multiple Emails...
- Streamline emailing with Recall Emails, Attachment Tools (Compress All, Auto Save All...), Remove Duplicates, and Quick Report...
Export tasks list to Excel in Outlook
You can do as follows to export your Outlook tasks list to Excel.
1. Open the Import and Export dialog box.
1). In Outlook 2013, click File > Open & Export > Import/Export;
2). In Outlook 2010, click File > Open > Import;
3). In Outlook 2007, click File > Import and Export.
2. In the Import and Export Wizard dialog box, click Export to a file, and click the Next button.
3. In the first Export to a File dialog box, click Comma Separated Values (Window), then click Next.
4. In the second Export to a File dialog box, select the Tasks folder under the email account which you want to export to Excel, then click the Next button. See screenshot:
5. Click the Browse button in the following Export to a File dialog box.
6. In the Browse dialog box, you need to:
1). Select a folder to save the exported file;
2). Name the file in the File name box;
3). Click the OK button.
7. When it returns to the previous Export to a File dialog box, click the Next button.
8. In the last Export to a File dialog box, click the Finish button. See screenshot:
9. In the following Set Date Range dialog box, enter the date range that you want to extract the tasks and then click the OK button.
10. Then the Tasks list is successfully exported. Go to the folder the exported file saved in, and double click to open it.
After opening the exported file, you can see the tasks list is displaying inside.
11. In the opened exported file window, click File > Save As. In the Save As window, select Excel Workbook in the Save as type drop-down list, and finally click the Save button.
Then an Excel workbook with your Outlook tasks list is created successfully.
Best Office Productivity Tools
Kutools for Outlook - Over 100 Powerful Features to Supercharge Your Outlook
🤖 AI Mail Assistant: Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...
📧 Email Automation: Out of Office (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: Easily 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 / Boost Your Outlook Productivity with Tabbed Views / 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 ...
Over 100 Features Await Your Exploration! Click Here to Discover More.