SOLVED

Is there a plan to planner export to excel the tasks and events?

%3CLINGO-SUB%20id%3D%22lingo-sub-193768%22%20slang%3D%22en-US%22%3EIs%20there%20a%20plan%20to%20planner%20export%20to%20excel%20the%20tasks%20and%20events%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193768%22%20slang%3D%22en-US%22%3E%3CP%3E%3CEM%3EThe%20management%20that%20planner%20does%20is%20great%20and%20it%20is%20better%20each%20day.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EBut%20we%20need%20to%20have%20more%20statistics%20from%20the%20tasks.%20%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EIt%20would%20be%20great%20to%20have%20the%20information%20was%20manipulated%20in%20an%20spreadsheet%20to%20show%20the%20productive%20of%20each%20one%20of%20the%20team.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EIs%20there%20a%20plan%20from%20Microsoft%20Planner%20developer%20team%20to%20implement%20it%20soon%3F%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332300%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20plan%20to%20planner%20export%20to%20excel%20the%20tasks%20and%20events%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332300%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20try%20to%20export%20tasks%20(35%20bukclets%20and%20a%20lot%20of%20tasks%20finishing%2C%20pending%20....)%3C%2FP%3E%3CP%3EOnly%20400%20tasks%20are%20exported%20from%20Planer%20to%20Excel.%20Do%20you%20think%2C%20there%20is%20a%20FLOW%20export%20limitation%3F%3C%2FP%3E%3CP%3EThanks%20%26amp%3B%20regards%2C%3C%2FP%3E%3CP%3EEmmanuel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-290000%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20plan%20to%20planner%20export%20to%20excel%20the%20tasks%20and%20events%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-290000%22%20slang%3D%22en-US%22%3E%3CP%3EI%20Have%20created%20the%20WI%20and%20Tasks%20in%20planner.%20How%20can%20I%20export%20in%20to%20an%20excel%20sheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282244%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20plan%20to%20planner%20export%20to%20excel%20the%20tasks%20and%20events%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282244%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20news!%20It%20has%20been%20scheduled%20but%20there%20is%20no%20ETA%20information%20yet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fplanner.uservoice.com%2Fforums%2F330525-microsoft-planner-feedback-forum%2Fsuggestions%2F11116770-export-to-excel%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fplanner.uservoice.com%2Fforums%2F330525-microsoft-planner-feedback-forum%2Fsuggestions%2F11116770-export-to-excel%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266657%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20plan%20to%20planner%20export%20to%20excel%20the%20tasks%20and%20events%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266657%22%20slang%3D%22en-US%22%3EOur%20own%20app%20named%20'%20Apps4.Pro%20Planner%20Manager'%20will%20do%20this.%20It%20helps%20you%20to%20export%20all%20your%20Plans%20and%20Tasks%20with%20complete%20details%20including%20Comments%2C%20Checklists%20and%20Attachments%20to%20Excel.%20The%20same%20Excel%20can%20be%20used%20to%20modify%20and%20import%20back%20or%20can%20be%20used%20for%20creating%20new%20plans.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266410%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20plan%20to%20planner%20export%20to%20excel%20the%20tasks%20and%20events%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266410%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%203rd%20party%20apps%20do%20you%20know%20that%20will%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-194393%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20plan%20to%20planner%20export%20to%20excel%20the%20tasks%20and%20events%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-194393%22%20slang%3D%22en-US%22%3EYou%20can%20use%20Microsoft%20Flow%20to%20create%20Excel%20with%20Planner%20task%20details.%20But%20that's%20complicated%20as%20the%20all%20task%20details%20cannot%20be%20retrieved%20from%20Flow.%20You%20can%20find%20relevant%20discussions%20in%20this%20forum%20but%20they%20are%20complicated%20and%20time%20consuming%20to%20create.%3CBR%20%2F%3E%3CBR%20%2F%3EA%20simple%20way%20would%20be%20to%20rely%20on%20third%20party%20apps%20for%20now%20to%20Export%20Planner%20tasks%20to%20Excel.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193876%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20plan%20to%20planner%20export%20to%20excel%20the%20tasks%20and%20events%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193876%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Santhosh%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot%20for%20your%20suggestion%2C%20I%20voted%20for%20this%20feature%20in%20user%20voice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EBased%20on%20your%20experience%20while%20Microsoft%20does%20not%20implement%20this%20feature%2C%20what%20do%20you%20suggest%20as%20take%20around%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3ERegards%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EMario%20Rodrigues%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193828%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20plan%20to%20planner%20export%20to%20excel%20the%20tasks%20and%20events%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193828%22%20slang%3D%22en-US%22%3EHi%2C%20Please%20vote%20for%20this%20feature%20in%20User%20voice.%20MSFT%20is%20planning%20to%20work%20on%20this%20in%20future.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fplanner.uservoice.com%2Fforums%2F330525-microsoft-planner-feedback-forum%2Fsuggestions%2F11116770-export-to-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fplanner.uservoice.com%2Fforums%2F330525-microsoft-planner-feedback-forum%2Fsuggestions%2F11116770-export-to-excel%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20the%20mean%20time%2C%20you%20can%20use%20Flow%20or%20third%20party%20tools%20to%20export%20the%20tasks%20to%20Excel.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

The management that planner does is great and it is better each day.

But we need to have more statistics from the tasks.

It would be great to have the information was manipulated in an spreadsheet to show the productive of each one of the team.

Is there a plan from Microsoft Planner developer team to implement it soon?

 

8 Replies
Highlighted
Best Response confirmed by Juan Carlos González Martín (MVP)
Solution
Hi, Please vote for this feature in User voice. MSFT is planning to work on this in future.
https://planner.uservoice.com/forums/330525-microsoft-planner-feedback-forum/suggestions/11116770-ex...

In the mean time, you can use Flow or third party tools to export the tasks to Excel.
Highlighted

Hi Santhosh,

 

Thanks a lot for your suggestion, I voted for this feature in user voice.

 

Based on your experience while Microsoft does not implement this feature, what do you suggest as take around?

 

Regards,

Mario Rodrigues

Highlighted
You can use Microsoft Flow to create Excel with Planner task details. But that's complicated as the all task details cannot be retrieved from Flow. You can find relevant discussions in this forum but they are complicated and time consuming to create.

A simple way would be to rely on third party apps for now to Export Planner tasks to Excel.
Highlighted

What 3rd party apps do you know that will do this?

Highlighted
Our own app named ' Apps4.Pro Planner Manager' will do this. It helps you to export all your Plans and Tasks with complete details including Comments, Checklists and Attachments to Excel. The same Excel can be used to modify and import back or can be used for creating new plans.
Highlighted
Highlighted

I Have created the WI and Tasks in planner. How can I export in to an excel sheet?

Highlighted

Hello,

I try to export tasks (35 bukclets and a lot of tasks finishing, pending ....)

Only 400 tasks are exported from Planer to Excel. Do you think, there is a FLOW export limitation?

Thanks & regards,

Emmanuel