Export to Excel (CSV)

Online Help > Export to Excel (CSV)

Exports the information in a textual, comma-delimited format. The exported file can be opened in Microsoft® Excel or any text editor. This format exports the task or resource information in raw table format, with no formatting or outline information.

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.

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>Import/Export>Export Project
  4. Click Export to Excel                                                                                                                                                                                                                                      

5.In folder explorer 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  [1]

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

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.

[1] These steps are only available on Project Plan 365 for Win PC/Server.