How to sync a planner plan with an excel file?

%3CLINGO-SUB%20id%3D%22lingo-sub-1101394%22%20slang%3D%22en-US%22%3EHow%20to%20sync%20a%20planner%20plan%20with%20an%20excel%20file%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1101394%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%40%26nbsp%3BPlanner%20Community%2C%3C%2FP%3E%3CP%3EI%20wonder%20how%20I%20could%20sync%20a%20list%20of%20task%20in%20a%20Planner%20plan%20with%20an%20Excel%20file.%3C%2FP%3E%3CP%3EI%20cannot%20find%20any%20doc%20in%20this%20community%20or%20anywhere%20else.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Excel%20(v.%2016.0.11328.20438)%2C%20in%20Data*%20tab%20%26gt%3B%20Get%20data*%2C%20I'm%20trying%20to%20connect%20to%20my%20plan%20and%20get%20the%20related%20data%20using%3A%3C%2FP%3E%3COL%3E%3CLI%3E%22From%20another%20source%20%26gt%3B%20From%20a%20Sharepoint%20list%22*%3C%2FLI%3E%3CLI%3E%22From%20another%20source%20%26gt%3B%20From%20the%20web%22*%3C%2FLI%3E%3CLI%3E%22From%20an%20online%20service%20%26gt%3B%20From%20a%20SharePoint%20Online%20list%22*%3C%2FLI%3E%3CLI%3E%22From%20a%20file%20%26gt%3B%20From%20a%20SharePoint%20folder%22*%3C%2FLI%3E%3C%2FOL%3E%3CP%3Ebut%20none%20of%20these%20works%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20one%20that%20gives%20me%20hint%20it%20connects%20to%20the%20right%20plan%20is%20the%20%232%3A%20indeed%20the%20pop-up%20window%20shows%20in%20the%20left%20hand%20side%20when%20in%20%22browser%20display%22*%20tab%20my%20plan.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20no%20way%20to%20get%20the%20data%20in%20the%20same%20form%20as%20a%20simple%20export%20of%20my%20plan.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20search%20on%20Planner%20API%20on%20Microsoft%20Graph%20too%20(%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Ffr-fr%2Fgraph%2Fgraph-explorer%3Frequest%3Dplanner%2Fplans%2F%257Bid%257D%2Ftasks%26amp%3Bversion%3Dv1.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Ffr-fr%2Fgraph%2Fgraph-explorer%3Frequest%3Dplanner%2Fplans%2F%257Bid%257D%2Ftasks%26amp%3Bversion%3Dv1.0%3C%2FA%3E)%20but%20I%20don't%20know%20how%20to%20make%20this%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20about%20how%20I%20could%20simply%20(I'm%20a%20simple%20user%2C%20not%20an%20admin%2C%20not%20a%20dev)%20get%20my%20plan%20synced%20in%20a%20file%20under%20the%20format%20of%20a%20simple%20list%20of%20tasks%20(I%20used%20to%20sync%20tasks%20lists%20in%20SharePoint%20that%20same%20way%20some%20years%20ago%2C%20very%20simple%2C%20no%20need%20to%20be%20a%20genius%20tech%20dev)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20%3A%20I'm%20using%20a%20French%20version%20of%20Excel%2C%20then%20my%20own%20English%20translation%20of%20the%20menu%20titles%20might%20be%20not%20fully%20correct%20...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1101617%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20sync%20a%20planner%20plan%20with%20an%20excel%20file%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1101617%22%20slang%3D%22en-US%22%3EDefinitively%20the%20way%20to%20go%20is%20by%20means%20of%20the%20Microsoft%20Graph%20API%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1102963%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20sync%20a%20planner%20plan%20with%20an%20excel%20file%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1102963%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F513456%22%20target%3D%22_blank%22%3E%40VincentTotal%3C%2FA%3E%26nbsp%3Byou%20need%20to%20use%20Graph%20API%20to%20get%20the%20planner%20tasks.%20But%20unfortunately%2C%20Sync%20is%20not%20an%20easy%20job%20to%20try%20by%20yourself.%20You%20can%20try%20the%20third-party%20app%20to%20have%20this%20done%20for%20you.%20Let%20me%20know%20if%20you%20need%20any%20suggestions.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi @ Planner Community,

I wonder how I could sync a list of task in a Planner plan with an Excel file.

I cannot find any doc in this community or anywhere else.

 

In Excel (v. 16.0.11328.20438), in Data* tab > Get data*, I'm trying to connect to my plan and get the related data using:

  1. "From another source > From a Sharepoint list"*
  2. "From another source > From the web"*
  3. "From an online service > From a SharePoint Online list"*
  4. "From a file > From a SharePoint folder"*

but none of these works ...

 

The only one that gives me hint it connects to the right plan is the #2: indeed the pop-up window shows in the left hand side when in "browser display"* tab my plan.

 

But no way to get the data in the same form as a simple export of my plan.

 

I've search on Planner API on Microsoft Graph too (https://developer.microsoft.com/fr-fr/graph/graph-explorer?request=planner/plans/%7Bid%7D/tasks&vers...) but I don't know how to make this work.

 

Any idea about how I could simply (I'm a simple user, not an admin, not a dev) get my plan synced in a file under the format of a simple list of tasks (I used to sync tasks lists in SharePoint that same way some years ago, very simple, no need to be a genius tech dev)?

 

Thank you in advance,

 

* : I'm using a French version of Excel, then my own English translation of the menu titles might be not fully correct ...

2 Replies
Definitively the way to go is by means of the Microsoft Graph API

@VincentTotal you need to use Graph API to get the planner tasks. But unfortunately, Sync is not an easy job to try by yourself. You can try the third-party app to have this done for you. Let me know if you need any suggestions.