Exporting Project Plan Plan to Excel with MS Project Professional 2010
Please Follow the Steps which allow to export to Excel by retaining the formatting of MS Project Professional
1. Select all the Tasks with corresponding details from the Gantt Chart view.
2. Note where the file is being saved
3. Under the Save As Type, select Excel Workbook
4. Click on Save. This starts the Export Wizard
5. Choose Selected Data, then Click Next.
6. Then click on Use Existing Map, then Next
7.Choose the Proper option according to your requirement. i.e. "Task and Resource Pivot table Report"
7.Choose the Proper option according to your requirement. i.e. "Task and Resource Pivot table Report"
8. Select Task and Resource as Type of Project Information and Choose Export Includes headers
9. Click on Next until it is no longer available, then click on Finish
Thanks Casey
ReplyDeletethe idea of exporting to Excel is so that I can use the data. But it exports everything as text, which defeats the purpose. Is there a way to export and value and numbers?
ReplyDeleteI love this blog!! The flash up the top is awesome!!
ReplyDeleteexcel vba courses london
Thank you for your feedback !!
DeleteCan I somehow export critical path data to Excel
ReplyDeleteThanks for sharing this knowledgeable post. I will follow your tips for my project management. Now you can use project resource management tool for your business, which is very helpful to save important information in less time.
ReplyDeleteKeep sharing such interesting article.
Is there a way to export the values and numbers?
ReplyDeleteIn MS Project 2007 when the actual date column is not populated, it places an N/A in that field.
In MS Project 2013 when the actual date column is not populated, it places a time stamp (12:00:00 AM) in that field.
Aslo, it export the % complete field as a text type data instead on a number.
Please someone help me I'm going crazy
Earl
Really well information. Thanks a lot. Here, I got the special deals for Microsoft Project Professional and many more .Our specialty is quick email delivery. You will get 24/7 support. So let’s check it out.
ReplyDelete