Skip to main content

How to extract or export tasks list to Excel in Outlook?

Author: Siluvia Last Modified: 2014-12-08

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

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 2021 - 2010 or Outlook 365 with these advanced features. Enjoy 70+ powerful features and elevate your email experience!

arrow blue right bubbleExport 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 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



Comments (7)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
This works for me, but the exported file was missing some tasks. And those tasks were definitely within the time range.
This comment was minimized by the moderator on the site
once I export in excel. will the tasks be removed from my outlook? I DO NOT want that to happen. I just want to have a copy in excel of it.
This comment was minimized by the moderator on the site
I have a shared folder of tasks and I want to export this to excel - it only shows my email box and not the 'shared tasks' any ideas how I do this please?
This comment was minimized by the moderator on the site
Worked like a charm for me.
This comment was minimized by the moderator on the site
I'm usually the one that has the crashes and no success. This time, worked like a charm...exactly as stated!!! Good luck to all.
This comment was minimized by the moderator on the site
Outlook stops working and the export fails
This comment was minimized by the moderator on the site
This seems very simple, but Outlook crashes every time I try this and does not export any data.
There are no comments posted here yet
Leave your comments
Posting as Guest
Rate this post:
0   Characters
Suggested Locations