How to Import Data from a Non-Sheet1 Excel Worksheet into MS Project
Question details
The user needs to import data into Microsoft Project from an Excel workbook where the data resides on a worksheet not named 'Sheet1'.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Importing project task data from an Excel workbook into Microsoft Project.
- Observed behavior
- The Microsoft Project Excel import wizard defaults to 'Sheet1' and ignores data on other uniquely named worksheets, even if they contain correct headers.
Ensure your Excel workbook is closed before starting the import process in MS Project, and verify that the first row of your target worksheet contains clear field headers without any blank rows above them.
Adjust the Import Map in the Microsoft Project Wizard
Manually select the correct Excel worksheet within the MS Project Import Wizard to ensure your data is recognized.
By default, Microsoft Project's Import Wizard looks for a worksheet named 'Sheet1'. If your data is located on a differently named sheet, you must edit the import map during the import process to point the wizard to the correct source location.
Open Microsoft Project, go to File > Open, select your Excel file, and proceed to start the Import Wizard.
Follow the wizard prompts until you reach the step that asks you to define or edit the import map.
In the mapping window, locate the 'Source worksheet name' drop-down menu and change the selection from 'Sheet1' to the actual name of your worksheet.
Check the box labeled 'Headers in first row' to ensure your Excel columns are correctly mapped to Project fields, then complete the wizard.
Prepare Your Project Data Seamlessly with WPS Office
While Microsoft Project's import wizard has strict worksheet requirements, you can easily prepare, edit, and organize your project data using WPS Spreadsheet. WPS Office is a free, lightweight alternative that is fully compatible with Microsoft Excel formats, allowing you to bypass import limitations effortlessly.
- 1. Open your data file: Launch WPS Spreadsheet and open the workbook containing your project data.
- 2. Rename the worksheet: Right-click the worksheet tab at the bottom of the screen, select 'Rename', and change the name to 'Sheet1'.
- 3. Save and import: Save the file as an .xlsx document and close it. You can now import it into Microsoft Project without adjusting the import map.

Frequently Asked Questions
Why does Microsoft Project only see 'Sheet1' when importing from Excel?
By default, the MS Project Import Wizard expects the source data to be on the default first worksheet named 'Sheet1'. If your data is located elsewhere, the wizard requires you to manually edit the import map to select the correct worksheet tab.
Can I import multiple Excel worksheets into MS Project at the same time?
No, the Import Wizard in Microsoft Project processes one worksheet at a time. To bring in multiple sets of data, you will need to consolidate your data into a single worksheet or run the import wizard multiple times.
What should I do if my Excel column headers are not recognized in Project?
Ensure that you have checked the 'Headers in first row' box in the Import Wizard. Additionally, verify in your spreadsheet program that your headers are clearly defined in the very first row of your selected worksheet, with no blank rows or title rows above them.
Is there a way to bypass the import map step entirely?
Yes. If you rename the worksheet containing your data to 'Sheet1' and ensure your column headers exactly match standard MS Project field names (such as Task Name, Start, Finish, Resource Names) before importing, the wizard can automatically map the fields with minimal manual adjustment.




