Skip to main content
All CollectionsMaster Schedule SynchronizationFor P6 Users
Export tickets from P6 in an .xlsx Format
Export tickets from P6 in an .xlsx Format

Export tickets from P6 in an .xlsx format to import into Touchplan

Sarah Cusack avatar
Written by Sarah Cusack
Updated over a week ago

To export a file from P6 in an .xlsx format:

  1. Open the P6 file that will be exported

  2. Select File

  3. Click Export

  4. Select Spreadsheet - (XLSX) from the Export Format pop up window

  5. Click Next

  6. In the Export Type pop window, check off Activities and Activity Relationships

  7. Click Next

  8. Select a template from the Template list

  9. Click Modify if using an existing template

    Note: if users do not want to use an existing template, create a new template by selecting Add

  10. Click Activity Codes - Global

  11. Select the Columns that need to be import. The following fields must be selected: Activity ID, Activity Status, WBS Code, Actual Finish, Actual Start, Planned Finish, Planned Start, Actual Duration, Original Duration, Activity Name

  12. Click OK

  13. View the summary and click Finish.

  14. Click Close.

Did this answer your question?