You can change field order in the Export Wizard dialog when exporting to Excel by clicking on up/down arrows near Move from the Mapping section.  Note: The option to change field order in the Export Wizard dialog when exporting to Excel is available only on Windows and Mac platforms.

You can export to excel all the available types of data: Tasks, Resources and Assignments, in one file by selecting all of them from the Map Options section in the Export Wizard dialog. You will then be asked to set mapping settings for each type of data. The exported file will have 3 separate worksheets for each type of project information with the selected settings.Note: The option to export to Excel more than one type of data is available only on Windows and Mac platforms.

To export Assignments to Excel on Windows and Mac platforms, for the desired project, go to menu File – Export – Export to Excel. Select a location, type in a name and click Save. In the Export Wizard dialog that appears, select the Selected Data option and click Next. In the Map Options section select Assignments then click Next. In the Assignments Mapping section, type in a name for the Worksheet then either click on Add All button to add all the available project fields or manually add some fields by clicking on a row and opening field picker. Click Finish for the file will be exported with the selected settings. Tips: You can move the rows order by selecting a row and clicking on up/down arrows near Move. You can add/remove rows by clicking Insert Row or Delete Row buttons. You can add/remove all the available resource fields by clicking Add All or Clear All buttons.

To export to Excel tasks with Filter on Windows and Mac platforms, for the desired project, go to menu File – Export – Export to Excel. In the Export Wizard dialog that appears, select the Selected Data option and click Next. In the Map Options section select Tasks then click Next. In the Task Mapping section, open the Export Filter drop-down menu and select the desired filter. Type in a name for the Worksheet, write or select the desired task fields or base table and click Finish. The file will be exported with the selected filter. Tips: You can move the rows order by selecting a row and clicking on up/down arrows near Move. You can add/remove rows by clicking Insert Row or Delete Row buttons. You can add/remove all the available resource fields by clicking Add All or Clear All buttons.

To export to Excel tasks from table including assignments in output on Windows and Mac platforms, for the desired project, go to menu File – Export – Export to Excel. Select a location, type in a name and click Save. In the Export Wizard dialog that appears, select the Selected Data option and click Next. In the Map Options section select Tasks, from the Microsoft Excel Options select Include assignments rows in output option then click Next. In the alert that appears click Yes. In the Task Mapping section, type in a name for the Worksheet, write or select the desired task fields by clicking on a row and opening field picker and click Finish. In the exported task sheet will be added resource assignments information after each task. Tips: You can move the rows order by selecting a row and clicking on up/down arrows near Move. You can add/remove rows by clicking Insert Row or Delete Row buttons. You can add/remove all the available resource fields by clicking Add All or Clear All buttons.

To export to Excel resources from table on Windows and Mac platforms, for the desired project, go to menu File – Export – Export to Excel. Select a location, type in a name and click Save. In the Export Wizard dialog that appears, select the Selected Data option and click Next. In the Map Options section select Resources then click Next. In the Resource Mapping section, type in a name for the Worksheet, click on Based on Table… button, select the desired base table and click OK. The mapping in the grid will be completed with the columns from the selected table. Click Finish for the project to be exported to excel with the selected settings. Tips: You can move the rows order by selecting a row and clicking on up/down arrows near Move. You can add/remove rows by clicking Insert Row or Delete Row buttons. You can add/remove all the available resource fields by clicking Add All or Clear All buttons.

To export to Excel tasks from table on Windows and Mac platforms, for the desired project, go to menu File – Export – Export to Excel. Select a location, type in a name and click Save. In the Export Wizard dialog that appears, select the Selected Data option and click Next. In the Map Options section select Tasks then click Next. In the Task Mapping section, type in a name for the Worksheet, click on Based on Table… button, select the desired base table and click OK. The mapping in the grid will be completed with the columns from the selected table. Click Finish for the project to be exported to excel with the selected settings. Tips: You can move the rows order by selecting a row and clicking on up/down arrows near Move. You can add/remove rows by clicking Insert Row or Delete Row buttons. You can add/remove all the available task fields by clicking Add All or Clear All buttons.

To export to excel using a Project Excel Template on Windows and Mac platforms, for the desired project, go to menu File – Export – Export to Excel. Select a location, type in a name and click Save. In the Export Wizard dialog that appears, select the Project Excel Template option then click Finish. The project will be exported to Excel in .xlsx format based on a template.

In order to export to Excel only the summary tasks, you need to apply the "Summary Tasks" filter. In order to do that, go to the Project menu - Filter - Summary Tasks. After that, go to the File menu - Export - Export to Excel, type the name of the file and press "Save". Follow the steps from Export Wizard and click Finish.Note: On iOS and Web platforms, when going to menu File – Export – Export to Excel, just select the desired file location and click Save. The project will be saved in .CSV format.

Example for how to export to Excel a sample project from c:\my files folder with Project Plan 365:

ProjectPlan.exe /csv “c:\my files\sample.mpp”- this command will create sample.csv file in c:\my files folder.

For automation purposes, the following script sample can be used (exportCSV.bat):

@echo off

set PP="C:\Program Files (x86)\Husatonic\ProjectPlan365\ProjectPlan.exe"

cmd /c "%PP% /csv %1"

if %ERRORLEVEL% neq 0 (

echo Export error for %1

) else (

echo Successfully exported %1

)

Usage: exportCSV.bat projectpath

PP variable should be set to actual application path – export result will be displayed on the screen. The exported file will be added to projectpath location.

It is available for Gantt Chart, Tracking Gantt and Task Sheet views. By using this option, the content of the list of tasks will be exported in a CSV format.Note: Using an automatic command can export projects to excel only in .CSV format.

Exporting a project to Excel via an automatic command is only available on Project Plan 365 for Windows.

General command line syntax:

ApplicationName [/switch] projectpath

/csv – export to Excel file (CSV format) for default view (currently supported views are: Gantt Chart, Task Sheet, Resource Sheet and Team Planner).Note: Using an automatic command can export projects to excel only in .CSV format.

To export a project to an excel file follow these steps:1. Open desired project file.2. Open desired views (Gantt Chart, Tracking Gantt, Resource Sheet, Task Sheet, Team Planner).3. Go to menu File– Export – Export to Excel.4. Select the desire file location and click Save.5. In the Export Wizard dialog that appears, select the desired option: Project Excel Template or Selected Data.6. Follow the steps from the Export Wizard and click Finish for the file to be exported in a .XLSX format.Note: On iOS and Web platforms, when going to menu File – Export – Export to Excel, just select the desired file location and click Save. The project will be saved in .CSV format.

The Dashboard functionality allows you to aggregate multiple project files (either located on your machine or online) in a virtual master project to help you get a higher-level perspective on your projects.

I want to export my plan, but it keeps showing me an alert box saying "There is no email, you need to configure an email account to use this feature" after I choose any option in export to (pdf, image, mpp)

The message that you received should only appear if you don’t have an email account set up and emails cannot be sent. This is not our implementation, we just ask the system if a mail can be sent and if the answer is Yes we then proceed with our implementation.

Please check Settings - Contacts - Default account to make sure the correct account is set. Also, you need to make sure that you have the correct credentials in Mail app. We found a discussion thread about a similar issue, maybe it helps: Apple Discussion.

To export the tasks to your personal calendar, follow the steps below:

1. Go to menu Share – Export – Export to My Calendar.
2. On the Reminder section you can select when to be notified: None, On Start or 15 minutes before.
3. On the Items section you can select to export the tasks from the entire project (Project option), the tasks from the current view (View option) or the selected tasks (Selected option).
4. On Details section you can select what information to export about the tasks: Task Name, Notes, Resource Names.
5. On the Criteria section you can specify the criteria to export the tasks: No criteria, Only the future tasks (Future only option) or Milestones only.