Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

IMPORTING EXCEL FILES INTO P3

In the Open Standard
Sriram IyerMember for 22 years 11 months
Created
3
4
0
Helllo,
Can u suggest me to Import the Excel data file in to P3.

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Sen Moc ·
    #1
    In P3, go to Tools/Project Utilities/Import...

    But before importing the Excel Data, make sure that the cell formats, column headings, etc matches with P3.

    To be sure, create first an initial project in P3, create at least 1 or 3 temporary activities then Export to Excel.
    Transfer your data to this exported file. Then Import this.

    Regards.
    Report
  2. 0
    Sukumaran Subaramaniyan ·
    #2
    Sriram,

    Save the Excel file using the following file extension before you import the data:
    a) Lotus 123 - .WKS / .WK1, or
    b) dBASE III - .DBF

    P3 does not support excel extension.

    Cheers!!!
    Report
  3. 0
    Simon Mawdsley ·
    #3
    A tip is to export a simple project to excel first so you are certain to have the exact column headings when you import them back.

    Remember it’s ok to delete some of the columns as you can import part of the data only. Just be careful of the information that is contained in hammocks, it’s best to filter these out until you are confident about the export/import routine.
    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?