Fix Microsoft Project Import Wizard Converting Costs to Work Hours
Question details
Users importing assignment data from Excel into Microsoft Project find that cost values are incorrectly converted into Work hours.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Importing resource assignments and cost data from an Excel spreadsheet into a Microsoft Project schedule.
- Observed behavior
- Cost amounts in the Excel sheet are mistakenly interpreted and imported as Work hours rather than financial costs.
Ensure your Excel spreadsheet has clear and distinct headers for 'Cost' and 'Work' to prevent mapping confusion during the import process.
Configure Resource Type and Correct the Import Map
The most common reason for this issue is a mismatch in the import map or having the resource type set incorrectly before importing.
To successfully import cost values without them converting to work hours, the destination resource in Microsoft Project must be explicitly defined as a Cost resource. Additionally, the Import Wizard requires strict mapping to ensure the Excel columns align perfectly with Project's internal fields.
Open Microsoft Project and navigate to the 'Resource Sheet' view. Ensure that the 'Type' for any cost-related resource is explicitly set to 'Cost' instead of 'Work' or 'Material'.
Go to File > Open and select your Excel workbook to trigger the Microsoft Project Import Wizard.
When prompted by the wizard, choose to create a new map or edit your existing one. Ensure a valid 'Merge Key' (like Resource Name or ID) is correctly assigned to avoid duplicate entries.
In the field mapping section of the wizard, explicitly map your Excel 'Cost' column to the Project 'Cost' field. Double-check that it is not accidentally mapped to the 'Work' field.
Click 'Finish' to run the import. Review your assignment views to confirm that the financial values appear under costs and not as hours.

Manage Project Costs and Tasks Easily with WPS Office
Avoid complex import wizards and mapping errors by managing your project budgets and timelines directly in WPS Spreadsheet. It offers a lightweight, free, and highly compatible alternative for organizing your project data without the steep learning curve of Microsoft Project.
- 1. Download WPS Office: Visit the official WPS website to download and install the free suite.
- 2. Open a Project Template: Launch WPS Spreadsheet and browse the extensive template library for project management or budget tracking.
- 3. Track Costs Seamlessly: Input your tasks, resource costs, and work hours directly into the spreadsheet without dealing with complex import mapping.

Frequently Asked Questions
Why does Microsoft Project change my cost numbers to hours?
This happens when the resource is designated as a 'Work' type instead of 'Cost' in Project, or if the Excel column containing costs is accidentally mapped to the 'Work' field in the Import Wizard.
Can I change a resource type after importing data?
Once assignments are made, changing a resource type in Project can be difficult and may cause data recalculations. It is highly recommended to set the correct Resource Type (Cost, Work, or Material) before importing assignment data.
What is a Merge Key in the Project Import Wizard?
The Merge Key is a unique identifier (like a Task ID or Resource Name) used by Microsoft Project to match incoming Excel data with existing tasks or resources without creating duplicates.




