Others

Fix Microsoft Project Import Wizard Converting Costs to Work Hours

Khadija KhanKhadija Khan Nov 3, 2026 868 views

Question details

Users importing assignment data from Excel into Microsoft Project find that cost values are incorrectly converted into Work hours.

How to Fix Microsoft Project Import Wizard Converting Cost Values to 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.
Before you start

Ensure your Excel spreadsheet has clear and distinct headers for 'Cost' and 'Work' to prevent mapping confusion during the import process.

Solution 1Recommended

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.

1
Verify Resource Types in Project

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'.

2
Start the Import Wizard

Go to File > Open and select your Excel workbook to trigger the Microsoft Project Import Wizard.

3
Set the Merge Key

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.

4
Map the Cost Field

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.

5
Complete the Import

Click 'Finish' to run the import. Review your assignment views to confirm that the financial values appear under costs and not as hours.

Configure Resource Type and Correct the Import Map
Microsoft Official Guidance: For highly complex schedules, refer to Microsoft's official Excel import documentation to understand detailed field mapping rules and avoid data corruption.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download and install the free suite.
  2. 2. Open a Project Template: Launch WPS Spreadsheet and browse the extensive template library for project management or budget tracking.
  3. 3. Track Costs Seamlessly: Input your tasks, resource costs, and work hours directly into the spreadsheet without dealing with complex import mapping.
Fully compatible with Microsoft Excel (.xlsx) formatsFree, lightweight, and easy-to-use interface with familiar navigationBuilt-in templates specifically designed for project management and cost trackingSeamless migration from Microsoft Office with no data loss
QA img-9

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.