Export to Excel (CSV)

Export to Excel it is available for Gantt Chart, Tracking Gantt, Resource Sheet,Task Sheet and Team Planner views.

​​You can export your project data to Excel for in-depth data analysis by using this option, the content of the list of tasks/ resources will be exported in a CSV format.

This format exports the task or resource information in raw table format, with no formatting or outline information.​

The exported file can be opened in Microsoft® Excel or any text editor.

How to export information from a view:

Example:

  1. Open desired project file
  2. Open desired views (Gantt Chart, Tracking Gantt, Resource Sheet,Task Sheet, Team Planner )
  3. Click File > Export
  4. Under Export, click Export to Excel                                                   export to Excel.jpg

  5. In folder explo​rer type the name you want in the File name box or leva the auto generated name, and click Save.

Export to Excel( csv) using automatic command
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)
 
How to export information ​using command
Example:
            to export to Excel a sample project from c:\my files folder using Project Viewer 365:
            ProjectViewer.exe /csv “c:\my files\sample.mpp”
- this command will create sample.csv file in c:\my files folder.
 
For automation purposes following script sample can be used (exportCSV.bat):
@echo off
set PV="C:\Program Files (x86)\Viewer Central\ProjectViewer365\ProjectViewer.exe"
cmd /c "%PV% /csv %1"
if %ERRORLEVEL% neq 0 (
     echo Export error for %1
  ) else (
     echo Successfully exported %1
  )
Usage: exportCSV.bat projectpath
 
PV variable should be set to actual application path – export result will be displayed on screen. Exported file will be added to projectpath location.

Learn more:
Export to PDFExport to MPPExport to XMLExport to PowerPoint
Applies to version 2015 and higher.
Project Plan 365 for:
Win PC/Server
Project Viewer for:
Win PC/Server