Skip to content
ProjectControls.com
Oracle Primavera - PM6

Data exported from P6 in Excel is in strange, unusable format?

In the Open Standard
David BallMember for 14 years 8 months
Created
4
3
0

Hi,

Whenever I export data from P6 in Excel format the data comes out in a strange format where everything has a "`" in front. For example, 1303FR001 comes out like `1303FR001. And I can't perform a Vlookup or other action as Excel doesn't seem to recognise the data.

Is there a way to export from P6 into Excel and get a "normal", usable output?

 

Thanks very much

 

Dave 

Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Raymund de Laza ·
    #1

    David,Use the export through

    David,

    Use the export through SDK....

    Report
  2. 0
    David Ball ·
    #2

    Thanks very much guys.   Dave

    Thanks very much guys.

     

    Dave

    Report
  3. 0
    Hany Esmael ·
    #3

    There is very easy method

    There is very easy method over here

    Fastest method to export data from primavera p6 to excel

    Report
  4. 0
    Michael Lepage ·
    #4

    Hi A nice plugin for excel is

    Hi 

    A nice plugin for excel is called ASAP Utilities which has a nice feature to remove those apostrophes in excel.  There's a tutorial on updating activities through excel (with ASAP utils) over at https://www.planacademy.com/excellerate-your-updates-how-to-import-your-subcontractors-primavera-updates-from-excel/

    Michael

    Report

Log in or join to reply

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

Log inJoin free

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