plan better with vPlanner
 
×

Exporting to MS Project CSV

 
This export dialog produces CSV files that are formatted according to Microsoft Project defaults to make it possible to import the exported CSV file into Microsoft Project without having to map the attributes manually.
 
The export dialog allows you to select a destination file name, then you can select the sort order of the tasks.  By default, all options will be sorted by LF and then by FF dates.  The CSV file is comma delimited.  When you read it in Microsoft Project, select file Open, then select CSV as the file type and in the Open dialog make sure to specify Comma as the delimiter type.
 
vPlanner will export LRM dates as the Baseline start/finish dates and will export forecast dates as MS Project Start/Finish dates.  Committed tasks will have 50% percent completed status to identify that they are work-in-progress.  Completed tasks will have a 100% percent complete status.  The vPlanner LF date will be exported as the Deadline date in MS Project.
 
Exporting to MS Project CSV
1

Export File Location

1. Export File Location
Select the file and path for the export.
2

Date Format

2. Date Format
Select desired date format that is most suitable to your MS Project Preferences and Language Settings.
3

Time zone

3. Time zone
Since MS Project is not time zone aware, you will need to specify to which timezone vPlanner should export its dates. 
4

Group Options

4. Group Options
Those grouping options will apply to the exported tasks.  The CSV file will be grouped based on those items and the sort option.
5

Sort

5. Sort
Specify what attribute to use to sort the results.
6

Task Description Options

6. Task Description Options
If this option is enabled, vPlanner will create composite task descriptions during the export that include the prefix and suffix information of the defined tasks.  Otherwise, the task description will be exported.
7

Committed Dates Option

7. Committed Dates Option
If enabled, Committed dates will override the Start and Finish dates of activities that are exported to MS Project.
8

Export

8. Export
Click here to export the tasks, or cancel to abort.