How to Bulk Load Costs & Resources into Primavera P6 Using Excel
Assigning resources activity by activity isn't scalable because this can take several days to complete once your schedule has thousands of activities.
That's why it is recommended to prepare your TASK and TASKRSRC data in Excel first, using INDEX and MATCH to pull quantities, costs, and labor units automatically for every activity.
By structuring your resource assignments (QTY, COST, LABOR) in Excel and importing them directly into P6, you can load cost and resources across an entire schedule in minutes instead of days.
👉 Bulk loading saves time, avoids manual assignment errors, and turns your baseline into a fully cost and resource-loaded baseline schedule.