Skip to content

P6 Professional R19.12 Importing a WBS from Excel

Steven MontgomeryMember for 9 years 6 months
Created
2
3
0

Hello,

I would like to import a WBS from MS Excel to P6 Professional. I attempted to do this by first exporting a P6 schedule to MS Excel so make sure I have the correct format. Unfortunately, P6 Professional does not import Excel data that has a column heading including an (*). This means P6 will not import WBS Path, WBS Name, and WBS Category. Also, for some reason I was unsuccessful importing the WBS Code as well.

What is the most efficient way to import a WBS from MS Excel to P6 Professional? My WBS is over 400 lines. I would also be nice to include the Summary Scope of Work with the WBS.

Am I better off manually inputing the WBS directly into P6 Professional?

Any input?

 

--Steve

2 replies

Oldest first
  1. 0
    Rodel Marasigan ·

    Hi Steven,You cannot use P6

    Hi Steven,

    You cannot use P6 import/export function in excel to create a WBS dictionary into P6 Project. The best way is to use the excel XER parser & builder. You can create a WBS dictionary for a project using this tools. But you need to learn how to use it first. See link for your reference. How to Import WBS using excel XER parser

  2. 0
    Mohammed Ali ·

    See this amazing tool to

     
    • See this amazing tool to design and export the WBS from Excel to Primavera.
    • You can prepare thousands of WBS Elements in few minutes.
    • It runs on all Excel versions 32 bit and export to any version of Primavera.
    • Learn about it from these group of Videos, if you would like to get it leave your Email.

    https://www.youtube.com/playlist?list=PLFPaRgp0OMtk3Fl88xFKiQjpBD4CnLm0U

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?