These are just a few of our ideas of how Export to Excel can help you get more out of Project-but we want to hear how you are using it! Leave us a comment below on your experiences so far. For Printing: Print your project in Excel in a format that makes it easier for senior management to consume.For Archiving: Archive your completed projects in Excel to quickly share your compliance and maintain an external record of your work.Easily delete information you do not wish to share with others such as providing high-level executive summaries without unnecessary details. For sharing: Use Export to Excel to share your project status with guest users, vendors, or your clients who do not have access to Project.

Some snapshots of the charts created on top of Excel are: You can then share this information with your team or drop into presentations. You can quickly sort the task by their finish dates or filter information to find out the completed tasks. For reporting: You will now be able to use the data you export from Project to create charts, pivot tables and more in Excel.Click Finish to complete the exporting process.There are multiple scenarios for Export to Excel, here are some to help you get started: It will be added to the predefined map list. On the Export Wizard End of Map Definition step, select Save Map if you want to use it again in the future, and type a name in the Map name box. If necessary, select a specific export filter from the “Export Filter” box. Edit any mapping assumptions made by Microsoft Project and add any new mapping fields to the Task Mapping, Resource Mapping, or Assignment Mapping processes. Select the data types you are exporting and the options you want in the Export Wizard Map Options section. Step 4: Edit the Export Wizard Map Options Data.Then, on the Map step, choose New Map to create your own data settings for mapping your data from Microsoft Project fields to the proper Excel fields. On the Data step, choose Selected Data if it’s not already selected. Step 3: Begin with the Export Wizard OptionĪfter clicking Save, the Export Wizard appears.Then in the File name box, type the name you want, and choose Save. Choose “Save Project as File” and double-click on Microsoft Excel Workbook under the Other File Types option.Ĭhoose the workbook’s location in the Save As dialog box. Go to the File Menu, then select the Export option. Open the project that needs to be in Excel format in your Microsoft Project. Not only will this provide you with a breakdown of your task, but it will also give you an overview of when your projects may start and end. How to Export from Microsoft Project to ExcelĮxporting your output in Microsoft Project to Microsoft Excel has its perks, especially when you want to create a visual timeline graph or a Gantt chart to map out your project schedules and phases.

Export gantt chart ms project