In the Export Wizard - End of Map Definition dialog, click Save Map so that so that we can reuse the map for future exports of Tasks. When you are done adding fields, click Next. In this example, I have added ID, Name, Duration, Start, Finish,Task Calendar and Summary fields (the reason for adding the Summary field will become clearer later).

You would notice that as you add fields to the left column (From: Microsoft Project Field), the same fields are automatically added to the right column (To: Excel Field). Now, click and add the fields you would like to export to Excel. In the Export Wizard - Task Mapping dialog box, you will see a message (click here to map a field) In the Export Wizard - Map Options dialog box, tick Tasks and Export includes headers then click Next. Just like Primavera P6, Microsoft Project also allows export of Tasks, Resources and Resource Assignments but in this tutorial we are only going to export Tasks. In the Export Wizard - Map dialog box, tick New map and then click Next. In the Export Wizard dialog box, click NextĪnd in the Export Wizard - Data dialog box, tick Selected Data option and then click Next To export to Excel in Microsoft Project, go to File > Save as and from the Save as type dropdown box, select Excel Workbook(*.xlsx) and then click on Save button. Unfortunately Microsoft Project does not have the option to right-click and export to Excel. To export in Primavera, right-click anywhere in the Activity Table and click Export to Excel and save the Excel file.Īnd the newly created Excel file looks like a proper Excel Table as shown below. In Primavera P6, exports to Excel come formatted as an Excel Table for any data analysis you might want to carryout but with Microsoft Project, you still need to format the Excel properly prior to any Excel Table data analysis.

If you have ever used Primavera P6, you would be surprised that exporting from Microsoft Project to Microsoft Excel does not provide you with a ready to be used data considering that both products are from the Royal House of Microsoft.

How to export gantt chart in ms project