Line Values

Separator Character Row

The following first row appears only if you export the project from the Project Planning app:

"sep=,"

This row tells the MS Excel application to open the file expecting a comma (,) as the separator character regardless of a user’s regional settings.

You will see the separator character row only when you open the exported (.csv) file using a text editor such as Notepad, Notepad ++, or WordPad. If you open the exported (.csv) file in MS Excel, you do not see this line.

Header Line

The header line of the CSV file can contain only the following values (case insensitive) as column titles of subsequent lines values:

Only the fields listed in the table below are supported for import/export capability.

Value	Required/Optional
Level	Required. Must be the 1st title of the 1st line.
Name	Required
Type	Required
Dependencies	Optional
Status	Optional, not used
State	Optional
%	Optional
Duration	Required
Duration Offset	Optional
Fixed Start	Optional
Actual Start Date	Optional
Estimated Start Date	Required
Fixed End	Optional
Actual End Date	Optional
Estimated End Date	Required
Owner	Optional
Assignees	Optional
Description	Optional
Priority	Optional
URI	Optional
External Id	Optional
External System	Optional

If another title is set in the 1st line, a warning occurs and the corresponding column is ignored by the import.

Project Line

This line of the CSV file follows the header line and must contain the values that define the root project to import.

• The "level" value must be 0 or left empty.
• The "type" value must be “Project” or left empty.
• The "name" value must not be empty.
• All other values are optional.

Below is an example of the first two lines:

LeveL,type,NAME
 , ,"Root Project"

Another example:

Level,Name,Type
0,Root of import,project

Other Lines

The remaining (nonempty) lines of the CSV file contain the various elements to import under the root project.