9,054 votes1111 comments · Microsoft Planner - Feedback Forum » Integrations · Flag idea as inappropriate… · Admin →
The export to Excel feature is complete! for more info check out our blog: https://techcommunity.microsoft.com/t5/Planner-Blog/Export-your-entire-plan-to-Excel-for-powerful-analysis-sharing/ba-p/717431
many of you are now asking for import from excel. Please vote for this feature and add your comments here: https://planner.uservoice.com/forums/330525-microsoft-planner-feedback-forum/suggestions/11730708-import-tasks-from-excel
The Planner Team
We don’t have any major updates to share at this time – Export to excel is still our first step towards delivering better reporting capabilities in Planner. You can find updates and discussion on this suggestion here:
Thank you for your patience and feedback! If you have any other suggestions on how you’d like to utilize reporting functionality in Planner, please comment below!
The Planner Team
An error occurred while saving the commentAnonymous commented
We use 1 Planner board per project and we want to import Planner task data into Power BI so Managers can view their subordinates' task across multiple projects in their manager dashboards with the rest of their data.
We also want to use it to monitor the limits of planner (250 assigned tasks per user, 1,500 created tasks per user). We create templates per project through the API, that user will easily hit the 1,500 limit and 250 assigned tasks per user may happen within a year. We want to catch those before the hit the limit and unassign completed tasks from users or make a new user for auto-creating tasks.