More about importing and exporting project data On the last step, click Save Map if you want to reuse it, and then click Finish. On step 5, verify the mapped fields, make adjustments as needed, and click Next. On step 4, pick the type of information you're importing so the wizard can map it from Excel to Project, and click Next.

On step 3, import your data into a new project or the project you have open, and click Next. On step 2, create a map from scratch or pick an available predefined map that matches your data, and click Next. In the Import Wizard, click Next to get started, and follow the steps to complete the import. Locate and select the workbook you want to import, and click Open. In the Open box, click the arrow next to XML Format, and pick Excel Workbook or Excel 97-2003 Workbook (if your project data is in an earlier file format). On the New page, click New from Excel workbook. Just follow the steps to import the data in a new or existing project, and the wizard automatically maps it to the appropriate Project fields. You can do this by using the Project Import Wizard. Click Finish to complete the exporting process.If you started your project in Excel but need to manage more complex schedules, resource sharing, and tracking, you’re probably ready to move your data into Project. 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