So you would like to be able to quickly examine your project schedule to see which tasks your team should be working on this week…or…maybe you would like to see which tasks you should work on next week. The following is a dynamic approach, quick to implement, and will meet this need.
Export MS Project to Excel, Update, Then Import Updates Back Into MS Project
1. Open the project in MS Project
2. Click on >File, >Save As. Choose the location where you would like this file to be saved.
3. Click on the dropdown for Save as type and select Microsoft Excel Workbook (*.xls)
Copy Data from Microsoft Project and Paste into Excel
1. Create a view that contains the desired data
2. Select the data you would like to copy within Microsoft Project
Getting Data From Microsoft Project to Excel
There are a number of ways in which we can get data from Microsoft Project to Excel. Some are easy. Some are harder. Some depend upon the version of Microsoft Project you leverage. This article will list the different ways and the strengths and weaknesses of each approach. Future articles will provide detailed steps on the respective approaches.
Understanding Colors and Indicators on My Tasks Page
The Tasks page displays your assigned tasks and may display a number of graphical indicators. The following table describes these indicators and their meanings.
Page 1 of 2


