Share via

Import Plans from Excel to Planner

Anonymous
2025-03-19T18:01:31+00:00

I have a list of projects (Plans) in Excel that were exported out of a different Project Management system. I want to import this list of Plans in such a way that Automate creates new corresponding plans in Planner. Let me reiterate, I am NOT looking for how to import tasks - there are lots of resources available pointing to that but none that talk about importing Plans. Any help is appreciated.

Microsoft 365 and Office | Project | Other | Other
Microsoft 365 and Office | Project | Other | Other

Microsoft project management software used to plan, manage, and communicate a project schedule and other information among workgroup members, project managers, and other stakeholders.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-03-20T03:47:28+00:00

    Dear Syed D Ahmad,

    Thank you for reaching out. Unfortunately, Microsoft Planner does not currently offer a built-in method to import entire Plans from Excel. While there are ways to create tasks using Power Automate, creating full Plans (including their structure) programmatically is more complex.

    One potential approach is using Microsoft Graph API, which allows the creation of new Plans in Planner. You could set up a Power Automate flow that reads your Excel file and uses the Graph API to create new Plans dynamically. This would require:

    1. Registering an Azure AD app with the necessary permissions to interact with Planner.
    2. Using Power Automate's HTTP action to call the Microsoft Graph API (POST /planner/plans) for each entry in your Excel file.

    If you are interested in a Power Automate and Graph API solution, I suggest raising this concern in the Power Automate Community and Microsoft Graph - Microsoft Q&A, where the related support teams can provide more professional suggestions and ideas for creating a Plan with Microsoft Graph API and creating flows in Power Automate.

    Thank you for your understanding.

    Best Regards,
    Community Moderator | Sophia

    Was this answer helpful?

    0 comments