Skip to content
Work Management Hub Work Management Hub

Expert Reviews, Comparisons & Guides for Smartsheet, Monday.com, Asana, ClickUp & More

Work Management Hub Work Management Hub

Expert Reviews, Comparisons & Guides for Smartsheet, Monday.com, Asana, ClickUp & More

  • Smartsheet
  • ClickUp
  • Asana
  • monday.com
  • Other tools
    • Jira
    • Notion
    • Wrike
    • Airtable
  • Comparisons
  • Guides
  • About
  • Smartsheet
  • ClickUp
  • Asana
  • monday.com
  • Other tools
    • Jira
    • Notion
    • Wrike
    • Airtable
  • Comparisons
  • Guides
  • About
Close

Search

Table of Microsoft Project data and whether it transfers to monday.com through an Excel import or must be rebuilt
How-To GuidesMonday.comProject Management

Microsoft Project to monday.com Migration: A Step-by-Step Guide That Doesn’t Lose Your Schedule

By Khasim Basha Shaik
May 10, 2026 6 Min Read
0

Home - How-To Guides - 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.

Table of Contents

Toggle
  • What transfers and what doesn’t
  • Which monday.com plan you need
  • Step 1: Inventory what you’re moving
  • Step 2: Export from Microsoft Project to Excel
  • Step 3: Clean the spreadsheet
  • Step 4: Build the board before you import
  • Step 5: Import into monday.com
  • Step 6: Rebuild dependencies and the timeline
  • Step 7: Add automations and train the team
  • Common mistakes
  • Is monday.com the right replacement?
  • Common questions
    • Can monday.com import Microsoft Project .mpp files?
    • Do task dependencies transfer from Microsoft Project to monday.com?
    • Can I keep my summary tasks and subtasks?
    • What happened to Microsoft Project Online?
    • How long does a Microsoft Project to monday.com migration take?
  • Related guides

What transfers and what doesn’t

Table showing which Microsoft Project data transfers to monday.com through an Excel import and which must be rebuilt by hand
Plan your time around the right-hand column: dependencies and baselines are where migrations slip. Chart: WorkManagementHub, from monday.com Support and Microsoft documentation.
Microsoft Project dataIn monday.comHow it gets there
Task namesItemsExcel import
Summary tasks and subtasksGroups, items and subitemsImport with a Subitems column, or rebuild as groups
Start and finish datesTimeline or Date columnsExcel import (map to Timeline)
DurationNumbers columnExcel import
Resource namesText first, then People columnImport as text, then reassign
% completeNumbers or Status columnImport as Numbers; convert later
NotesLong text or item updatesExcel import as text
Predecessors (dependencies)Dependency columnRebuild by hand
BaselinesGantt baselineRe-save a baseline after import
Resource calendars, leveling, cost ratesNo direct equivalentRethink 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:

  1. List every project and mark it active, on hold or closed. Move active projects; archive closed ones as PDF or Excel exports.
  2. Write down your custom fields (cost codes, phases, risk ratings) and decide which monday.com column type each becomes.
  3. List cross-project dependencies. These are the hardest part, because monday.com links them across boards differently.
  4. 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

  1. 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.)
  2. Upload the cleaned .xlsx or .csv file.
  3. 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.
  4. 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:

  1. Add a Dependency column (Pro plan) and link each task to its predecessor.
  2. Convert the imported resource names into the People column so tasks show up in each person’s work.
  3. 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.

Sticky notes on a whiteboard during a planning workshop
Agree on the board structure as a team before the import; it's harder to change afterward. Photo: NPS / Kurt Moses, Joshua Tree National Park, public domain, via Wikimedia Commons.

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.

From our team: OneSmar for Smartsheet Teams

OneSMAR for Smartsheet Teams - Available on the App Store

Related guides

monday.com Pricing 2026: Every Plan, What 10 Seats Really Cost, and the Limits That Force an Upgrade
Monday.com
monday.com Pricing 2026: Every Plan, What 10 Seats Really Cost, and the Limits That Force an Upgrade
monday.com Time Tracking 2026: Setup, Billable Hours and Reports
Monday.com
monday.com Time Tracking 2026: Setup, Billable Hours and Reports
monday.com Review 2026: Is It Worth the Price?
Monday.com
monday.com Review 2026: Is It Worth the Price?

Tags:

2026Microsoft Projectmigration guideMonday.comproject management
Author

Khasim Basha Shaik

Khasim Basha Shaik is Co-Founder and Managing Director of SSPM Consultants, a Smartsheet Premier Partner based in Bengaluru, India. Since founding SSPM in 2018, he has spent 8+ years on Smartsheet implementation, integration, administration and support for client teams. On Work Management Hub he turns that hands-on work into plain setup guides, fixes and pricing breakdowns, and checks the numbers against official vendor sources.

Follow Me
Other Articles
Table comparing free project management plans in 2026: users, key limits, automation and first paid plan for Jira, Trello, ClickUp, Linear, Airtable, Asana, monday.com, Notion and Wrike
Previous

Best Free Project Management Tools in 2026, Ranked by Real Limits

Table comparing Notion and Google Docs on shape, review, export, price and AI
Next

Notion vs Google Docs 2026: Where Each One Actually Wins

No Comment! Be the first one.

    Leave a Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    KB
    Khasim Basha Shaik

    Khasim Basha Shaik is Co-Founder and Managing Director of SSPM Consultants, a Smartsheet Premier Partner based in Bengaluru, India. Since founding SSPM in 2018, he has spent 8+ years on Smartsheet implementation, integration, administration and support for client teams. On Work Management Hub he turns that hands-on work into plain setup guides, fixes and pricing breakdowns, and checks the numbers against official vendor sources.

    About Work Management Hub →

    Popular reviews & guides

    • Table matching ten team types to the project management tool to start with, a runner-up and the reasonBest Project Management Software 2026: 10 Tools Compared by Team Type, Real Monthly Cost and the Limits That Matter
    • Team meeting around a long conference table with laptops openJira Pricing 2026: Standard vs Premium, Annual Tiers and the Oct 13 Increase
    • Developer working on a laptop with code on screen while holding a phoneJira Slack Integration 2026: Setup, @Jira Tickets and Channels Without the Noise
    • Laptop covered in developer stickers on a deskLinear vs GitHub Issues (2026): Who Should Track the Work?
    • Person typing on a laptop at a small round tableLinear-GitHub Sync Broken? Fix Every Failure Mode

    Browse by tool

    • Smartsheet29
    • Monday.com15
    • Asana17
    • ClickUp7
    • Notion18
    • Jira20
    • Wrike6
    • Airtable5
    • Integrations10

    From our team From our team: OneSmar for Smartsheet Teams, our own app

    Independent reviews, comparisons, and hands-on guides for work management tools: Smartsheet, Monday.com, Asana, ClickUp, Notion, Jira, Wrike, and Airtable. Written from daily, real-world use of these platforms.

    Topics

    • Smartsheet
    • Monday.com
    • ClickUp
    • Asana
    • Notion
    • Jira
    • Wrike
    • Airtable
    • Comparisons

    Company

    • About
    • Contact
    • Editorial Policy
    • Author

    Legal

    • Privacy Policy
    • Terms of Use
    • Disclaimer
    • Affiliate Disclosure
    Copyright 2026 Work Management Hub. All rights reserved. Blogsy WordPress Theme