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
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)
![Jamie](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)
![Bianca](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)
![toni cummins](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)
![John](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)
![Jeff K](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)