Others

Fix Blank Excel Fields in the Microsoft Project Import Wizard

Rana GarciaRana Garcia Nov 14, 2026 868 views

Question details

The user needs Microsoft Project to display Excel columns during import so they can map worksheet data to Project fields.

Fix Blank Excel Fields in the Microsoft Project Import Wizard
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.
Before you start

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.

Solution 1Recommended

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.

1
Inspect the headers

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.

2
Simplify the worksheet

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.

3
Retry the wizard

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.

4
Map the fields

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.

Check the Excel worksheet structure and retry the import
Review import requirements: If the fields remain blank, consult Microsoft's Project import and export documentation for requirements that apply to your Project version and workbook layout. Removing spaces from the filename did not resolve this case.
Free Microsoft Office alternative

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.

Review task headers and dates before importing them into ProjectOpen and edit Microsoft Excel XLSX and XLS filesSave worksheet data as CSV for the Project import workaroundUse a familiar spreadsheet interface in a lightweight office suite
microsoft office alternative - wps office

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.