Open a task list in Project or Excel
Once you have added tasks to your site, you may want to take your task list data outside of your SharePoint site and into Project or Excel.
Open a task list in Project
While you can plan a simple project by using a task list, some projects require more complex planning. You can open the task list in Microsoft Project Professional 2013 or Microsoft Project Pro for Office 365, if you have either of those products.
To open a task list in Project, click Tasks on the Quick Launch to view the Tasks page. On the List tab, in the Connect & Export group, click Open with Project.
Export task list data to Excel
There may be times when you would prefer to work with your task list in Excel. You can easily export your task list data to Excel on the Tasks page. On the List tab, in the Connect & Export group, click Export to Excel. This opens the task list in Excel so that the data is connected. If a task in the task list is updated, the data in the Excel worksheet is updated the next time it is opened or refreshed. This can help to produce some basic reports or to track multiple projects at once.