• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Site-Logo
Phone 703-910-2600

Ten Six Consulting

Project and Earned Value Management, Primavera P6 & Deltek Cobra & Acumen Services

703-910-2600
  • Training Classes
    • Primavera P6 Training
    • Deltek Training
    • Earned Value Management Training
    • Project Management Training
    • Open Training Class Dates
  • Scheduling Services
  • Earned Value Mgmt. Services
    • RFP Support
    • Your EVM System
    • Certification
    • Data Analysis and Reporting
    • Post Contract Support
    • Staff Augmentation
    • WBS Guidelines for Government Acquisition Programs (MIL-STD 881D)
  • Tools
    • Primavera P6
      • Knowledge Transfer, Mentoring and Coaching
      • BI Publisher Services
    • Primavera Unifier
    • Deltek Cobra
      • Knowledge Transfer, Coaching and Mentoring
      • Staff Augmentation
    • Microsoft Project to Primavera P6 Conversion Services
    • Microsoft Project
      • Building an Integrated Master Schedule (IMS)
      • Integrating Microsoft Project with Deltek Cobra
      • Migrating From Microsoft Project To Oracle Primavera P6
  • Blog
    • Deltek Acumen
    • Deltek Cobra
    • Earned Value Mgmt
    • Microsoft Project
    • PMO
    • Primavera P6
    • Project Management
    • Risk Management
  • Clients
  • Contact Us
  • Training Classes
    • Primavera P6 Training
    • Deltek Training
    • Earned Value Management Training
    • Project Management Training
    • Open Training Class Dates
  • Scheduling Services
  • Earned Value Mgmt. Services
    • RFP Support
    • Your EVM System
    • Certification
    • Data Analysis and Reporting
    • Post Contract Support
    • Staff Augmentation
    • WBS Guidelines for Government Acquisition Programs (MIL-STD 881D)
  • Tools
    • Primavera P6
      • Knowledge Transfer, Mentoring and Coaching
      • BI Publisher Services
    • Primavera Unifier
    • Deltek Cobra
      • Knowledge Transfer, Coaching and Mentoring
      • Staff Augmentation
    • Microsoft Project to Primavera P6 Conversion Services
    • Microsoft Project
      • Building an Integrated Master Schedule (IMS)
      • Integrating Microsoft Project with Deltek Cobra
      • Migrating From Microsoft Project To Oracle Primavera P6
  • Blog
    • Deltek Acumen
    • Deltek Cobra
    • Earned Value Mgmt
    • Microsoft Project
    • PMO
    • Primavera P6
    • Project Management
    • Risk Management
  • Clients
  • Contact Us

Transfer a P6 Schedule to Excel – Quick Tip

You are here: Home / Primavera P6 / Transfer a P6 Schedule to Excel – Quick Tip

August 15, 2022 By Ten Six

Transfer a P6 Schedule to ExcelThere’s a quick way to transfer a P6 schedule to Excel. Here’s how you can do this.

Many times, schedulers want to transfer schedule data to an Excel spreadsheet where they can utilize all the features available in Microsoft Excel to exercise and/or present the data. Also, P6 illiterate team members may need a way to easily enter their portion of the schedule updates. A well-known platform can serve as a common ground among team members with varying degrees of P6 understanding.

Microsoft Excel is a widely distributed and known spreadsheet software program, a platform interface between P6 schedulers and other project team members. Therefore, being able to transfer a P6 schedule to Excel is profitable. And, there’s more than one way to generate an Excel spreadsheet of the schedule’s activity table. Some more involved than others.

This article demonstrates a quick tip to expediently transfer a P6 activity table into a Microsoft Excel worksheet.

P6 Professional has a report feature that steps the scheduler through a process to generate a tabulated output of the schedule. The advantage of this way to generate a table is that it allows the scheduler to tailor the data output to suit their specific requirements. They can include data not displayed on the activity table but nevertheless associated with the activity table.

A good example is when the scheduler wants to include the step information along with the respective activity. Steps are a way for the scheduler to provide more details to an activity on the Gantt chart. Figure 1 below, displays a sample schedule print out that includes steps.

Primavera P6Figure 1

Note the Mobilize activity, the currently selected activity in the activity table. This task has steps associated with it. These steps are displayed in the bottom detail’s steps tab of Figure 1. Although these steps are not displayed in the activity table the scheduler can include them in the activity table output using the P6 reporting feature.

Figure 2 is the P6 output table with the steps included in the printout.

Copying dataFigure 2

If you want details like steps in your Excel spreadsheet that I refer you to the following Ten Six Primavera P6 Professional Reporting Blog.

However, to simply transfer what is visible in P6 on the activity table to Microsoft Excel follow these more convenient steps.

  1. Click on an activity in the activity table then choose Edit | Select All, Figure 3.

Example P6 PlanFigure 3

  1. Right click any where on the selected items and from the popup menu choose Copy, Figure 4.

Transfer a P6 Schedule to ExcelFigure 4

Simply paste into Excel.

Microsoft ExcelFigure 5

Figure 6 displays the pasted activity table but note that no steps were transferred in the copy and paste.

Transfer a P6 Schedule to ExcelFigure 6

Summary

There is more than one way to transfer a P6 schedule to Excel, a common spreadsheet platform. For a quick transfer of P6 schedule data to Excel, just select the activity table and use the classic copy and paste.

Be aware that this approach will only transfer what you currently see in the activity table. Other pertinent schedule information in the bottom details tabs like steps are not included. More meticulous and involved P6 data transfers, which can capture and transfer these details to Excel, are available in reporting and in the export file features.

Primary Sidebar

  • This field is for validation purposes and should be left unchanged.
  • Facebook
  • LinkedIn
  • Twitter

Categories

  • Deltek Acumen
  • Deltek Cobra
  • Earned Value Mgmt
  • Microsoft Project
  • PMO
  • Primavera P6
  • Project Management
  • Risk Management
CONTACT US

Footer

Upcoming Classes

Primavera P6 Professional Fundamentals
Primavera P6 EPPM Fundamentals
Primavera P6 EPPM Administrator
Primavera P6 BI Publisher Fundamentals
Deltek Cobra Fundamentals
Deltek Cobra Advanced
Deltek Acumen Fuse
Deltek Acumen Risk

  • This field is for validation purposes and should be left unchanged.
  • Facebook
  • LinkedIn
  • Twitter
  • Consulting Services
  • About Ten Six
  • Contact Us
  • Blog

Copyright © 2023 Ten Six Consulting, LLC · 703.910.2600

  • Training Classes
    ▼
    • Primavera P6 Training
    • Deltek Training
    • Earned Value Management Training
    • Project Management Training
    • Open Training Class Dates
  • Scheduling Services
  • Earned Value Mgmt. Services
    ▼
    • RFP Support
    • Your EVM System
    • Certification
    • Data Analysis and Reporting
    • Post Contract Support
    • Staff Augmentation
    • WBS Guidelines for Government Acquisition Programs (MIL-STD 881D)
  • Tools
    ▼
    • Primavera P6
      ▼
      • Knowledge Transfer, Mentoring and Coaching
      • BI Publisher Services
    • Primavera Unifier
    • Deltek Cobra
      ▼
      • Knowledge Transfer, Coaching and Mentoring
      • Staff Augmentation
    • Microsoft Project to Primavera P6 Conversion Services
    • Microsoft Project
      ▼
      • Building an Integrated Master Schedule (IMS)
      • Integrating Microsoft Project with Deltek Cobra
      • Migrating From Microsoft Project To Oracle Primavera P6
  • Blog
    ▼
    • Deltek Acumen
    • Deltek Cobra
    • Earned Value Mgmt
    • Microsoft Project
    • PMO
    • Primavera P6
    • Project Management
    • Risk Management
  • Clients
  • Contact Us