In this blog post, I’m going to walk you through how to import an Excel project task list into Microsoft Project with all of your Summary Tasks and Subtasks intact. Most project managers start building task lists in Excel, only to discover that Microsoft Project ignores visual cell indentation during an import and flattens the entire schedule.
Companion Articles in This Reports, Timelines, Excel & Printing Series: Explore these connected tutorials in the same topic area to build your skills step by step:
- Current Article (You Are Here): How to Import Excel Projects into Microsoft Project
- Companion Tutorial: How to Print a Project Schedule in Microsoft Project (Including 1-Page Printing)
- Companion Tutorial: How to Export Your Microsoft Project Schedule to a PDF File
- Companion Tutorial: How to Create Multiple Project Timelines in Microsoft Project
- Full Topic Hub: Browse All Reports, Timelines & Printing Tutorials →
At a Glance: How to Import Excel into Microsoft Project with Summary Tasks:
- Applies to: Microsoft Project Standard, Project Professional, and Project Online Desktop Client (with desktop Microsoft Excel workbooks
.xlsx/.xls). - Step 1: Add an
Outline Levelcolumn in Excel (1for Phases,2for Deliverables, and3for sub-Deliverables). - Step 2: In Microsoft Project, click File → Open → Browse (file type: Excel Workbook) to launch the Import Wizard and map your columns (
Task Name→Name,Outline Level→Outline Level,Start Date→Start,Finish Date→Finish,Responsible Party→Resource Names). - Step 3: Perform post-import cleanup: set your Project Start Date, strip out the automatic Finish No Earlier Than constraints (
Ctrl + D), and link your task dependencies.
Need hands-on help with your schedule? Explore my $399 Microsoft Project Desktop Course, Project Server Training, or book 1-on-1 Private Training & Consulting.
Why Do Standard Excel Imports Lose Your Summary Tasks?
Suppose you have a clean Excel project tracker with Task Name (with deliverable phases in bold and subtasks visually indented underneath), Start Date, Finish Date, and Responsible Party.
If you import that spreadsheet directly into Microsoft Project using the Import Wizard, Microsoft Project will not recognize the cell indentation you applied in Excel. Every row imports at the exact same outline level as a flat list of tasks. Fortunately, adding one simple column in Excel before importing forces Microsoft Project to build your entire hierarchy of Summary Tasks and Subtasks automatically.
Step 1: How Do I Set Up the “Outline Level” Column in Excel?
Before opening Microsoft Project, open your Excel workbook and insert a new column named Outline Level:
- For each top-level Phase row (such as Scope, Analysis, or Design), enter
1in the Outline Level column. - For each Deliverables row, enter
2. - If you have deeper levels of indentation in your Work Breakdown Structure, enter
3,4, and so on, then save and close the Excel workbook. Refer to the example below.
| Task Name | Outline Level | Start Date | Finish Date | Responsible Party |
|---|---|---|---|---|
| Scope | 1 | 4/7/2026 | 4/11/2026 | |
| Determine project scope | 2 | 4/7/2026 | 4/8/2026 | Sarah Jenkins |
| Secure project sponsorship | 2 | 4/9/2026 | 4/10/2026 | David Ross |
| Scope complete | 2 | 4/11/2026 | 4/11/2026 | |
| Analysis | 1 | 4/14/2026 | 4/24/2026 | |
| Conduct needs analysis | 2 | 4/14/2026 | 4/18/2026 | Maria Chen |
Step 2: How to Run the Microsoft Project Import Wizard
Now let’s import the updated Excel workbook into Microsoft Project:
- In Microsoft Project, click the File tab and click Open in the Backstage view.
- Click Browse and navigate to the folder containing your Excel file.
- In the lower-right corner of the Open dialog box, click the file type pick list button (which defaults to Projects (
*.mpp)) and choose Excel Workbook (*.xlsx;*.xls;*.xml). - Select your Excel workbook and click Open to launch the Import Wizard:
- Welcome Page: Click Next.
- Map Page: Leave New map selected and click Next.
- Import Mode Page: Leave As a new project selected and click Next.
- Map Options Page: Check the Tasks checkbox and click Next.
Step 3: How Do I Map Excel Columns to Microsoft Project Fields?
On the Task Mapping page of the Import Wizard, whenever you see a red Not Mapped row, click the To: Microsoft Project Field cell and select the matching field from the pick list:
- Task Name → maps to
Name(the real internal field name in MS Project) - Outline Level → maps to
Outline Level(auto-detected if namedOutline Level) - Start Date → maps to
Start - Finish Date → maps to
Finish - Responsible Party → maps to
Resource Names
Check the preview panel at the bottom of the dialog to verify your mapping, then click Next and finally click Finish. Because you included the Outline Level column, Microsoft Project automatically builds your entire Work Breakdown Structure, complete with bold Summary Tasks, roll-up bars, and indented Subtasks.
Step 4: What Post-Import Cleanup Is Required After Importing from Excel?
Excel stores static dates, whereas Microsoft Project is a dynamic scheduling engine. Always perform these three cleanup steps immediately after importing:
1. Set the Official Project Start Date
Click Project → Move Project, select your official start date in the New project start date calendar picker, and click OK.
2. Strip Out Automatic “Finish No Earlier Than” Constraints
When you import Finish Dates from Excel, Microsoft Project automatically assigns a Finish No Earlier Than constraint to every task. Here is the 10-second fix to remove them all at once:
1. Right-click the Duration column header, choose Insert Column, and select Constraint Type.
2. Change the first task row from Finish No Earlier Than to As Soon As Possible.
3. Press Ctrl + Shift + Down Arrow to select every cell below it in the Constraint Type column, then press Ctrl + D (Fill Down) to set every task to As Soon As Possible at once!
4. Right-click the Constraint Type column header and choose Hide Column. (See my guide on Microsoft Project Task Constraints for more details.)
3. Link Your Task Dependencies and Save as .mpp
Select the subtasks within each deliverable section and click Link the Selected Tasks (Ctrl + F2) to establish Finish-to-Start task dependencies, then save your file as a standard Microsoft Project (.mpp) schedule.
Frequently Asked Questions
Why did my tasks import as Manually Scheduled instead of Auto Scheduled?
Before running the Import Wizard, check the bottom status bar of Microsoft Project and make sure New Tasks : Auto Scheduled is selected so imported rows default to automatic scheduling.
Does importing Resource Names automatically create resources on the Resource Sheet?
Yes! Mapping an Excel column to Resource Names automatically populates the Resource Sheet view with each unique person’s name as a Work resource.
Ready to master Microsoft Project? If you found this article helpful, check out my free tutorials on my YouTube channel, download my Free Microsoft Project Quality Filters, or explore my structured, expert-led training courses and 1-on-1 coaching at dalehowardmvp.com.





Leave a Reply