Skip to content

List of activities in excel - Best way to copy to Primavera

Yaron AvramovMember for 13 years 5 months
Created
3
3
0

I have a list of about 1000 activities in an Excel file, and I want to copy them to a project in Primavera.

What would be the easiest way to do that?

I only need to copy the activity names, I will set the relationships, durations and dates later.

Any suggestions? 

Thanks for any help.

3 replies

Oldest first
  1. 0
    Santosh Bhat ·

    Excel import.Within P6,

    Excel import.

    Within P6, create a single activity, then FILE>EXPORT>XLS>ACTIVITIES> and set a locaton and file name to export to.

    Open this file in Excel, then use the single activity as a template and populate the remaining rows. Save and close the xls file.

    Back in P6 FILE>IMPORT>XLS and point to the saved xls file and you should have a list of activities to work with.

     

  2. 0
    Zoltan Palffy ·

    you will have to assign the

    you will have to assign the proper wbs after importing the activities 

  3. 0
    Johannes Vandenberg ·

    Hi YaronPerfectely  explained

    Hi Yaron

    Perfectely  explained by Zoltan & Santosh.  If you like to see more check out this screen caputure.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?