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

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.

J
Johannes Vandenberg 👤 Member for 16 years 4 months

Hi Yaron

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

Z
Zoltan Palffy 👤 Member for 16 years 10 months

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

S
Santosh Bhat 👤 Member for 21 years 1 month

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.

 

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts