'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Import Unit Price Analysis into Microsoft Project
Question details
The user needs to import construction cost data, specifically unit price analysis, from Excel or budgeting software into Microsoft Project as task resources.
- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Importing bulk construction cost data, quantities, and task resources from external software into a project schedule.
- Observed behavior
- The goal is to automatically allocate task resources, including quantities and costs, without having to manually assign each resource to every task individually.
Ensure your Excel cost data is cleanly organized, distinguishing clearly between work resources and material resources, and verify that your column headers align with Microsoft Project fields.
Use an Excel Import Map for Structured Projects
The most reliable method for complex imports is using an Excel import map to correctly link tasks, resources, and assignments.
A simple copy and paste often fails to properly link resources to tasks. Using an Excel import map allows you to define separate worksheets for tasks, resources, and assignments, ensuring all quantities and costs are accurately mapped into Microsoft Project.
Prepare your Excel workbook with three distinct worksheets named Tasks, Resources, and Assignments. Ensure data distinguishes between work and material resources.
In Microsoft Project, navigate to File > Open. Change the file type dropdown to 'Excel Workbook (*.xlsx)', select your prepared Excel file, and click Open to trigger the Import Wizard.
Click Next, choose 'New map', and select the types of data you are importing (check Tasks, Resources, and Assignments).
For each data type, map your Excel column headers to the corresponding Microsoft Project fields (e.g., Resource Name, Type, Standard Rate, Task ID).
Click Finish to complete the wizard. Verify in the Gantt Chart and Resource Sheet views that quantities and costs have been accurately assigned.
Format and Paste a Simple Bill of Quantities
For simpler projects or basic bill of quantities lists, a direct copy-paste can work if the Excel data is perfectly formatted to match the Resource Sheet.
Automate the Import Process using VBA
For repetitive imports or highly customized cost analysis sheets, VBA macros can automate the resource creation and assignment.
Need a Free Solution for Project Cost Analysis?
While Microsoft Project handles complex schedule linking, WPS Spreadsheet is an excellent, free alternative for organizing project budgets, calculating unit price analysis, and structuring construction cost data before importing. Enjoy a familiar interface and powerful data management tools.
Frequently Asked Questions
Why isn't a direct copy and paste working for my project resources?
A direct paste often fails because Microsoft Project requires explicit links between tasks and resources. Without using an Import Map or a dedicated Assignments sheet, Project won't know which task requires which specific material or work resource.
What is the difference between Work and Material resources when importing?
Work resources refer to people or equipment billed by time (e.g., hourly rates), while Material resources are supplies billed by unit quantity (e.g., cubic yards of concrete). Your Excel data must specify this 'Type' column accurately before importing.
Can I import custom cost fields into Microsoft Project?
Yes. You can map custom text, number, and currency fields from your Excel file to the Custom Fields (like Cost1, Cost2, or Number1) in Microsoft Project using the Import Wizard.
