Export to Excel
Ability to export Plan data to Excel
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
Kelly Mortensen commented
We dipped our toe into Planner just before Teams came out. How can we import our panner to the planner in teams with out manually entering. This is also true for onenote but probably a bigger Teams discussion.
Michael Rössler commented
Please create the possibility to invite external members und a function to export!
Elwyn Thompson commented
I voted for this too. It would be great for import/export to excel/file.
ALSO, my company is now using Project because of this.
It would be a great integrated feature if you could select rows in a Microsoft Project that you would want a Plan created from. Or company sees plans as a subset of work on a weekly scale from a larger Project at a monthly or quarterly schedule so we do not want to go back and forth maintaining both.
Theresa Morris commented
please provide some means with which to export the data - it is a great tool and this small addition would make it easy to provide reports
Thierry Bartholeyns commented
This is the only no go for us to use this product on certain projects because no reporting/extract is not viable.
Adds a calendar into my Office 365 and does not sync tasks to said (or any) calendar. Making it useless.
Export to Excel please! And sync tasks with Office 365 calendars.
Plans cannot be recovered if deleted; hence it is imperative that users be able to export plans.
Export functionality should be built-in
Thejus Baby commented
It is definitely a major need in organizations were there are a lot of teams and sub-teams for presenting their efforts for review.
334 votes, many comments and... nothing! Microsoft, please hire one or two developer(s) and make Planner a "production-ready" application!
I absolutely agree with the comments before. Export function to excel Is a key functionality-please add!
Please urgently add an export function to planner as this is a very basic need and planner should be compatible with other office applications.
that wen be cool
Pieter Pelser commented
Trello Export is a chrome extension with some novel ways of exporting to Excel perhaps Planner can do the same or better.
John Smith commented
(1) Tell us how we can find out when our Local Government Enterprise license will have the Planner tile available on our application dashboard.
(2) It's very frustrating that rollout started in June and we don't have it, yet.
(3) Our Microsoft rep cannot even tell us, which is not only frustrating but unfathomable.
Thanks for listening.
John Smith commented
Export / import to / from Project, please.
It looks like there is an existing request for this one with more votes--you may want to vote there instead. https://planner.uservoice.com/forums/330525-microsoft-planner-feedback-forum/suggestions/11116770-import-export-from-to-excel-project-etc
Currently, I click the Charts tab, then find the completed tasks, copy & paste to Excel, then match those to my original Excel list using a VLOOKUP.
S K commented
Why isn't this present in the first place! It's all in the MS family!