Fix Blank Excel Fields in the Microsoft Project Import Wizard
Question details
The user needs Microsoft Project to display Excel columns during import so they can map worksheet data to Project fields.

- Product
- Microsoft Project Import Wizard
- Device & OS
- not provided
- Scenario
- Importing task data from an Excel worksheet into a Microsoft Project plan.
- Observed behavior
- The wizard opens the workbook and lists its worksheet, but the field-mapping step is blank. The same data imports successfully from CSV.
Identify the worksheet you want to import and check that it contains a header row followed by task data. Confirm that you can open the workbook in a spreadsheet application and that the task dates are valid.
Check the Excel worksheet structure and retry the import
Use this approach to make the source columns easier for the Project Import Wizard to identify.
Open the workbook in Excel or another spreadsheet application. Make sure the first row of the import data has clear, unique column headers, such as Task Name, Start, and Finish.
On the source worksheet, remove unnecessary blank rows above the headers and avoid merged header cells. Place each task on its own row and check that Start and Finish contain valid dates.
In Microsoft Project, choose File > Open, browse to the workbook, and select the Excel file type if needed. In the Import Wizard, select the source worksheet and check whether its columns appear at the field-mapping step.
If the columns appear, map the source task name and date columns to the corresponding Project fields, review the remaining mappings, and finish the import.

Import the task data from a CSV file
Use CSV as a practical workaround when Project can read the worksheet but does not display Excel field mappings.
Check for Microsoft Project updates
Update the Project installation before retrying the Excel import if the mapping screen remains blank.
Prepare Project Import Data with WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface for reviewing Excel worksheets and preparing CSV task data. It supports common Microsoft Office formats for an easier move between applications, but it does not repair Microsoft Project's Import Wizard.

Frequently Asked Questions
Why can Project see my worksheet but not its fields?
The workbook can be accessible even if the wizard does not display its columns for mapping. Check for clear, unique headers in the first row of the import data, remove blank rows above them, and retry the import.
Which Excel columns should I check before importing tasks?
Check that each task has a clear task name and that Start and Finish values are valid dates. In the Import Wizard, map these source columns to the corresponding Project fields.
Can I import the same data if Excel field mapping stays blank?
Yes. Save the active worksheet as a CSV file using File > Save As in your spreadsheet application, then open the CSV through File > Open in Microsoft Project and map its columns in the Import Wizard.
Will removing spaces from the workbook name fix the blank fields?
It did not resolve the issue in this case. Check the worksheet headers and layout instead, and use CSV if the Excel mapping screen remains blank.
How do I update Microsoft Project?
In Project, go to File > Account > Update Options > Update Now if the option is available. If your organization manages updates, contact your administrator.




