When you need to keep track of tasks and share them with others, Export Task List from Outlook to Excel can be a helpful solution.
This tutorial will show you how to export your task list from Outlook to Excel, so that you can track and manage your tasks more easily, not only that you can modify the comprehensive list easily in Excel and import back to Outlook.
There are multiple purposes to exporting tasks from Outlook in Excel if you often need to print the elaborate task details.
You may want to update all or some of your tasks, back up the task, or make a list of your priority tasks so that your partner can take care of them during your vacation.
Steps to Export Outlook Tasks to Excel using the Import and Export function
Exporting task is quite a similar process to importing, follow the steps below:
Step 1: – Open Microsoft Outlook
Step 2: – Click the File Tab from the top left corner of the screen.
Step 3: – Click Open and Export >> Click Import and Export
Step 4: – Import and Export Wizard dialog box appears, click Export to a file, and click the Next button.
Step 5: – Select Comma Separated Values, then click Next.
Step 6: – Select folder to export from: Since we are exporting our Outlook Tasks, we choose task under the Outlook node, as shown in the screenshot below, and click Next to continue.
Step 7: – Once you have selected the task folder from your email address and now you need to specify where you want to save them. Click the Browse button to select a destination folder to save the exported file to.
Step 8: – Now you have to type the name of your exported file in the ‘File name field and click OK.
Step 9: – Later, you will get into the final interface of ‘Export to a file. If you have no specific requirements, click the ‘Finish’ button straight.
Step 10: – All set, in the final dialog box, you need to ‘Set Date Range‘. It is mandatory to set your date range you can’t bypass it. Only appointments or tasks that fail within the following date range will be exported.
Step 11: – Your Tasks list is successfully exported. Go to the folder you have selected your exported file saved in and double-click to open it.
That’s it! All of your Outlook tasks are exported to a .csv file and now you can open it in Excel for reviewing and editing.
- Go to File Tab >> Click Save as
- Set Save as type to Excel Workbook and finally click save.
Copy and Paste Approach
Another method to export Outlook tasks to an excel sheet is copying and pasting, there are several advantages to exporting tasks by copying/pasting compared to using the Import and Export wizard.
For example, you have more control over the process and can customize the outcome to better suit your needs.
Additionally, it is often faster and easier to simply copy and paste tasks than to go through the Import and Export wizard.
Manually copying and pasting Outlook contacts may be faster and more convenient than using the Import/Export function.
This approach is compatible with all Outlook versions and can be used to export your contacts to any Office application where copy/paste is supported, not just Excel.
- Press CTRL+A to select all the Tasks available in the to-do list and then press CTRL+C to copy them to the clipboard.
- Open a new Excel spreadsheet. Select cell A1 or any other cell that you want to be the first cell of your table. Right-click the cell and choose Paste from the context menu or press CTRL+V to paste the copied contacts.
- Save your Excel sheet.
In summary, the steps to export your Outlook tasks to Excel are super easy since Microsoft provides two such methods.
If you have any questions or feedback, please let me know. Thank you for reading!