How to Export Your Outlook Tasks in Batches to an Excel File

This article will look at the method to extract your Outlook tasks list to an Excel file. If you often need to print the elaborate task details, it is suggested to export them to Excel in advance.

As a regular user of Outlook, I’ve served it not only as an email client but also a task manager. I created multiple Outlook tasks. But if I don’t open my computer, I totally cannot remember them. In order to avoid this situation, I prefer to print the task lists. Instead of printing in Outlook, I prefer to export the tasks to an Excel file firstly and then print in Excel. Now I will introduce how to export them to Excel.

Export Outlook Tasks in Batches to an Excel File

  1. At the very outset, in Outlook, go to “File” > “Open” > “Import”.
  2. You will see a new dialog box of “Import and Export Wizard”, in which you should choose “Export to a file” action. And click “Next” button.Export to a file
  3. In the subsequent screen of “Export to a file”, you need to select “Comma Separated Values (Windows)”. And press “Next”.Comma Separated Values (Windows)
  4. Next you need to choose the folder to export from. Of course you ought to choose “Tasks” folder. After the selection, click “Next”.Select the folder to export from
  5. In the following screen, you should click “Browse” button.
  6. A new window will pop up. You need to choose the destination folder to save the exported Excel file. And specify a name for this file, such as “My Tasks”. And then click “OK”.Browse to
  7. After backing to “Export to a file” dialog box. Just Click “Next”.
  8. Later, you will get into the final interface of “Export to a file”. If you have no special requirements, click “Finish” button straightly
  9. After that, another dialog box of “Set Date Range” will arise. As its name suggests, you can restrict the date range of the Outlook tasks to be exported.Set Date Range
  10. After the export progress, you will see a CVS file in the destination folder. You can double click to open it by MS Excel. You can see all the tasks.Outlook Tasks in Excel File
  11. Due to the fact that the file is CSV file indeed, you need to resave it as an Excel file. Go to “File” > “Save As”. In the new popup window, set “Save as type” to “Excel Workbook”. And click “Save”.Save as excel workbook
  12. Finally you will get a new Excel file.CSV file vs Excel file

Protect Outlook from Being Attacked

Nowadays viruses have been increasingly complex. Thus in order to protect Outlook, you should keep an eye on all potential risks. Besides, you have to procure a versatile repair tool like DataNumen Outlook Repair. In case that you come across severe Outlook crashes, it still can recover Outlook data in a jiffy.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql recovery and outlook repair software products. For more information visit

Comments are closed.