Importing into P6 using Microsoft Excel

Also remember, if you generate an XLS Export from P6, the columns marked with an (*) cannot be imported in.

Basic Importing Note P6 using MS Excel

1) Any fields with * are calculated field and cannot be imported

2) There are 5 tables that can be updated using MS Excel such as:

a) Activity table (TASK)

b) Activity Relationships (TASKPRED)

c) Expenses (PROJCOST)

d) Resources (RSRC) - resource library

e) Resource Assignment (TASKRSRC)

Default columns per subject area   ActivitiesActivity RelationshipsExpensesResourcesResource AssignmentsActivity IDPredecessorActivity IDResource IDActivity IDActivity StatusSuccessorExpense ItemResource NameActivity StatusWBS CodeRelationship TypeActivity StatusResource TypeResource IDActivity NamePredecessor Activity StatusBudgeted/Planned CostUnit of MeasureRole IDStartSuccessor Activity StatusActual CostRole IDCost Account IDFinishPredecessor ProjectRemaining CostDefault Units / TimeResource TypeResourcesSuccessor ProjectAt Completion Cost Price / Unit Predecessor WBS  Start Successor WBS  Finish Predecessor Activity Name    Successor Activity Name    Lag    Predecessor Primary Resource    Successor Primary Resource   

Note:

Italic text indicates that the column is required for importing and exporting. The column cannot be removed from the export template and must exist in the import file to import successfully.