
Microsoft Project to monday.com Migration: A Step-by-Step Guide That Doesn’t Lose Your Schedule
monday.com doesn’t import Microsoft Project files directly. The migration that works is: export your project from Microsoft Project to Excel, clean the sheet, import it into a monday.com board you’ve set up first, then rebuild dependencies, baselines and automations by hand. Task names, dates, owners, durations, notes and the task hierarchy can come across. Dependencies, resource calendars, baselines and critical-path logic don’t.
For a typical project of a few hundred tasks, plan on a day to prepare and import, and another day or two to rebuild dependencies and check the timeline. Large portfolios take longer because the decisions about board structure take longer than the import itself.
One date matters for anyone still on the web version: Microsoft retired Project Online on September 30, 2026, per its product lifecycle page. Microsoft said that after retirement you can no longer access projects or data in the service. Project desktop (Project Standard and Professional 2024) and Project Server Subscription Edition aren’t affected, so if you have .mpp files or desktop access, you can still export.
What transfers and what doesn’t

| Microsoft Project data | In monday.com | How it gets there |
|---|---|---|
| Task names | Items | Excel import |
| Summary tasks and subtasks | Groups, items and subitems | Import with a Subitems column, or rebuild as groups |
| Start and finish dates | Timeline or Date columns | Excel import (map to Timeline) |
| Duration | Numbers column | Excel import |
| Resource names | Text first, then People column | Import as text, then reassign |
| % complete | Numbers or Status column | Import as Numbers; convert later |
| Notes | Long text or item updates | Excel import as text |
| Predecessors (dependencies) | Dependency column | Rebuild by hand |
| Baselines | Gantt baseline | Re-save a baseline after import |
| Resource calendars, leveling, cost rates | No direct equivalent | Rethink in workload view |
The key limit from monday.com’s Excel import guide: an import can fill Numbers, Text, Date, Email, Dropdown, Timeline and Phone columns. Other column types, including People, Status and Dependency, aren’t filled during the import, so you convert or rebuild those afterward.
Which monday.com plan you need
Check this before you build anything. From monday.com’s pricing page, checked October 11, 2026:
- Standard ($12 per seat per month billed yearly, 3-seat minimum) is the minimum for a Microsoft Project replacement. It adds Timeline and Gantt views, calendar view and 250 automation actions a month.
- Pro ($19) adds advanced columns, including dependencies, private boards, time tracking and 25,000 automation actions a month. If your schedules depend on linked tasks, plan on Pro.
Our monday.com pricing guide breaks down seat buckets and the automation caps.
Step 1: Inventory what you’re moving
Don’t migrate everything. Before exporting:
- List every project and mark it active, on hold or closed. Move active projects; archive closed ones as PDF or Excel exports.
- Write down your custom fields (cost codes, phases, risk ratings) and decide which monday.com column type each becomes.
- List cross-project dependencies. These are the hardest part, because monday.com links them across boards differently.
- Note who uses each project and whether they need to edit (paid seat) or just view (free viewer).
Step 2: Export from Microsoft Project to Excel
In Project desktop, open the .mpp file and choose File → Save As, then pick Excel Workbook as the file type. Project’s Export Wizard lets you choose which fields go into the sheet. Include at least:
- ID, Outline Level, Name
- Start, Finish, Duration
- Resource Names, % Complete
- Predecessors (you won’t import these, but you’ll need them for Step 6)
- Notes and any custom fields you listed
Keep the original .mpp file and a full Excel export as an archive. Once the migration is done, that’s your record of the old schedule.
Step 3: Clean the spreadsheet
A few minutes here saves hours of fixing a bad import:
- Remove formatting, merged cells, blank rows and sheet protection. monday.com rejects protected files.
- Convert dates to a plain date format and durations to plain numbers (strip “days” or “d”).
- Make task names unique. If two tasks are both called “Review”, rename them (“Design review”, “Final review”). The subitem import matches children to parents by name.
- Add a Subitems column if you want to keep the task hierarchy, and fill it with the exact name of each row’s direct parent, as described in monday.com’s multi-level subitems guide.
- Keep Status labels under 40. monday.com notes that a status column with more than 40 unique labels can make the import fail silently.
Step 4: Build the board before you import
Decide on the structure first:
- One board per project for most teams, with groups for phases (your former summary tasks).
- Columns: Timeline, Owner (People), Status, Duration (Numbers), % Complete (Numbers), and one column for each custom field you kept.
- If you’ll use multi-level subitems, turn them on for the board before importing.
For portfolios, add a summary board or dashboard later. Our monday.com dashboards guide covers rolling up several project boards.
Step 5: Import into monday.com
- On the board, click the arrow next to New item and choose Import items. (For a new board, use Add new board → Import data → Excel.)
- Upload the cleaned .xlsx or .csv file.
- Map each spreadsheet column to a board column: Start/Finish to Timeline, Duration to Numbers, Notes to Text, and your Subitems column to the subitems field.
- Run the import, then spot-check 10 to 20 items against the original plan: dates, hierarchy and owners.
Step 6: Rebuild dependencies and the timeline
This is the manual part. With the Predecessors column from your export open beside the board:
- Add a Dependency column (Pro plan) and link each task to its predecessor.
- Convert the imported resource names into the People column so tasks show up in each person’s work.
- Save a new baseline once the schedule matches, so you can track slippage from here on.
If your plans rely on critical-path analysis, resource leveling or earned value, test how those work in monday.com before you commit. They don’t behave the way Microsoft Project’s scheduling engine does, and for some construction and engineering schedules that’s a dealbreaker.
Step 7: Add automations and train the team
Start with three or four automations that replace manual chasing: notify an owner when a task is assigned, alert the project manager when a status changes to Stuck, and remind owners when a due date arrives. Then run the old and new plans side by side for a week or two before retiring the old one.

Common mistakes
- Importing before designing the board. You end up with 40 text columns and no Timeline.
- Expecting dependencies to come across. They never do through an Excel import.
- Paying for everyone. People who only check progress can be free viewers.
- Migrating closed projects. Archive them as exports instead.
- Skipping the parallel run. A week of overlap catches missing tasks and wrong dates.
Update, November 20, 2026: Microsoft is folding To Do into Planner, and To Do apps retire on June 30, 2027. Premium plans in Planner will not get new features. Our Microsoft To Do and Planner guide covers what changes inside Microsoft 365.
Is monday.com the right replacement?
monday.com is a good fit when your team wants plans that everyone can update, not just the project manager. It’s a weaker fit for heavy scheduling with resource leveling. If that’s you, compare Smartsheet vs Microsoft Project, our monday.com review, or our list of Project Online alternatives.
Common questions
Can monday.com import Microsoft Project .mpp files?
No. Export the project from Microsoft Project to Excel or CSV, then import that file into a monday.com board.
Do task dependencies transfer from Microsoft Project to monday.com?
No. An Excel import doesn’t fill Dependency columns. Export the Predecessors field for reference and rebuild links in monday.com’s Dependency column, which is on the Pro plan.
Can I keep my summary tasks and subtasks?
Yes. Add a Subitems column to your spreadsheet with each row’s direct parent name and map it during import on a board with multi-level subitems, or turn summary tasks into groups.
What happened to Microsoft Project Online?
Microsoft retired Project Online on September 30, 2026. Project desktop and Project Server Subscription Edition weren’t affected.
How long does a Microsoft Project to monday.com migration take?
For one project of a few hundred tasks, plan on a day for preparation and import and a day or two to rebuild dependencies and check the schedule. Portfolios take longer.
Steps checked against monday.com Support and Microsoft’s lifecycle documentation on October 11, 2026. Menu names can change, so check the current help articles if a step looks different.


